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.