MicrosoftMicrosoft
DP-600 · Question #111
DP-600 Question #111: Real Exam Question with Answer & Explanation
Sign in or unlock DP-600 to reveal the answer and full explanation for question #111. The question stem and answer options stay visible for context.
Submitted by thandi_sa· Apr 18, 2026Implement and manage semantic models
Question
You have a Fabric workspace that contains a complex semantic model for a Microsoft Power BI report. You need to optimize the semantic model for analytical queries and use denormalization to reduce the model complexity and the number of joins between tables. Which tables should you denormalize?
Options
- Adimension tables on the same level of granularity
- Bfact tables on the same level of granularity
- Crole-playing dimension tables
- DSnowflaked dimension tables
Unlock DP-600 to see the answer
You've previewed enough free DP-600 questions. Unlock DP-600 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Semantic Model Optimization#Denormalization#Snowflake Schema#Data Modeling