Mc Microsoft Certified Azure Data Fundamentals Study Guide With - Online Labs: Exam Dp 90

Informationen zum Autor ABOUT THE AUTHOR JAKE 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. Klappentext 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:* Describing core data concepts* Working with relational data on Azure* Working with non-relational data on Azure* Describing an analytics workload on AzureABOUT THE MC AZURE DATA FUNDAMENTALS CERTIFICATIONThe 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 environmentTake 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:* Interactive test bank 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.* 100 electronic flashcards to reinforce learning and last-minute prep before the exam* Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully preparedABOUT THE XTREMELABS AZURE ONLINE LABSSo 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. Zusammenfassung 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:* Describing...

List of contents

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

Product details

• Authors: Switzer, J Switzer, Jake Switzer
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 30.09.2022
• EAN: 9781394158454
• ISBN: 978-1-394-15845-4
• No. of pages: 400
• Subjects: Guides > Self-help, everyday life > Family; Natural sciences, medicine, IT, technology > IT, data processing; Prüfungsvorbereitung, Azure, Zertifizierung, test prep, Microsoft Azure, Zertifizierung f. MSCE u. Novell, Certification (MSCE, Novell, etc.)