Microsoft Certified: Fabric Analytics Engineer Associate Questions and Answers
200 questions organized by topic with detailed explanations
Microsoft
DP-600
200 questions
3 topics
Updated May 2026Maintain a data analytics solution
57 questions17 easy25 medium15 hard~27% of exam
A team needs read-only access to reports and semantic models in a workspace. Which workspace role should you assign?A shared Fabric workspace isn't connected to source control yet. Which workspace role is required to connect the workspa...A Fabric capacity admin wants analysts to query semantic models from external tools but not change metadata yet. What is...
Prepare data
87 questions21 easy47 medium19 hard~46% of exam
A Delta table is placed in the managed `Tables` area of a lakehouse. What does Fabric do automatically?A modeler stores customer names, addresses, and other descriptive attributes in a separate table to reduce repeated text...A team needs a temporary table that aligns with normal user tables and supports unlimited storage and T-SQL operations i...
Implement and manage semantic models
56 questions14 easy28 medium14 hard~27% of exam
You are configuring incremental refresh in Power BI Desktop. Which setup is required before you can define the policy?What kind of measures do calculation groups apply to in Power BI semantic models?Which storage mode retrieves data from the source system when visuals load instead of storing table data in the semantic...
All Questions
| # | Question | Topic | Difficulty |
|---|---|---|---|
| 1 | A Delta table is placed in the managed `Tables` area of a lakehouse. What does Fabric do automatical... | Prepare data | medium |
| 2 | You are configuring incremental refresh in Power BI Desktop. Which setup is required before you can ... | Implement and manage semantic models | medium |
| 3 | What kind of measures do calculation groups apply to in Power BI semantic models? | Implement and manage semantic models | easy |
| 4 | A modeler stores customer names, addresses, and other descriptive attributes in a separate table to ... | Prepare data | medium |
| 5 | A team needs a temporary table that aligns with normal user tables and supports unlimited storage an... | Prepare data | medium |
Sign in to see all 200 questions
Create a free account to browse all questions — completely free during our launch phase.
Ready to test your knowledge?
Take a full Microsoft Certified: Fabric Analytics Engineer Associate practice test with timed exam simulation.
Start Practice Test