PL-300 Question 90

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  * Answer: - Summarizing Orders by CustomerID, OrderID, OrderDate → No - Removing CustomerID from Orders → No - Removing UnitPrice and Discount from Orders → Yes * Explanation: Statement 1 - If you summarize Orders at this grain, you lose line‑item detail (ProductID, UnitPrice, Quantity, Discount). - That means you can’t calculate Total Sales correctly, since sales are derived from line‑level math (UnitPrice * Quantity * (1-Discount)). Statement 2 - Removing CustomerID breaks the relationship between Orders and Customers. - Without it, you cannot calculate new vs. repeat customers. Statement 3 - If the Sales or Total column already exists in Orders (as shown in your exhibit), then UnitPrice and Discount are redundant for the required analysis. - Since the analysis only needs Total Sales, Order Counts, and Customer Counts, you can safely drop them.

• 1

  Summarizing Orders by CustomerID, OrderID, and OrderDate will reduce model size while supporting analysis. Yes Removing the CustomerID column from Orders will reduce model size while supporting analysis. No Removing the UnitPrice and Discount columns from Orders will reduce model size while supporting analysis. Yes

• 1

  NO NO YES