Freshly Printed - allow 7 days lead
Couldn't load pickup availability
MC Microsoft Certified Azure Data Fundamentals Study Guide with Online Labs: Exam DP-900
Jake Switzer (Author)
9781394158454, Wiley
Paperback / softback, published 14 November 2022
400 pages
23.1 x 18.5 x 2.5 cm, 0.544 kg
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: 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: 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.
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
Subject Areas: Education [JN]
