Free Microsoft Power BI PL-300 Actual Exam Questions - Question 2 Discussion
HOTSPOT You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories. You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.) 
The related dimension tables are imported into the model. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. 
The fact table granularity looks right for basket analysis, so Yes on that.
Yes, the Sales table has the needed granularity to track product combos per transaction.
The granularity is definitely at the transaction line-item level since each row has a distinct TransactionID with ProductID, which is what you need for basket analysis to see which products appear together. The single-direction relationships from dimensions to Sales also make sense because you want to filter sales data by product, customer, or territory attributes, not the other way round. So that means no bidirectional filtering, which could create ambiguity or circular filters in this scenario. Also, the model looks like a classic star schema where single-direction filtering is best practice
I think the single-direction filters from dimensions to Sales make sense here since you want to slice sales by product and territory, not the other way around. Bidirectional might overcomplicate things without adding value.
I think the arrow directions suggest filtering flows from dimensions to Sales only, so no to bidirectional here. That setup avoids complicated filter paths and fits typical star schema best.
I’d say no to bidirectional since it risks circular filtering in complex models. Single-direction usually works better, especially with large sales data. The default arrow setup looks right for typical star schema filtering.
Yes, relationships should be bidirectional to analyze product combos fully across territories.
Are the relationships between Sales and dimension tables set to filter both directions?