Exam Ref DP-900 Microsoft Azure Data Fundamentals

Exam Ref DP-900 Microsoft Azure Data Fundamentals

by Daniel A. Seara, Francesco Milano
Released March 2021
Publisher(s): Microsoft Press
ISBN: 9780137252145

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

Prepare for Microsoft Exam DP-900 Demonstrate your real-world foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. Designed for business users, functional consultants, and other professionals, this Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Data Fundamentals level.

Focus on the expertise measured by these objectives:

Describe core data concepts

Describe how to work with relational data on Azure

Describe how to work with non-relational data on Azure

Describe an analytics workload on Azure

This Microsoft Exam Ref:

Organizes its coverage by exam objectives

Features strategic, what-if scenarios to challenge you

Assumes you have foundational knowledge of core data concepts and their implementation with Microsoft Azure data services, and are beginning to work with data in the cloud

About the Exam

Exam DP-900 focuses on core knowledge for describing fundamental database concepts and skills for cloud environments; cloud data services within Azure; cloud data roles, tasks, and responsibilities; Azure relational and non-relational data offerings, provisioning, and deployment; querying Azure relational databases; working with Azure non-relational data stores; building modern Azure data analytics solutions; and exploring Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

About Microsoft Certification

Passing this exam fulfills your requirements for the Microsoft Certified: Azure Data Fundamentals certification, demonstrating your understanding of the core capabilities of Azure data services and their use with relational data, non-relational data, and analytics workloads.

See full details at:

www.microsoft.com/learn

Table of contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contents at a Glance
  5. Table of Contents
  6. Acknowledgments
  7. About the Authors
  8. Introduction
    1. Organization of this book
    2. Preparing for the exam
    3. Microsoft certifications
    4. Quick access to online references
    5. Errata, updates & book support
    6. Stay in touch
  9. Chapter 1. Describe core data concepts
    1. Skill 1.1: Describe types of core data workloads
    2. Skill 1.2: Describe data analytics core concepts
    3. Chapter summary
    4. Thought experiment
    5. Thought experiment answers
  10. Chapter 2. Describe how to work with relational data on Azure
    1. Skill 2.1: Describe relational data workloads
    2. Skill 2.2: Describe relational Azure data services
    3. Skill 2.3: Identify basic management tasks for relational data
    4. Skill 2.4: Describe query techniques for data using SQL language
    5. Chapter summary
    6. Thought experiment
    7. Thought experiment answers
  11. Chapter 3. Describe how to work with non-relational data on Azure
    1. Skill 3.1: Describe non-relational data workloads
    2. Skill 3.2: Describe non-relational data offerings on Azure
    3. Skill 3.3: Identify basic management tasks for non-relational data
    4. Chapter summary
    5. Thought experiment
    6. Thought experiment answers
  12. Chapter 4. Describe an analytics workload on Azure
    1. Skill 4.1: Describe analytics workloads
    2. Skill 4.2: Describe the components of a modern data warehouse
    3. Skill 4.3: Describe data ingestion and processing on Azure
    4. Skill 4.4: Describe data visualization in Microsoft Power BI
    5. Chapter summary
    6. Thought experiment
    7. Thought experiment answers
  13. Index
  14. Code Snippets

Product information

  • Title: Exam Ref DP-900 Microsoft Azure Data Fundamentals
  • Author(s): Daniel A. Seara, Francesco Milano
  • Release date: March 2021
  • Publisher(s): Microsoft Press
  • ISBN: 9780137252145