Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
Proctored role-based exam that may include interactive components.
- Type
- Written
- Duration
- 100 min
Exam sections
Maintain a data analytics solution
Implement security and governance through workspace and item-level access controls, as well as row, column, and object-level security. Manage the analytics development lifecycle using version control, deployment pipelines, and impact analysis for lakehouses, warehouses, and semantic models.
Preparation tips
Focus on implementing security controls and managing the development lifecycle using Fabric-specific tools like deployment pipelines.
Prepare data
Ingest and transform data using OneLake and Real-Time hub. This section covers building star schemas, denormalizing data, and creating views or stored procedures. It also includes querying and analyzing data using SQL, KQL, and DAX to ensure data quality through filtering.
Preparation tips
Master data ingestion and transformation techniques in Fabric, including the use of SQL and KQL for querying and analysis.
Implement and manage semantic models
Design enterprise-scale semantic models with complex relationships and advanced DAX calculations. Optimize performance using calculation groups and field parameters, while configuring Direct Lake storage modes and implementing incremental refresh for large models.
Preparation tips
Ensure deep knowledge of DAX calculations and optimization strategies for enterprise-level semantic models in Microsoft Fabric.
