MC Microsoft Certified Azure Data Fundamentals Study Guide: Exam DP-900

ISBN-13: 9781119855835 / Angielski / Miękka / 2022 / 400 str.

Jake Switzer

Spis treści

Introduction xxviAssessment Test xviiAnswers to the Assessment Test xxxixChapter 1 Core Data Concepts 1Describe Types of Core Data Workloads 2Data Value 3Data Volume 10Data Variety 11Data Velocity 14Describe Data Analytics Core Concepts 21Data Processing Techniques 21Describe Analytics Techniques 32Describe Data Visualization Techniques 34Summary 40Exam Essentials 41Review Questions 44Chapter 2 Relational Databases in Azure 49Relational Database Features 51Relational Database Design Considerations 51Relational Database Offerings in Azure 61Azure SQL 63Azure Synapse Analytics Dedicated SQL Pools 90Open- Source Databases in Azure 92Management Tasks for Relational Databases in Azure 96Deployment Scripting and Automation 96Migrating to Azure SQL 105Database Security 106Common Connectivity Issues 113Management Tools 115Query Techniques for SQL 119DDL vs. DML Commands 120Query Relational Data in Azure SQL, MySQL, MariaDB, and PostgreSQL 125Summary 129Exam Essentials 130Review Questions 132Chapter 3 Nonrelational Databases in Azure 139Nonrelational Database Features 140Key- Value Store 141Document Database 142Columnar Database 143Graph Database 144Azure Cosmos DB 145High Availability 146Request Units 148Azure Cosmos DB APIs 150Management Tasks for Azure Cosmos DB 154Deployment Options 154Azure Cosmos DB Security 165Azure Cosmos DB Common Connectivity Issues 167Management Tools 169Summary 170Exam Essentials 171Review Questions 174Chapter 4 File, Object, and Data Lake Storage 177File and Object Storage Features 178Azure Storage 179Performance Tiers 180Data Redundancy 181Deploying through the Azure Portal 182Azure Storage Services 187Management Tasks for Azure Storage 198Deployment Scripting and Automation 198Azure Storage Security 201Azure Storage Common Connectivity Issues 212Management Tools 213Summary 217Exam Essentials 218Review Questions 221Chapter 5 Modern Data Warehouses in Azure 225Analytical Workload Features 226Transactional vs. Analytical Workloads 226Data Processing Techniques 229Modern Data Warehouse Components 233Data Modeling Best Practices for Data Warehouses 233Azure Services for Modern Data Warehouses 234End- to- End Analytics with Azure Synapse Analytics 268Deploying an Azure Synapse Analytics Workspace 270Contents xvNavigating the Synapse Studio UI 271Dedicated SQL Pools 275Serverless SQL Pools 287Summary 292Exam Essentials 293Review Questions 295Chapter 6 Reporting with Power BI 301Power BI at a Glance 302Working with Power BI 303Summary 324Exam Essentials 325Review Questions 326Appendix Answers to the Review Questions 329Chapter 1: Core Data Concepts 330Chapter 2: Relational Databases in Azure 331Chapter 3: Nonrelational Databases in Azure 333Chapter 4: File, Object, and Data Lake Storage 334Chapter 5: Modern Data Warehouses in Azure 335Chapter 6: Reporting with Power BI 337Index 339

O autorze

ABOUT THE AUTHORJAKE 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.