Examers.io
ExamsOrganizationsHow it worksPricingHelp & FAQ
Sign inStart free
MICROSOFT

Microsoft Certified:Fabric Analytics Engineer Associate

DP-600

The Microsoft Certified: Fabric Analytics Engineer Associate certification validates your expertise in designing, creating, and deploying enterprise-scale data analytics solutions. It is ideal for professionals responsible for managing analytical assets and working with stakeholders to meet business requirements. Earning this certification demonstrates your ability to implement and manage semantic models and analyze data using SQL, KQL, and DAX.

Practice Free Questions

240 practice questions · Updated 2026-07-21

3Domains
7Objectives
68Concepts
240Questions

DP-600 Curriculum

Every domain, objective, and concept the DP-600 exam measures.

Implement security and governance

8 concepts · 36 questions
  1. Workspace-Level Access Controls
  2. Item-Level Access Controls
  3. Row-Level Access Control
  4. Column-Level Access Control
  5. Object-Level Access Control
  6. File-Level Access Control
  7. Apply Sensitivity Labels
  8. Endorse Items

Maintain the analytics development lifecycle

8 concepts · 42 questions
  1. Version Control Configuration
  2. Power BI Desktop Project Management
  3. Deployment Pipeline Creation
  4. Deployment Pipeline Configuration
  5. Impact Analysis
  6. Semantic Model Deployment
  7. Reusable Asset Creation
  8. Reusable Asset Management

Get data

8 concepts · 30 questions
  1. Data Connection Creation
  2. OneLake Catalog Discovery
  3. Real-Time Hub Discovery
  4. Data Ingestion Techniques
  5. Data Access Strategies
  6. Data Store Selection
  7. OneLake Integration for Eventhouse
  8. OneLake Integration for Semantic Models

Transform data

15 concepts · 59 questions
  1. Create Views
  2. Create Functions
  3. Create Stored Procedures
  4. Add Columns
  5. Add Tables
  6. Implement Star Schema
  7. Denormalize Data
  8. Aggregate Data
  9. Merge Data
  10. Join Data
  11. Resolve Duplicate Data
  12. Handle Missing Data
  13. Handle Null Values
  14. Convert Column Data Types
  15. Filter Data

Query and analyze data

16 concepts · 34 questions
  1. Visual Query Editor Basics
  2. Data Selection in Visual Query Editor
  3. Data Filtering in Visual Query Editor
  4. Data Aggregation in Visual Query Editor
  5. SQL Basics for Data Manipulation
  6. Data Selection in SQL
  7. Data Filtering in SQL
  8. Data Aggregation in SQL
  9. KQL Basics for Data Manipulation
  10. Data Selection in KQL
  11. Data Filtering in KQL
  12. Data Aggregation in KQL
  13. DAX Basics for Data Manipulation
  14. Data Selection in DAX
  15. Data Filtering in DAX
  16. Data Aggregation in DAX

Design and build semantic models

7 concepts · 23 questions
  1. Storage Mode Selection
  2. Star Schema Implementation
  3. Relationship Implementation
  4. DAX Calculations
  5. Calculation Groups and Dynamic Formats
  6. Large Model Storage Configuration
  7. Composite Model Design

Optimize enterprise-scale semantic models

6 concepts · 16 questions
  1. Query Performance Optimization
  2. Report Visuals Optimization
  3. DAX Performance Improvement
  4. Direct Lake Configuration
  5. Direct Lake Selection
  6. Incremental Refresh Implementation
Ready to practice?Test your knowledge with exam-style questions or take an intelligent quiz tailored to your level.
Practice Free Questions

Percentages reflect share of the current practice bank, not official exam weightings — no structured per-skill weight is published for DP-600, so none is invented.