In designing a Power BI data model for a
business, you are tasked with optimizing the fact and dimension tables. The
sales data is stored in a fact table, and you have customer, product, and date
dimensions. The goal is to improve query performance and provide meaningful
insights. Which of the following techniques would be most appropriate?

Question

Answer

Use calculated columns in the fact table to
store dimension attributes and avoid the need for separate dimension tables.

Answer

Denormalise the dimension tables and incorporate
all attributes directly into the fact table to reduce joins.

Answer

Create separate dimension tables for customer, product, and date, and
establish relationships with the fact table.

Answer

Implement a snowflake schema for both fact and
dimension tables to ensure a normalized structure.

Crowdly

In designing a Power BI data model for a business, you are tasked with optimizin...

Want instant access to all verified answers on moodle.telt.unsw.edu.au?