Which Columns to Include in DimProduct for a Star Schema
You have a Fabric workspace named Workspace1 that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Table1. Table1 contains the following data. You need to perform the following actions: • Load the data from Table1 into a star schema. • Create a product dimension table named DimProduct and a fact table named FactSales. Which three columns should you include in DimProduct? - 
Community Votes
100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
Star schema dimension tables hold descriptive attributes and keys, while fact tables hold measures and transactional keys; including measures like SalesAmount in a dimension table is a common trap.
When designing a star schema in Microsoft Fabric, dimension tables must contain only descriptive attributes related to the entity. This page confirms that DimProduct should include ProductColor, ProductID, and ProductName, excluding fact measures.
Choosing an option that includes SalesAmount (Options B or D) because of confusion between dimension attributes and fact measures.
Community Discussion (3 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
Option A is correct because a dimension table in a star schema contains descriptive attributes about a specific entity, which in this case is the product. ProductID serves as the primary key, while ProductName and ProductColor are descriptive attributes that provide context. These columns appropriately define the product dimension without mixing in transactional or quantitative data.Why the Other Options Are Wrong
Options B and D are incorrect because they include SalesAmount, which is a numeric measure that belongs in the FactSales table, not a dimension table. Option C is incorrect because it includes Date and TransactionID; Date belongs in a date dimension (DimDate), and TransactionID is a transactional key that belongs in the FactSales table. Dimension tables should only contain attributes related to their specific entity.Community Comment Notes
The community agrees that Option A is the only choice excluding columns meant for fact tables. As MYPE noted, "A is the only suggestion that does not have columns that should be part of facts tables". JWJW1234 also pointed out that the selected columns "are the Dimension(Characteristics) of the product".Official Reference
Exam Strategy
When identifying columns for a dimension table in a star schema, look for descriptive attributes and the primary key of that specific entity. Exclude any numeric measures, transactional identifiers, or attributes belonging to other dimensions.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →