MC Microsoft Certified Azure Data Fundamentals Study Guide

Introduction xxvi

Assessment Test xvii

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

Contents xv

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