Exam Ref DP-900 Microsoft Azure Data Fundamentals

✍ Scribed by Nicola Farquharson

• Publisher: Microsoft Press
• Year: 2024
• Tongue: English
• Leaves: 174
• Edition: 2
• Category: Library

✦ Synopsis

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

Cover
Title Page
Copyright Page
Contents at a glance
Contents
Introduction
Organization of this book
Microsoft certifications
Errata, updates, and book support
Stay in touch
Chapter 1 Describe core data concept
Skill 1.1: Describe ways to represent data
Describe features of structured data
Describe features of semi-structured data
Describe features of unstructured data
Skill 1.2: Identify options for data storage
Describe common formats for data files
Describe types of databases
Skill 1.3: Describe common data workloads
Describe features of transactional workloads
Describe features of analytical workloads
Skill 1.4: Identify roles and responsibilities for data workloads
Describe responsibilities for database administrators
Describe responsibilities for data engineers
Describe responsibilities for data analysts
Chapter summary
Thought experiment
Thought experiment answers
Chapter 2 Identify considerations for relational data on Azure
Skill 2.1: Describe relational concepts
Identify features of relational data
Describe normalization and how it is used
Identify common structured query language (SQL) statements
Identify common database objects
Skill 2.2: Describe relational Azure data services
Describe the Azure SQL family of products including Azure SQL Database, Azure SQL, Azure Managed Instance, and SQL Server on Azure Virtual Machines
Identify Azure database services for open-source database systems
Chapter summary
Thought experiment
Thought experiment answers
Scenario Exercises
Exercise 1: Create a Database and Table
Exercise 2: Explore the Scalability of Azure SQL Database
Exercise 3: Explore the Security Features of Azure SQL Database
Exercise 4: Explore Data Recovery in Azure SQL Database
Chapter 3 Describe considerations for working with non-relational data on Azure
Skill 3.1: Describe capabilities of Azure Storage
Describe Azure Blob storage
Describe Azure Data Lake Storage Gen2
Describe Azure File storage
Describe Azure Table storage
Skill 3.2: Describe capabilities and features of Azure Cosmos DB
Identify use cases for Azure Cosmos DB
Describe Azure Cosmos DB APIs
Chapter summary
Thought experiment
Thought experiment answers
Scenario Exercise
Exercise: Setting Up Azure Services for GHTC’s Telehealth Application
Chapter 4 Describe an analytics workload on Azure
Skill 4.1 Describe common elements of large-scale analytics
Describe large-scale data warehousing architecture
Describe considerations for data ingestion and processing
Describe options for analytical data stores
Describe Azure services for data warehousing
Skill 4.2 Describe consideration for real-time data analytics
Describe the difference between batch and streaming data
Identify Microsoft cloud services for real-time analytics
Skill 4.3 Describe data visualization in Microsoft Power BI
Identify capabilities of Power BI
Describe features of data models in Power BI
Chapter summary
Thought experiment
Thought experiment answers
Scenario Exercises
Task 1: Large-scale data ingestion and processing
Task 2: An analytical data store
Task 3: Real-time analytics
Task 4: Power BI visualization
Task 5: Azure data warehousing services
Chapter 5 DP-900 Microsoft Azure Data Fundamentals Exam Updates
The purpose of this chapter
About possible exam updates
Impact on you and your study plan
News and commentary about the exam objective updates
Updated technical content
Objective mapping
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z