Question
You have a Fabric workspace that contains a lakehouse named Lakehouse1. Data is ingested into Lakehouse1 as one flat table. The table contains the following columns.
| Name | Description |
|---|---|
| TransactionID | Contains a unique ID for each transaction |
| Date | Contains the date of a transaction |
| ProductID | Contains a unique ID for each product |
| ProductColor | Contains a descriptive attribute that describes the color of each product |
| ProductName | Contains a unique name for each product |
| SalesAmount | Contains the sales amount of a transaction |
You plan to load the data into a dimensional model and implement a star schema. From the original flat table, you create two tables named FactSales and DimProduct. You will track changes in DimProduct.
You need to prepare the data.
Which three columns should you include in the DimProduct table? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Date
- B. ProductName Correct
- C. ProductColor Correct
- D. TransactionID
- E. SalesAmount
- F. ProductID Correct
Explanation
A product dimension holds the product's business key and its descriptive attributes, so DimProduct gets ProductID, ProductName, and ProductColor; tracking changes to those attributes (for example, as a slowly changing dimension) is done in this table. TransactionID, Date, and SalesAmount describe individual sales events and belong in FactSales, where SalesAmount is the measure and Date relates to a date dimension.
