MC Microsoft Certified Azure Data Fundamentals Study Guide

MC Microsoft Certified Azure Data Fundamentals Study Guide

by Jake Switzer
Released May 2022
Publisher(s): Sybex
ISBN: 9781119855835

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

The most authoritative and complete study guide for people beginning to work with data in the Azure cloud

In MC Azure Data Fundamentals Study Guide: Exam DP-900, expert Cloud Solution Architect Jake Switzer delivers a hands-on blueprint to acing the DP-900 Azure data certification. The book prepares you for the test – and for a new career in Azure data analytics, architecture, science, and more – with a laser-focus on the job roles and responsibilities of Azure data professionals.

You’ll receive a foundational knowledge of core data concepts, like relational and non-relational data and transactional and analytical data workloads, while diving deep into every competency covered on the DP-900 exam. You’ll also get:

  • Access to complimentary online study tools, including hundreds of practice exam questions, electronic flashcards, and a searchable glossary
  • Additional prep assistance with access to Sybex’s superior interactive online learning environment and test bank
  • Walkthroughs of skills and knowledge that are absolutely necessary for current and aspiring Azure data pros in introductory roles

Perfect for anyone just beginning to work with data in the cloud, MC Azure Data Fundamentals Study Guide: Exam DP-900 is a can’t-miss resource for anyone prepping for the DP-900 exam or considering a new career working with Azure data.

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Acknowledgments
  5. About the Author
  6. About the Technical Editor
  7. Introduction
    1. Who Should Read This Book?
    2. Interactive Online Learning Environment and Test Bank
    3. DP-900 Exam Objectives
    4. Domain 1: Describe Core Data Components
    5. Domain 2: Describe How to Work with Relational Data on Azure
    6. Domain 3: Describe How to Work with Nonrelational Data on Azure
    7. Domain 4: Describe an Analytics Workload on Azure
    8. Assessment Test
    9. Answers to the Assessment Test
  8. Chapter 1: Core Data Concepts
    1. Describe Types of Core Data Workloads
    2. Describe Data Analytics Core Concepts
    3. Summary
    4. Exam Essentials
    5. Review Questions
  9. Chapter 2: Relational Databases in Azure
    1. Relational Database Features
    2. Relational Database Offerings in Azure
    3. Management Tasks for Relational Databases in Azure
    4. Query Techniques for SQL
    5. Summary
    6. Exam Essentials
    7. Review Questions
  10. Chapter 3: Nonrelational Databases in Azure
    1. Nonrelational Database Features
    2. Azure Cosmos DB
    3. Management Tasks for Azure Cosmos DB
    4. Summary
    5. Exam Essentials
    6. Review Questions
  11. Chapter 4: File, Object, and Data Lake Storage
    1. File and Object Storage Features
    2. Azure Storage
    3. Management Tasks for Azure Storage
    4. Summary
    5. Exam Essentials
    6. Review Questions
  12. Chapter 5: Modern Data Warehouses in Azure
    1. Analytical Workload Features
    2. Modern Data Warehouse Components
    3. End-to-End Analytics with Azure Synapse Analytics
    4. Summary
    5. Exam Essentials
    6. Review Questions
  13. Chapter 6: Reporting with Power BI
    1. Power BI at a Glance
    2. Summary
    3. Exam Essentials
    4. Review Questions
  14. Appendix: Answers to the Review Questions
    1. Chapter 1: Core Data Concepts
    2. Chapter 2: Relational Databases in Azure
    3. Chapter 3: Nonrelational Databases in Azure
    4. Chapter 4: File, Object, and Data Lake Storage
    5. Chapter 5: Modern Data Warehouses in Azure
    6. Chapter 6: Reporting with Power BI
  15. Index
  16. End User License Agreement

Product information

  • Title: MC Microsoft Certified Azure Data Fundamentals Study Guide
  • Author(s): Jake Switzer
  • Release date: May 2022
  • Publisher(s): Sybex
  • ISBN: 9781119855835