HOTSPOT You have the Power BI data model shown in the following exhibit. The Sales table has the following columns. The data model must support the following analysis:
• Total sales by product by month in which the order was placed
• Quantities sold by product by day on which the order was placed
• Number of sales transactions by quarter in which the order was placed For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Interactive Drag & Drop Matching
Drag each configuration to its target, or tap an option then tap a target slot.
Available Configurations3 remaining
Yes. - All required analysis is based on OrderDate (month, day, quarter). ShipDate is irrelevant...
No. - ProductID is the foreign key linking Sales to Product. Without it, you cannot analyze sales...
Yes. - LastUpdated is not needed for any of the required analyses (sales, quantities, transaction...
Targets & Placement
1Scenario 1
Drop configuration here
2Scenario 2
Drop configuration here
3Scenario 3
Drop configuration here
Explanation
Hotspot Solution:
Recommended Community Solution:
Answer: 1. Yes. - LastUpdated is not needed for any of the required analyses (sales, quantities, transactions by time). Dropping it reduces model size safely. 2. No. - ProductID is the foreign key linking Sales to Product. Without it, you cannot analyze sales by product. This column is essential. 3. Yes. - All required analysis is based on OrderDate (month, day, quarter). ShipDate is irrelevant here, so it can be removed.
Community Discussion
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
2
* Answer: 1. Yes. - LastUpdated is not needed for any of the required analyses (sales, quantities, transactions by time). Dropping it reduces model size safely. 2. No. - ProductID is the foreign key linking Sales to Product. Without it, you cannot analyze sales by product. This column is essential. 3. Yes. - All required analysis is based on OrderDate (month, day, quarter). ShipDate is irrelevant here, so it can be removed.
1
My vote in this Discussion will be for Yes - No - Yes
