Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
12 | |
11 |