Exam DA-100 topic 2 question 4 discussion

Answer is D as the inactive relationship can be activate on fly with the "userelationship" dax function. With answer C the "minimize the model size" is not respected as the number of tables increases

However regarding to the minimize the model size I would say they mean D

If the ship date won't be used frequently for analysis, then creating an inactive relationship for the ship date and using the USERELATIONSHIP function in DAX can be a valid approach to minimize the size of the data model and simplify calculations. In this case, using an inactive relationship for the ship date can be helpful because it allows you to include the ship date in the data model without duplicating the Date table. This can save space in the data model, and it can make it easier to manage and update the Date table if necessary.

A reference code is a Power Query transformation that enables you to create a new query that refers to an existing query. This means that any changes made to the source query will automatically be reflected in the reference query. This is useful when you need to use the same data or transformations across multiple queries, as it avoids duplicating data and reduces the overall model size. Therefore, option C, which involves using a reference query in Power Query and creating active relationships between Sales and both Date tables in the modeling view, would be the most suitable design. This approach would minimize the model size and enable efficient queries to analyze the data by both purchase and ship dates independently and together.

The same use case is described here: https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive#inactive-relationships

I vote for D because it's not increasing the model !

I THINK D IS THE CORRECT ANSWER

I would vote for D.

Correct Answer is D. B will increase the model size. C will increase the number of queries against data source. (https://docs.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries)

From Microsoft here: https://docs.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive#refactoring-methodology Recommendations In summary, we recommend defining active relationships whenever possible. They widen the scope and potential of how your model can be used by report authors, and users working with Q&A. It means that role-playing dimension-type tables should be duplicated in your model. In specific circumstances, however, you can define one or more inactive relationships for a role-playing dimension-type table. You can consider this design when: There's no requirement for report visuals to simultaneously filter by different roles You use the USERELATIONSHIP DAX function to activate a specific relationship for relevant model calculations.

We cannot active and inactive relationship to analize both dates, so the anwer is C

i think

We cannot have an active and an inactive relationship if we want to analyze both, so the answer must be C

What is "both Date tables" means here? Is it mean both Date table and shipdate column? Microsoft exam makers do not understand English very well.

"analyze the data by both dates independently and together" To analyze both dates together we need two independent Date dimesions, therefore the answer should be B.

I think its D. Because the question states that "Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together." Which means we mostly use purchase_date and less often use ship_date. So If we have an active relationship with purchase_date we can use it and whenever we want to use ship_date we will use the RELATED() funtion for this relationship which basically works on the "many"(*) side of the relationship.

The answer is not C " The solution must minimize" ... "the number of queries against the data source" Reference: https://docs.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries