Mca Microsoft Certified Associate Azure Data Engineer Study Guide - Exam Dp-203

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...

List of contents

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
 
Variety 73
 
Velocity 74
 
Volume 74
 
Data Locations 74
 
Data File Formats 75
 
Data Structures, Types, and Concepts 83
 
Data Structures 83
 
Data Types and Management 92
 
Data Concepts 95
 
Data Programming and Querying for Data Engineers 125
 
Data Programming 126
 
Querying Data 143
 
Understanding Big Data Processing 169
 
Big Data Stages 169
 
Etl, Elt, Eltl 174
 
Analytics Types 175
 
Big Data Layers 176
 
Summary 177
 
Exam Essentials 177
 
Review Questions 179
 
Part II Design and Implement Data Storage 181
 
Chapter 3 Data Sources and Ingestion 183
 
Where Does Data Come From? 185
 
Design a Data Storage Structure 189
 
Design an Azure Data Lake Solution 190
 
Recommended File Types for Storage 198
 
Recommended File Types for Analytical Queries 199
 
Design for Efficient Querying 200
 
Design for Data Pruning 203
 
Design a Folder Structure That Represents the Levels of Data Transformation 203
 
Design a Distribution Strategy 205
 
Design a Data Archiving Solution 206
 
Design a Partition Strategy 207
 
Design a Partition Strategy for Files 209
 
Design a Partition Strategy for Analytical Workloads 210
 
Design a Partition Strategy for Efficiency and Performance 211
 
Design a Partition Strategy for Azure Synapse Analytics 211
 
Identify When Partitioning Is Needed in Azure Data Lake Storage Gen 2 212
 
Design the Serving/D

Product details

• Authors: Benjamin Perkins, Perkins Benjamin
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 06.09.2023
• EAN: 9781119885429
• ISBN: 978-1-119-88542-9
• No. of pages: 1008
• Series: Sybex Study Guide
• Subjects: Guides > Self-help, everyday life > Family; Natural sciences, medicine, IT, technology > Technology > Electronics, electrical engineering, communications engineering; Statistik, Informatik, Datenanalyse, Prüfungsvorbereitung, Statistics, Zertifizierung, computer science, test prep, data analysis, Microsoft Azure, Zertifizierung f. MSCE u. Novell, Certification (MSCE, Novell, etc.), Grid & Cloud Computing, Grid- u. Cloud-Computing