Microsoft Certified Azure Data Fundamentals Study Guide: with Online Labs: Exam DP-900

Everything you need to succeed on the MC Azure Data Fundamentals Exam, Now with 4 Online Lab Modules!

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. To access our learning environment, simply visit www.wiley.com/go/sybextestprep, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:

• Interactive test bank with a practice exam to help you identify areas where further review is needed. 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.

ABOUT THE AUTHOR

JAKE SWITZER is a Cloud Solution Architect at Microsoft specializing in Big Data and Advanced Analytics. He has worked with major athletics customers like the NBA, NFL, MLB, and the USGA on architecting and proving out big data and advanced analytics solutions in Azure.

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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.