The MC Microsoft Certified Azure Data Fundamentals Study Guide with Online Labs is your complete resource for one-stop coverage of the challenging DP-900 exam. This Sybex Study Guide covers 100% of the objectives, including core data concepts, relational and non-relational data types, and analytics workloads. You'll prepare for the exam faster with Sybex thanks to efficient and accurate content, including assessment tests that validate and measure exam readiness, real-world examples and scenarios, practical exercises, and challenging chapter review questions. Practice what you’ve learned with the Sybex online environment and test bank, accessible across multiple devices. Get prepared for the MC Azure Data Fundamentals exam with Sybex.
Coverage of 100% of all exam objectives in this Study Guide means you’ll be ready for:
- Describing core data concepts - Working with relational data on Azure - Working with non-relational data on Azure - Describing an analytics workload on Azure
ABOUT THE MC AZURE DATA FUNDAMENTALS CERTIFICATION
The MC Microsoft Certified Azure Data Fundamentals certification is the ideal credential for those with a foundational understanding how to implement core data concepts with the Microsoft Azure platform.
XtremeLabs provides IT training environments for Fortune 500 companies and organizations of any size. With a library of more than 900 IT hands-on labs, students and classes have experienced XtremeLabs in more than 150 countries.
Interactive learning environment
Take your exam prep to the next level with Sybex's superior interactive online study tools. Get more than 90% of the answers correct, and you’re ready to take the certification exam. - 100 electronic flashcards to reinforce learning and last-minute prep before the exam - Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully prepared
ABOUT THE XTREMELABS AZURE ONLINE LABS
So you can practice with hands-on learning in a real environment, Sybex has bundled XtremeLabs Azure virtual labs that run from your browser. The registration code is included with the book and gives you 6 months of unlimited access to XtremeLabs MC Azure Data Fundamentals Labs with 4 unique lab modules based on the book.
Table of Contents
Introduction xvii
Assessment Test xxvi
Answers to the Assessment Test xxxix
Chapter 1 Core Data Concepts 1
Describe Types of Core Data Workloads 2
Data Value 3
Data Volume 10
Data Variety 11
Data Velocity 14
Describe Data Analytics Core Concepts 21
Data Processing Techniques 21
Describe Analytics Techniques 32
Describe Data Visualization Techniques 34
Summary 40
Exam Essentials 41
Review Questions 44
Chapter 2 Relational Databases in Azure 49
Relational Database Features 51
Relational Database Design Considerations 51
Relational Database Offerings in Azure 61
Azure SQL 63
Azure Synapse Analytics Dedicated SQL Pools 90
Open-Source Databases in Azure 92
Management Tasks for Relational Databases in Azure 96
Deployment Scripting and Automation 96
Migrating to Azure SQL 105
Database Security 106
Common Connectivity Issues 113
Management Tools 115
Query Techniques for SQL 119
DDL vs. DML Commands 120
Query Relational Data in Azure SQL, MySQL, MariaDB, and PostgreSQL 125
Summary 129
Exam Essentials 130
Review Questions 132
Chapter 3 Nonrelational Databases in Azure 139
Nonrelational Database Features 140
Key-Value Store 141
Document Database 142
Columnar Database 143
Graph Database 144
Azure Cosmos DB 145
High Availability 146
Request Units 148
Azure Cosmos DB APIs 150
Management Tasks for Azure Cosmos DB 154
Deployment Options 154
Azure Cosmos DB Security 165
Azure Cosmos DB Common Connectivity Issues 167
Management Tools 169
Summary 170
Exam Essentials 171
Review Questions 174
Chapter 4 File, Object, and Data Lake Storage 177
File and Object Storage Features 178
Azure Storage 179
Performance Tiers 180
Data Redundancy 181
Deploying through the Azure Portal 182
Azure Storage Services 187
Management Tasks for Azure Storage 198
Deployment Scripting and Automation 198
Azure Storage Security 201
Azure Storage Common Connectivity Issues 212
Management Tools 213
Summary 217
Exam Essentials 218
Review Questions 221
Chapter 5 Modern Data Warehouses in Azure 225
Analytical Workload Features 226
Transactional vs. Analytical Workloads 226
Data Processing Techniques 229
Modern Data Warehouse Components 233
Data Modeling Best Practices for Data Warehouses 233
Azure Services for Modern Data Warehouses 234
End-to-End Analytics with Azure Synapse Analytics 268
Deploying an Azure Synapse Analytics Workspace 270
Navigating the Synapse Studio UI 271
Dedicated SQL Pools 275
Serverless SQL Pools 287
Summary 292
Exam Essentials 293
Review Questions 295
Chapter 6 Reporting with Power BI 301
Power BI at a Glance 302
Working with Power BI 303
Summary 324
Exam Essentials 325
Review Questions 326
Appendix Answers to the Review Questions 329
Chapter 1: Core Data Concepts 330
Chapter 2: Relational Databases in Azure 331
Chapter 3: Nonrelational Databases in Azure 333
Chapter 4: File, Object, and Data Lake Storage 334
Chapter 5: Modern Data Warehouses in Azure 335
Chapter 6: Reporting with Power BI 337
Index 339
