Transform Data DP-600 Practice Questions (Page 11)

Questions 51–55

1. 51expert · medium

   You have two Fabric lakehouse tables: Customers (CustomerID, Email, Name) and Orders (OrderID, CustomerID, OrderDate, Amount). Some customers have no orders, and some orders reference customers that do not exist in the Customers table. You need to create a comprehensive report that shows all customers and all orders, matching them where possible. Which join type should you use?

   • ALEFT OUTER JOIN from Customers to Orders on CustomerID.
   • BRIGHT OUTER JOIN from Customers to Orders on CustomerID.
   • CFULL OUTER JOIN between Customers and Orders on CustomerID.
   • DINNER JOIN between Customers and Orders on CustomerID.
   Reveal Solution Discussion Select an answer first
2. 52foundation · easy

   In Power Query, which step is used to change the data type of a column?

   • AChange Type
   • BTransform Data Type
   • CData Type Conversion
   • DConvert Column
   Reveal Solution Discussion Select an answer first
4. 53expert · medium

   A Fabric warehouse has a Products table that is the source of truth for product details, and a Sales table that references ProductID. Some Sales rows have ProductID values that do not exist in Products (orphaned rows). You need to create a report that shows all sales, including those with unknown products, and you must not lose any sales rows. Which join type should you use?

   • ARIGHT OUTER JOIN from Sales to Products on ProductID.
   • BLEFT OUTER JOIN from Sales to Products on ProductID.
   • CFULL OUTER JOIN between Sales and Products on ProductID.
   • DINNER JOIN between Sales and Products on ProductID.
   Reveal Solution Discussion Select an answer first
5. 54application · medium

   A Fabric warehouse has a normalized schema with separate tables for Customers, Orders, and OrderDetails. Business users frequently run a report that joins all three tables and filters by CustomerRegion and OrderDate. The report is slow. You need to improve query performance while keeping the warehouse manageable. What should you do?

   • ACreate an indexed view that includes only CustomerRegion and OrderDate, without the measure columns.
   • BAdd CustomerRegion and OrderDate as computed columns to the OrderDetails table and create a nonclustered index on them.
   • CCreate a materialized view that pre-joins Customers, Orders, and OrderDetails and includes CustomerRegion and OrderDate.
   • DDenormalize the data by copying all columns from the three tables into a single wide table and drop the original tables.
   Reveal Solution Discussion Select an answer first
6. 55foundation · easy

   Which type of join returns only the rows that have matching values in both tables?

   • ARIGHT JOIN
   • BFULL OUTER JOIN
   • CLEFT JOIN
   • DINNER JOIN
   Reveal Solution Discussion Select an answer first