Microsoft
70-448 · Question #209
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your organization wants to track the times that products are ordered, shipped, and received in an existing cube. You need to enable…
The correct answer is C. Add a role-playing Time dimension to the cube via the Dimension Usage view. See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. Your organization wants to track the times that products are ordered, shipped, and received in an existing cube. You need to enable this tracking based on Sales, Orders, and Shipments fact tables. What should you do?
Options
- AAdd many-to-many relationships between the Sales, Orders, and Shipments fact tables.
- BAdd one Time dimension to each fact table.
- CAdd a role-playing Time dimension to the cube via the Dimension Usage view.
- DAdd a Time table to the underlying data and then add the table to the cube's Data Source View.
How the community answered
(39 responses)- A15% (6)
- B8% (3)
- C72% (28)
- D5% (2)
Community Discussion
No community discussion yet for this question.