Answer-first summary for fast verification
Answer: ProductColor, ProductID, and ProductName.
In a star schema, dimension tables contain descriptive attributes that provide context for the measures in fact tables. The product dimension (DimProduct) should include columns that describe product characteristics, such as ProductID (the primary key), ProductName, and ProductColor. These are all descriptive attributes that identify and characterize products. Option A is correct because it contains only dimension attributes. Options B, C, and D are incorrect because they include columns that belong in the fact table: SalesAmount is a measure/quantity that should be in FactSales, Date is a time dimension attribute that should be in a separate date dimension table, and TransactionID is a transaction identifier that should be in the fact table. The community discussion confirms this with 100% consensus on A and explanations noting that dimension tables contain characteristics while fact tables contain measures like SalesAmount and Date.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You have a Fabric workspace named Workspace1 containing a lakehouse named Lakehouse1. The lakehouse has a table named Table1 with the provided data. You need to load this data into a star schema by creating a product dimension table named DimProduct and a fact table named FactSales.
Which three columns should be included in DimProduct?
A
ProductColor, ProductID, and ProductName.
B
ProductName, SalesAmount, and TransactionlD.
C
Date, ProductID, and TransactionlD.
D
ProductID, ProductName, and SalesAmount