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
100 min
40-60
700
Associate
Registration
$165 USD
Pearson VUE or online proctoring
English, Japanese, Chinese (Simplified), German +3 more
Validity
1 year
Pass renewal assessment on Microsoft Learn (free); Retake the certification exam
DP-600 Exam Topics and Domains
DP-600 is organized into 3 weighted domains. Expect to work with OneLake, Azure Active Directory, Azure DevOps, Dataflows, and more.
1
Maintain a data analytics solution
27.5%
Implement security and governance
Workspace-level access controlsItem-level access controlsRow-level, column-level, object-level, and file-level access controlSensitivity labels and endorsement
- Implement workspace-level access controls
- Implement item-level access controls
- Implement row-level, column-level, object-level, and file-level access control
- Apply sensitivity labels to items
- Endorse items
Maintain the analytics development lifecycle
Version control and deploymentImpact analysis and dependenciesXMLA endpoint and reusable assets
- Configure version control for a workspace
- Create and manage a Power BI Desktop project (.pbip)
- Create and configure deployment pipelines
- Perform impact analysis of downstream dependencies
- Deploy and manage semantic models by using the XMLA endpoint
- Create and update reusable assets
2
Prepare data
47.5%
Get data
Data connections and discoveryStorage choices
- Create a data connection
- Discover data by using OneLake data hub and real-time hub
- Ingest or access data as needed
- Choose between a lakehouse, warehouse, or eventhouse
- Implement OneLake integration for eventhouse and semantic models
Transform data
Database objects and schemasData transformation operations
- Create views, functions, and stored procedures
- Enrich data by adding new columns or tables
- Implement a star schema for a lakehouse or warehouse
- Denormalize data
- Aggregate data
- Merge or join data
- Identify and resolve duplicate data, missing data, or null values
- Convert column data types
- Filter data
Query and analyze data
Query languages and tools
- Select, filter, and aggregate data by using the Visual Query Editor
- Select, filter, and aggregate data by using SQL
- Select, filter, and aggregate data by using KQL
3
Implement and manage semantic models
27.5%
Design and build semantic models
Storage modes and model designRelationships and DAXAdvanced modeling features
- Choose a storage mode
- Implement a star schema for a semantic model
- Implement relationships
- Write calculations that use DAX variables and functions
- Implement calculation groups, dynamic format strings, and field parameters
- Identify use cases for and configure large semantic model storage format
- Design and build composite models
Optimize enterprise-scale semantic models
Performance optimizationDirect Lake and refresh strategies
- Implement performance improvements in queries and report visuals
- Improve DAX performance
- Configure Direct Lake, including default fallback and refresh behavior
- Implement incremental refresh for semantic models
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-600 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-15
- Announcement date: 2024-05-07
Updates
- OneLake GA Core storage layer for all Fabric workloads • Release date: 2024-03-01
- Eventhouse Preview Real-time analytics capabilities • Release date: 2024-06-01
- Mirroring Preview Database replication to OneLake • Release date: 2024-05-01
- Data Activator Preview Automated alerting and actions • Release date: 2024-04-01
Who should take this exam?
This exam is typically taken by Data Analysts and Business Intelligence Professionals.
- Experience with data modeling, data warehousing, and analytics
- Proficiency in SQL, KQL, or DAX
- Understanding of Microsoft Fabric components
- Experience with Power BI
- Knowledge of data security and governance principles
What jobs can I get with this?
Fabric Analytics Engineer
Business Intelligence Developer
Data Analytics Engineer
Power BI Developer
Analytics Solutions Architect