Microsoft
70-467 · Question #79
70-467 Question #79: Real Exam Question with Answer & Explanation
The correct answer is C: In the data warehouse, create a product dimension table that contains product name and. A properly structured physical dimension table in the data warehouse is the correct approach for implementing a product dimension following star schema best practices.
Question
You need to implement the product dimension. What should you do?
Options
- AIn the data warehouse, create a product dimension from a view that joins the Product and
- BIn the data warehouse, create a dimension table that contains product name and a
- CIn the data warehouse, create a product dimension table that contains product name and
- DIn the cube, create a named query that joins the Product and ProductColor tables in the
Explanation
A properly structured physical dimension table in the data warehouse is the correct approach for implementing a product dimension following star schema best practices.
Common mistakes.
- A. Building a dimension from a view that joins source tables at query time defers join processing until query execution, adding overhead and reducing performance compared to a pre-materialized dimension table.
- B. This option creates a dimension table but likely omits required attributes or uses an incomplete key structure, making it an insufficient definition for a fully specified product dimension.
- D. Creating a named query inside the cube embeds join logic in the SSAS layer rather than the data warehouse, violating separation of concerns and complicating future maintenance.
Concept tested. Dimensional modeling - physical product dimension table design
Community Discussion
No community discussion yet for this question.