PrepAway - Latest Free Exam Questions & Answers

You need to enable this tracking based on Sales, Orders, and Shipments fact tables

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Add many-to-many relationships between the Sales, Orders, and Shipments fact tables.

B.
Add one Time dimension to each fact table.

C.
Add a role-playing Time dimension to the cube via the Dimension Usage view.

D.
Add a Time table to the underlying data and then add the table to the cube’s Data Source
View.


Leave a Reply