Exam Ref DP-900 Microsoft Azure Data Fundamentals, 2nd Edition

Book description

Prepare for Microsoft Exam DP-900 and 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 within Microsoft Azure

  • Describe how to work with both relational and non-relational data types on Azure

  • Describe strategic application, data management, storage and processing in the Azure cloud environment

  • Describe an analytics workload on Azure

This Microsoft Exam Ref:

  • Organizes its coverage by the Skills Measured list published for the exam

  • 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 a general grasp of cloud concepts

Table of contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contents at a glance
  5. Contents
  6. Introduction
    1. Organization of this book
    2. Microsoft certifications
    3. Errata, updates, and book support
    4. Stay in touch
  7. About the author
  8. Chapter 1. Describe core data concept
    1. Skill 1.1: Describe ways to represent data
    2. Skill 1.2: Identify options for data storage
    3. Skill 1.3: Describe common data workloads
    4. Skill 1.4: Identify roles and responsibilities for data workloads
    5. Chapter summary
    6. Thought experiment
    7. Thought experiment answers
  9. Chapter 2. Identify considerations for relational data on Azure
    1. Skill 2.1: Describe relational concepts
    2. Skill 2.2: Describe relational Azure data services
    3. Chapter summary
    4. Thought experiment
    5. Thought experiment answers
    6. Scenario Exercises
    7. Exercise 1: Create a Database and Table
    8. Exercise 2: Explore the Scalability of Azure SQL Database
    9. Exercise 3: Explore the Security Features of Azure SQL Database
    10. Exercise 4: Explore Data Recovery in Azure SQL Database
  10. Chapter 3. Describe considerations for working with non-relational data on Azure
    1. Skill 3.1: Describe capabilities of Azure Storage
    2. Skill 3.2: Describe capabilities and features of Azure Cosmos DB
    3. Chapter summary
    4. Thought experiment
    5. Thought experiment answers
    6. Scenario Exercise
    7. Exercise: Setting Up Azure Services for GHTC’s Telehealth Application
  11. Chapter 4. Describe an analytics workload on Azure
    1. Skill 4.1 Describe common elements of large-scale analytics
    2. Skill 4.2 Describe consideration for real-time data analytics
    3. Skill 4.3 Describe data visualization in Microsoft Power BI
    4. Chapter summary
    5. Thought experiment
    6. Thought experiment answers
    7. Scenario Exercises
    8. Task 1: Large-scale data ingestion and processing
    9. Task 2: An analytical data store
    10. Task 3: Real-time analytics
    11. Task 4: Power BI visualization
    12. Task 5: Azure data warehousing services
  12. Chapter 5. DP-900 Microsoft Azure Data Fundamentals Exam Updates
    1. The purpose of this chapter
    2. News and commentary about the exam objective updates
    3. Updated technical content
    4. Objective mapping
  13. Index

Product information

  • Title: Exam Ref DP-900 Microsoft Azure Data Fundamentals, 2nd Edition
  • Author(s): Nicola Farquharson
  • Release date: May 2024
  • Publisher(s): Microsoft Press
  • ISBN: 9780138262013