HOTSPOT
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 Type2 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:
1. Enable the analysis of customer orders based on historical attributes.
2. 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.
NOTE: Each correct selection is worth one point.
Select the correct area(s) on the image.
