PL-300 Question 7

Community Discussion

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

• Chose D2

  Step 1: Understand the data model You have three tables: Products → Product catalog (Dimension) Orders → Order-level information (Order ID, Date, Customer, etc.) Order Line Items → Product ID, Quantity, Price (Fact) The required analyses are: Orders sold over time with total order value Orders by product attributes Step 2: What is the bottleneck? To calculate total order value over time, every visual would otherwise need to: Join Orders and Order Line Items Sum Quantity × Price Doing this during report interaction is slower. Instead, merge these two tables during data refresh (Power Query), so the expensive join happens once, not every time a user interacts with a visual.

• Chose A1

  Use Transform and do ful ETL then finnally load the data is the standard proccess.

• Chose D1

  This produces a single denormalized fact table with order-level and line-level data combined. This improves performance because it avoids runtime relationship traversal and minimizes the number of tables involved in calculations.