Analyzing Data with Microsoft Power BI (legacy) — Question 3

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates.
Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together.
You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source.
Which data modeling design should you use?

Answer options

• A. Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.
• B. Duplicate the Date query in Power Query and use active relationships between both Date tables.
• C. On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.
• D. Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Correct answer: C

Explanation

Option C is correct because it allows you to create active relationships for both the purchase and ship dates without duplicating data, optimizing model size and query efficiency. Option A is incorrect as it does not import the Date table, limiting analysis capabilities. Option B involves unnecessary duplication of the Date query, which could increase model size. Option D creates an inactive relationship for ship dates, which may hinder comprehensive analysis.