Details

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

<p><b>ABOUT THE AUTHOR</b></p> <p><b>JAKE SWITZER</b> 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.

<p><b>Everything you need to succeed on the MC Azure Data Fundamentals Exam</b></p> <p>The<i> MC Microsoft Certified Azure Data Fundamentals Study Guide</i> 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. <p><b>Coverage of 100% of all exam objectives in this Study Guide means you’ll be ready for:</b> <ul><li>Describing core data concepts</li> <li>Working with relational data on Azure</li> <li>Working with non-relational data on Azure</li> <li>Describing an analytics workload on Azure</li></ul> <p><b>ABOUT THE MC AZURE DATA FUNDAMENTALS CERTIFICATION</b> <p>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. <p><b>Interactive learning environment</b> <p>Take your exam prep to the next level with Sybex’s superior interactive online study tools. To access our learning environment, simply visit <b>www.wiley.com/go/sybextestprep</b>, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to: <ul><li><b>Interactive test bank</b> with a practice exam to help you identify areas where further review is needed. Get more than 90% of the answers correct, and you’re ready to take the certification exam. </li> <li><b>100 electronic flashcards</b> to reinforce learning and last-minute prep before the exam </li> <li><b>Comprehensive glossary</b> in PDF format gives you instant access to the key terms so you are fully prepared</li></ul>

US