Microsoft Exam DA-100 Topic 11 Question 14 Discussion

Actual exam question for Microsoft's DA-100 exam

Question #: 14
Topic #: 11

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?

AUse the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

BDuplicate the Date query in Power Query and use active relationships between both Date tables.

COn the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

DCreate an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Show Suggested Answer

Suggested Answer: D

Only one relationship can be active.

Note: If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

by Alex at May 06, 2022, 09:10 AM

Limited Time Offer

25%

Off

Get Premium DA-100 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!