Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Wouldn't this work? A. Yes? Does anyone know why the exam questions are so vague about the approach? I don't even know if I can score if it's so ambiguous.
Hello @YoungLearning - Technically option A would be able to achieve the desired result, however it is not the best practice, which is why I think it is not the right answer. In general, duplicate (even copies by means of reference) Dim tables is a red flag and eludes to bloated/inefficient models and should be avoided. I agree that the correct answer to this question is no; I think the ambiguous part is that it does not specify (at least in what is seen above) that "Yes" should be chosen if the correct result can be obtained AND if it is done according to best practices.
For modeling overview, it is either you have a single date dimension and 3 reltionships with your fact table, linked to it one active and 2 inactive : (from Dim Date to your Fact table ) :
You need to make sure that the Dim Date contains unique values and in this case you call it a conformed/shared dimension.
Or you can have 3 role playing dimensions for dates that you call Dim Due Date, Dim Order Date and Dim Delivery date, you eliminate the dupliactes from the Due date and reference the 2 other queries.
So to achieve that the answer A is correct but as a best practice I would go for No.
When you reference a query, it's as though the steps in the referenced query are combined with, and run before, the steps in the referencing query3. You can duplicate a query to get an exact copy of the query with all steps, or reference a query to create a reference to the original query instead as a new query. The formula bar contains the syntax for referencing a specific row and column within Power Query.