HOTSPOT You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact table named FactSales that has one billion rows. You run the following T-SQL statement. CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales; For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
All three, CustomerCode, CustomerName, and SaleDate, fit as dimension table fields. SCD Type 2 is usually for tracking changes in things like customer details over time, so they'd be in dimensions not facts. SaleDate belongs in a date dimension, not a fact. Pretty standard data warehousing approach here but open to other takes if someone disagrees.
Wish Microsoft would standardize the terminology, always causes confusion. For a star schema with SCD Type 2, CustomerCode, CustomerName, and SaleDate all go in dimension tables, not fact-classic dimensional modeling logic.
