Informationen zum Autor ABOUT THE AUTHOR Benjamin Perkins is currently employed at Microsoft in Munich, Germany, as a Senior Escalation Engineer on the Azure team. He is a C# programming expert and cloud engineer who has been working professionally in the IT industry for almost three decades. His roles in IT have spanned the entire spectrum including programmer, system architect, technical support engineer, team leader, and mid-level management. While employed at Hewlett-Packard and Compaq Computer Corporation, he received numerous awards, degrees, and certifications. Klappentext Prepare for the Azure Data Engineering certification--and an exciting new career in analytics--with this must-have study aideIn the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203, accomplished data engineer and tech educator Benjamin Perkins delivers a hands-on, practical guide to preparing for the challenging Azure Data Engineer certification and for a new career in an exciting and growing field of tech.In the book, you'll explore all the objectives covered on the DP-203 exam while learning the job roles and responsibilities of a newly minted Azure data engineer. From integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions, you'll get up to speed quickly and efficiently with Sybex's easy-to-use study aids and tools.This Study Guide also offers: Career-ready advice for anyone hoping to ace their first data engineering job interview and excel in their first day in the field Indispensable tips and tricks to familiarize yourself with the DP-203 exam structure and help reduce test anxiety Complimentary access to Sybex's expansive online study tools, accessible across multiple devices, and offering access to hundreds of bonus practice questions, electronic flashcards, and a searchable, digital glossary of key termsA one-of-a-kind study aid designed to help you get straight to the crucial material you need to succeed on the exam and on the job, the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203 belongs on the bookshelves of anyone hoping to increase their data analytics skills, advance their data engineering career with an in-demand certification, or hoping to make a career change into a popular new area of tech. Zusammenfassung Prepare for the Azure Data Engineering certification--and an exciting new career in analytics--with this must-have study aideIn the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203, accomplished data engineer and tech educator Benjamin Perkins delivers a hands-on, practical guide to preparing for the challenging Azure Data Engineer certification and for a new career in an exciting and growing field of tech.In the book, you'll explore all the objectives covered on the DP-203 exam while learning the job roles and responsibilities of a newly minted Azure data engineer. From integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions, you'll get up to speed quickly and efficiently with Sybex's easy-to-use study aids and tools.This Study Guide also offers: Career-ready advice for anyone hoping to ace their first data engineering job interview and excel in their first day in the field Indispensable tips and tricks to familiarize yourself with the DP-203 exam structure and help reduce test anxiety Complimentary access to Sybex's expansive online study tools, accessible across multiple devices, and offering access to hundreds of bonus practice questions, electronic flashcards, and a searchable, digital glossary of key termsA one-of-a-kind study aid designed to help you get straight to the crucial material you need to succeed on the exam and on the j...

Autorentext

ABOUT THE AUTHOR Benjamin Perkins is currently employed at Microsoft in Munich, Germany, as a Senior Escalation Engineer on the Azure team. He is a C# programming expert and cloud engineer who has been working professionally in the IT industry for almost three decades. His roles in IT have spanned the entire spectrum including programmer, system architect, technical support engineer, team leader, and mid-level management. While employed at Hewlett-Packard and Compaq Computer Corporation, he received numerous awards, degrees, and certifications.

Klappentext

Prepare for the Azure Data Engineering certification--and an exciting new career in analytics--with this must-have study aide In the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203, accomplished data engineer and tech educator Benjamin Perkins delivers a hands-on, practical guide to preparing for the challenging Azure Data Engineer certification and for a new career in an exciting and growing field of tech. In the book, you'll explore all the objectives covered on the DP-203 exam while learning the job roles and responsibilities of a newly minted Azure data engineer. From integrating, transforming, and consolidating data from various structured and unstructured data systems into a structure that is suitable for building analytics solutions, you'll get up to speed quickly and efficiently with Sybex's easy-to-use study aids and tools. This Study Guide also offers: Career-ready advice for anyone hoping to ace their first data engineering job interview and excel in their first day in the field Indispensable tips and tricks to familiarize yourself with the DP-203 exam structure and help reduce test anxiety * Complimentary access to Sybex's expansive online study tools, accessible across multiple devices, and offering access to hundreds of bonus practice questions, electronic flashcards, and a searchable, digital glossary of key terms A one-of-a-kind study aid designed to help you get straight to the crucial material you need to succeed on the exam and on the job, the MCA Microsoft Certified Associate Azure Data Engineer Study Guide: Exam DP-203 belongs on the bookshelves of anyone hoping to increase their data analytics skills, advance their data engineering career with an in-demand certification, or hoping to make a career change into a popular new area of tech.

Inhalt

Introduction xxvii

Part I Azure Data Engineer Certification and Azure Products 1**

Chapter 1 Gaining the Azure Data Engineer Associate Certification 3

The Journey to Certification 7

How to Pass Exam DP- 203 8

Understanding the Exam Expectations and Requirements 9

Use Azure Daily 17

Read Azure Articles to Stay Current 17

Have an Understanding of All Azure Products 20

Azure Product Name Recognition 21

Azure Data Analytics 23

Azure Synapse Analytics 23

Azure Databricks 26

Azure HDInsight 28

Azure Analysis Services 30

Azure Data Factory 31

Azure Event Hubs 33

Azure Stream Analytics 34

Other Products 35

Azure Storage Products 36

Azure Data Lake Storage 37

Azure Storage 40

Other Products 42

Azure Databases 43

Azure Cosmos DB 43

Azure SQL Server Products 46

Additional Azure Databases 46

Other Products 47

Azure Security 48

Azure Active Directory 48

Role- Based Access Control 51

Attribute- Based Access Control 53

Azure Key Vault 53

Other Products 55

Azure Networking 56

Virtual Networks 56

Other Products 59

Azure Compute 59

Azure Virtual Machines 59

Azure Virtual Machine Scale Sets 60

Azure App Service Web Apps 60

Azure Functions 60

Azure Batch 60

Azure Management and Governance 60

Azure Monitor 61

Azure Purview 61

Azure Policy 62

Azure Blueprints (Preview) 62

Azure Lighthouse 62

Azure Cost Management and Billing 62

Other Products 63

Summary 64

Exam Essentials 64

Review Questions 66

Chapter 2 CREATE DATABASE dbName; GO 69

The Brainjammer 70

A Historical Look at Data 71

Vari…