Transform and Load the Data PL-300 Practice Questions (Page 10)

Questions 46–50

1. 46application · medium

   You have two Power Query queries: 'Orders' with columns OrderID, CustomerID, OrderDate, and Amount; and 'Customers' with columns CustomerID, CustomerName, and Region. You need to create a single query that includes all order details along with the corresponding customer name and region. Which operation should you use?

   • AGroup the 'Orders' query by CustomerID and then merge with 'Customers'.
   • BAppend the 'Customers' query to the 'Orders' query.
   • CDuplicate the 'Orders' query and then merge it with itself on CustomerID.
   • DMerge the 'Orders' and 'Customers' queries on the CustomerID column using a left outer join.
   Reveal Solution Discussion Select an answer first
2. 47foundation · easy

   In a star schema, which type of table contains descriptive attributes like product name, category, and color?

   • AMeasure table
   • BAggregate table
   • CFact table
   • DDimension table
   Reveal Solution Discussion Select an answer first
4. 48application · medium

   You have a table with columns: OrderID, Product, Category, and SalesAmount. You need to create a summary table that shows the total sales amount for each category. What should you do in Power Query?

   • AUse the 'Transpose' feature to swap rows and columns, then sum SalesAmount.
   • BUse the 'Group By' feature to group by Category and sum the SalesAmount.
   • CUse the 'Append' feature to combine the Category and SalesAmount columns.
   • DUse the 'Pivot' feature to pivot the Category column and sum SalesAmount.
   Reveal Solution Discussion Select an answer first
5. 49expert · hard

   You are designing a star schema for a sales analysis. You have a source table with columns: OrderID, OrderDate, CustomerID, CustomerName, ProductID, ProductName, Category, Quantity, UnitPrice, and Revenue. You need to create a fact table and dimension tables to normalize the model. Which approach should you take?

   • ACreate separate queries for the fact table (OrderID, OrderDate, CustomerID, ProductID, Quantity, UnitPrice, Revenue) and dimension tables for Customer and Product.
   • BLoad the source table as a single flat table and create relationships with itself.
   • CCreate separate tables for each column and then merge them back together.
   • DCreate a fact table that includes all columns, including CustomerName and ProductName.
   Reveal Solution Discussion Select an answer first
6. 50expert · hard

   A Power BI developer has a complex transformation query that is slow. They need to create a separate query for a dimension table that uses the same initial steps but then applies different transformations. They want to avoid duplicating the heavy transformation logic. What should they do?

   • ACreate a reference query from the base query and then add the different steps.
   • BCreate a new query that reads the same source and repeats the steps manually.
   • CUse a calculated table in DAX referencing the base query.
   • DDuplicate the base query and modify the copy.
   Reveal Solution Discussion Select an answer first