Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Microsoft Certified Azure Data Fundamentals (DP-900) Exam Guide
  • Toc
  • feedback
Microsoft Certified Azure Data Fundamentals (DP-900) Exam Guide

Microsoft Certified Azure Data Fundamentals (DP-900) Exam Guide

By : Steve Miles
5 (2)
close
Microsoft Certified Azure Data Fundamentals (DP-900) Exam Guide

Microsoft Certified Azure Data Fundamentals (DP-900) Exam Guide

5 (2)
By: Steve Miles

Overview of this book

Microsoft's Azure Data Fundamentals (DP-900) certification exam validates your expertise in core data concepts and Azure’s powerful data services capabilities. This comprehensive guide written by Steve Miles—a Microsoft Azure MVP and certified trainer with over 25 years of experience in cloud data services and 30+ certifications across major platforms—serves as your gateway to a future shaped by data and AI, regardless of your technical background. With the help of examples, you'll learn fundamental data concepts, including data representation, data storage options, and common workloads and gain clarity on the roles and responsibilities of key data professionals such as data administrators, engineers, and analysts. This guide covers all crucial exam domains, from data services capabilities of the Azure cloud platform to considerations for relational, non-relational, and analytics workloads, encompassing both Microsoft and open-source technologies. To supplement your exam prep, this book gives you access to a suite of online resources designed to boost your confidence, including mock tests, interactive flashcards, and invaluable exam tips By the end of this book, you’ll be fully prepared not only to pass the DP-900 exam but also to confidently tackle data solutions in Azure, setting a strong foundation for your data-driven career
Table of Contents (11 chapters)
close
close
Preface
chevron up
Preface
Who This Book Is For
What This Book Covers
How to Get the Most Out of This Book
Online Practice Resources
Download the Color Images
Conventions Used
Get in Touch
Share Your Thoughts
Download a Free PDF Copy of This Book
1
Chapter 1: Describe Core Data Concepts
Chapter 1: Describe Core Data Concepts
Making the Most Out of This Book – Your Certification and Beyond
Describe Ways to Represent Data
Identify Options for Data Storage
Describe Common Data Workloads
Identify Roles and Responsibilities for Data Workloads
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
Free Chapter
2
Chapter 2: Describe Relational Concepts
Chapter 2: Describe Relational Concepts
Identify Features of Relational Data
Describe Normalization and Why It Is Used
Identify Common Structured Query Language (SQL) Statements
Identify Common Database Objects
Summary
Exam Readiness Drill – Chapter Review Questions
Working On Timing
3
Chapter 3: Describe Relational Azure Data Services
Chapter 3: Describe Relational Azure Data Services
Microsoft SQL Databases on Azure
Open Source Databases on Azure
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
4
Chapter 4: Describe the Capabilities of Azure Storage
Chapter 4: Describe the Capabilities of Azure Storage
Azure Storage Services
Storage Accounts
Describe Azure Blob Storage
Describe Azure Files Storage
Describe Azure Table Storage
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
5
Chapter 5: Describe the Capabilities and Features of Azure Cosmos DB
Chapter 5: Describe the Capabilities and Features of Azure Cosmos DB
Identify Use Cases for Azure Cosmos DB
Describe Azure Cosmos DB APIs
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
6
Chapter 6: Describe the Common Elements of Large-Scale Analytics
Chapter 6: Describe the Common Elements of Large-Scale Analytics
Describe Considerations for Data Ingestion and Processing
Describe Options for Analytical Data Stores
Describe Azure Services for Data Warehousing
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
7
Chapter 7: Describe Consideration for Real-Time Data Analytics
Chapter 7: Describe Consideration for Real-Time Data Analytics
Describe the Difference between Batch and Streaming Data
Identify Microsoft Cloud Services for Real-Time Analytics
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
8
Chapter 8: Describe Data Visualization in Microsoft BI
Chapter 8: Describe Data Visualization in Microsoft BI
Identify the Capabilities of Power BI
Describe Core Concepts of Data Modeling
Describe the Features of Data Models in Power BI
Identify Appropriate Visualizations for Data
Summary
Additional Reading
Exam Readiness Drill – Chapter Review Questions
Working On Timing
9
Chapter 9: Accessing the Online Practice Resources
Chapter 9: Accessing the Online Practice Resources
How to Access These Materials
Troubleshooting Tips
Back to the Book
Why subscribe?
10
Other Books You May Enjoy
Other Books You May Enjoy
Share Your Thoughts
Download a Free PDF Copy of This Book

What This Book Covers

Chapter 1, Describe Core Data Concepts, includes content covering core data concepts such as structured, semi-structured, and unstructured data features; common formats for data files and types of databases; the features of transactional and analytical workloads; and the responsibilities of data-related roles such as administrators, engineers, and analysts.

Chapter 2, Describe Relational Concepts, includes content covering the features of relational data, understanding normalization, and identifying common Structured Query Language (SQL) statements and common database objects.

Chapter 3, Describe Relational Azure Data Services, includes content covering the SQL product family available in Azure and open source database systems.

Chapter 4, Describe the Capabilities of Azure Storage, includes content covering the Blob, File, and Table Storage services available in Azure.

Chapter 5, Describe the Capabilities and Features of Azure Cosmos DB, includes content covering Azure Cosmos DB use cases and the APIs of Azure Cosmos DB.

Chapter 6, Describe the Common Elements of Large-Scale Analytics, includes content covering data ingestion and processing considerations, analytical data store options, and data warehousing services in Azure.

Chapter 7, Describe Consideration for Real-Time Data Analytics, includes content covering the differences between batch and streaming data and exploring real-time analytics services in Azure.

Chapter 8, Describe Data Visualization in Microsoft BI, includes content covering Power BI capabilities, data model features, and data visualizations.

Next Section
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete