Exam PL-300 topic 1 question 7 discussion

I'm very sure it's D. It's the Header/Detail Schema, and the most optimal way is to flatten the header into the detail table.

Should be A, because we need to get " Orders sold over time that include a measure of the total order value Orders by attributes of products sold" Order line detail for quantities ordered, and product for product's attribute

The order table's description says "contain high level information about order". Nothing else. And most importantly, the requirement is 1) order quantity, 2) order value and 3) order by product attributes - nothing else valuable can be acquired from the order table? Therefore if the requirement is to minimize update time of visual, don't bother connecting order and order line item table. Answer should be A

Answer is D. Tried and Tested.

Why not D: Merging these two tables would help calculate the total order value but does not associate product attributes (e.g., categories) with orders. Without merging Order Line Items and Products, you cannot analyze orders by product attributes effectively.

Note: We must suggest the action we should perform FIRST. Of course, we need the Products table for the product attributes but first, we need to merge the Orders and Order Line Items to get the time-based information from the Orders table. We need that for the "Orders sold over time". The Order Line Items table does not have time-based information(Date). As per the question, it only has those 3 columns. After using number D as the first step, we can merge the Product table, write DAX for total order value, etc...

I choose A. The Products table contains product attributes (e.g., category, brand), but it cannot directly connect to the Orders table since there’s no shared key. The Order Line Items table acts as a bridge between the Products table (via Product ID) and the Orders table (via Order ID). By merging Products with Order Line Items, the resulting table includes both product attributes and order-level details, enabling comprehensive analysis. For analysis 1 (orders sold over time with total order value): Use the merged table to calculate total order value (Quantity × Price) for each order and aggregate by the order date from the Orders table. For analysis 2 (orders by product attributes): Filter and group the merged table by product attributes (e.g., category or brand) to analyse sales performance for specific product groups.

D is right, Merging the Orders query with the Order Line Items query in Power Query creates a more efficient data model. This reduces the number of relationships and joins that need to be processed during report interactions, leading to faster update times. With the merged data, calculations such as total order value and orders by product attributes become simpler and more efficient. This reduces the need for complex DAX calculations that can slow down report performance

The Order Line Items table contains only the following columns: Product ID Quantity Price Details It does not include a date column or other high-level order information. The Orders table, on the other hand, likely contains essential information such as: Order Date (for time-based analysis) Order ID (to link with Order Line Items) Customer Details (if needed) so Answer is D

D - From Power Query, merge the Orders query and the Order Line Items query

Hello everyone, to make it clear we must to know: --- PBI will do the best aggregation base on Star Schema model, we now have 1 Fact table (Order Line Items) and 2 Dim tables (Products, Orders). Orders has common field with Products (ProductID), and pretty sure time series field (OrderDate); Orders Line Items has Price and Quanity. --- We need summarize some values like "price" and "quantity" over-time by attributes product. But we only have common field in Dim table (Orders) so we need to merge Dim (Orders) and Fact (Order Line Items) to new single Fact table to design the right Star Schema model. => So that D is correct

Might be option A. How about the orders by attribute without accessing the Product datasource ?

We need first, in such way to join orders and order line query. So the right answer is: D. From Power Query, merge the Orders query and the Order Line Items query.

D. Since Order and Order Lines tables are parts of the fact table, so combine them first and make the combination the centre of the star schema, then join the DIM table Product.

D. From Power Query, merge the Orders query and the Order Line Items query. By merging these queries, you create a single table that contains all the necessary information about orders and their line items. This simplifies the data model and reduces the overhead of handling multiple tables and relationships, leading to more efficient interactions with visuals in your report.

D - Consolidate the order and order line items query first - you will need information from both tables

The main advantage of D over A is that Merging Orders with Order Line Items creates a fact table in a star schema, instead of having two fact table.