DP-600microsoft

Microsoft Fabric Analytics Engineer Associate

Microsoft Fabric Analytics Engineer Associate official-source-aligned practice bank.

Official study guide

Free — no charge

3 modules360 practice questions

Maintain a data analytics solution

Study the official objectives for Maintain a data analytics solution.

25-30%

Implement security and governanceMaintain the analytics development lifecycle

Implement security and governance

Intermediate20 min

Review the official skills for Implement security and governance and practice applying them to scenarios.

Implement workspace-level access controls:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement item-level access controls:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement row-level, column-level, object-level, and file-level access control:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Apply sensitivity labels to items:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Endorse items:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Maintain the analytics development lifecycle

Intermediate20 min

Review the official skills for Maintain the analytics development lifecycle and practice applying them to scenarios.

Configure version control for a workspace:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Create and manage a Power BI Desktop project (.pbip):: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Create and configure deployment pipelines:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Perform impact analysis of downstream dependencies from lakehouses, warehouses, dataflows, and semantic models:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Deploy and manage semantic models by using the XMLA endpoint:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Create and update reusable assets, including Power BI template (.pbit) files, Power BI data source (.pbids) files, and shared semantic models:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Prepare data

Study the official objectives for Prepare data.

45-50%

Get dataTransform dataQuery and analyze data

Get data

Intermediate20 min

Review the official skills for Get data and practice applying them to scenarios.

Create a data connection:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Discover data by using OneLake catalog and Real-Time hub:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Ingest or access data as needed:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Choose between different data stores:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement OneLake integration for Eventhouse and semantic models:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Transform data

Intermediate20 min

Review the official skills for Transform data and practice applying them to scenarios.

Create views, functions, and stored procedures:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Enrich data by adding new columns or tables:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement a star schema for a lakehouse or warehouse:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Denormalize data:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Aggregate data:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Merge or join data:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Identify and resolve duplicate data, missing data, or null values:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Convert column data types:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Filter data:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Query and analyze data

Intermediate20 min

Review the official skills for Query and analyze data and practice applying them to scenarios.

Select, filter, and aggregate data by using the Visual query editor:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Select, filter, and aggregate data by using SQL:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Select, filter, and aggregate data by using KQL:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Select, filter, and aggregate data by using DAX:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Implement and manage semantic models

Study the official objectives for Implement and manage semantic models.

25-30%

Design and build semantic modelsOptimize enterprise-scale semantic modelsIn this article

Design and build semantic models

Intermediate20 min

Review the official skills for Design and build semantic models and practice applying them to scenarios.

Choose a storage mode:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement a star schema for a semantic model:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement relationships, such as bridge tables and many-to-many relationships:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Write calculations that use DAX variables and functions, such as iterators, table filtering, windowing, and information functions:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement calculation groups, dynamic format strings, and field parameters:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Identify use cases for and configure large semantic model storage format:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Design and build composite models:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Optimize enterprise-scale semantic models

Intermediate20 min

Review the official skills for Optimize enterprise-scale semantic models and practice applying them to scenarios.

Implement performance improvements in queries and report visuals:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Improve DAX performance:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Configure Direct Lake, including default fallback and refresh behavior:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Choose between Direct Lake on OneLake and Direct Lake on SQL analytics endpoint:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Implement incremental refresh for semantic models:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Last updated on 2026-09-18:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600

Light:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Dark:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
High contrast:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
AI Disclaimer:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Previous Versions:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Blog:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Contribute:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Privacy:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Consumer Health Privacy:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Terms of Use:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600
Trademarks:: https://learn.microsoft.com/en-us/credentials/certifications/resources/study-guides/dp-600