DP-700 · Question #48
DP-700 Question #48: Real Exam Question with Answer & Explanation
Sign in or unlock DP-700 to reveal the answer and full explanation for question #48. The question stem and answer options stay visible for context.
Question
You have a Fabric workspace that contains two lakehouses named Lakehouse1 and Lakehouse2. Lakehouse1 contains staging data in a Delta table named Orderlines. Lakehouse2 contains a Type 2 Slowly changing dimension (SCD) dimension table named Dim_Customer. You need to build a query that will combine data from Orderlines and Dim_Customer to create a new fact table named Fact_Orders. The new table must meet the following requirements: - Enable the analysis of customer orders based on historical attributes. - Enable the analysis of customer orders based on the current attributes. How should you complete the statement? To answer, select the appropriate options in the answer area. SELECT orderLineID order_line_id ,OrderDate order_date ,c.customer_key ,c.customer_id ,Quantity order_quantity ,UnitPrice unit_price ,TaxRate tax_rate FROM Lakehouse1.orderlines o INNER JOIN lakehouse2.dim_customer c ON o.customerid = c.customer_id AND -- DROPDOWN 1 selections here AND -- DROPDOWN 2 selections here
Unlock DP-700 to see the answer
You've previewed enough free DP-700 questions. Unlock DP-700 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.