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
