Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Microsoft
Exam Format
45 min
40-60
700
Fundamentals
Registration
$99 USD
Pearson VUE, Certiport, or online proctoring
Validity
No expiration
Not required for fundamentals certification
DP-900 Exam Topics and Domains
DP-900 is organized into 4 weighted domains. Expect to work with Azure SQL Database, Azure Cosmos DB, Azure Data Factory, Power BI, and more.
1
Describe core data concepts
27.5%
Describe ways to represent data
Describe features of structured dataDescribe features of semi-structured dataDescribe features of unstructured data
- Differentiate between structured, semi-structured, and unstructured data
- Identify appropriate storage solutions for each data type
Identify options for data storage
Describe common formats for data filesDescribe types of databases
- Select appropriate file formats for different scenarios
- Choose the right database type for specific workloads
Describe common data workloads
Describe features of transactional workloadsDescribe features of analytical workloads
- Distinguish between transactional and analytical workloads
- Identify appropriate Azure services for each workload type
Identify roles and responsibilities for data workloads
Describe responsibilities for database administratorsDescribe responsibilities for data engineersDescribe responsibilities for data analysts
- Understand different data professional roles
- Map responsibilities to appropriate Azure services
2
Identify considerations for relational data on Azure
22.5%
Describe relational concepts
Identify features of relational dataDescribe normalization and why it is usedIdentify common structured query language (SQL) statementsIdentify common database objects
- Understand relational database fundamentals
- Write basic SQL statements
- Identify database objects and their uses
Describe relational Azure data services
Describe the Azure SQL family of productsIdentify Azure database services for open-source database systems
- Compare Azure SQL offerings
- Select appropriate database service for specific requirements
3
Describe considerations for working with non-relational data on Azure
17.5%
Describe capabilities of Azure storage
Describe Azure Blob storageDescribe Azure File storageDescribe Azure Table storage
- Understand Azure storage options
- Select appropriate storage service for different data types
Describe capabilities and features of Azure Cosmos DB
Identify use cases for Azure Cosmos DBDescribe Azure Cosmos DB APIs
- Understand Cosmos DB capabilities
- Select appropriate Cosmos DB API for specific workloads
4
Describe an analytics workload on Azure
27.5%
Describe common elements of large-scale analytics
Describe considerations for data ingestion and processingDescribe options for analytical data storesDescribe Microsoft cloud services for large-scale analytics
- Understand large-scale analytics architecture
- Select appropriate analytics services
Describe consideration for real-time data analytics
Describe the difference between batch and streaming dataIdentify Microsoft cloud services for real-time analytics
- Differentiate batch and streaming analytics
- Choose appropriate real-time analytics services
Describe data visualization in Microsoft Power BI
Identify capabilities of Power BIDescribe features of data models in Power BIIdentify appropriate visualizations for data
- Understand Power BI capabilities
- Create effective data visualizations
How do I earn this certification?
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
The most effective way to prepare for DP-900 is by using the PlanetCert Simulator to practice questions and review detailed explanations.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2024-11-01
Updates
- Microsoft Fabric GA Added to exam objectives in November 2024 update • Release date: 2023-11-15
- Azure Synapse Analytics Continuous updates Core component of analytics domain • Release date: Ongoing
- Power BI Monthly updates Visualization concepts remain stable • Release date: Monthly
Who should take this exam?
This exam is typically taken by Individuals beginning to work with data in the cloud and Database administrators exploring cloud options.
- Basic awareness of computing and Internet concepts
- Interest in extracting insights from data
- Familiarity with basic cloud concepts