BenchMark Quizzes by MDFT Pro

Choose the tables to denormalize

You work for MDFT Pro, a well-known training agency that uses Microsoft Fabric for data analytics. Your team maintains a Fabric workspace containing a complex semantic model for Power BI reports.

To improve query performance, you need to optimize the semantic model by denormalizing appropriate tables to reduce model complexity and minimize the number of joins between tables.

Which tables should you denormalize?

Choose the correct answer from the options below.

Explanations for each answer:

Fact tables on the same level of granularity is incorrect. Fact tables, even those with the same granularity, typically represent different business processes or metrics. Denormalizing these would mix different business contexts together and could lead to incorrect aggregations and analysis.
Snowflaked dimension tables is correct.
Role-playing dimension tables is incorrect. Role-playing dimensions are already optimized for their specific roles in the model. Denormalizing these would mix unrelated roles together and could lead to redundant data and increased model complexity.
Dimension tables on the same level of granularity is incorrect. Dimension tables at the same granularity level are already properly structured for their specific purposes. Denormalizing these will increase model complexity and would not provide any performance benefits.

Learn more about optimizing Fabric data warehouse:

Optimize Fabric Data Warehouse

Exam Preparation Quiz

Choose the tables to denormalize