PrepAway - Latest Free Exam Questions & Answers

You need to ensure that the DimTime dimension can be used to browse through measures in the FactSales table fo

You create a SQL Server 2008 Analysis Services (SSAS) solution.
The solution contains a time dimension named DimTime. You have a table named FactSales
that contains the two columns named OrderDate and ShipDate. The two columns refer to the
DimTime dimension.
You need to ensure that the DimTime dimension can be used to browse through measures
in the
FactSales table for both OrderDate and ShipDate.

What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Create a reference relationship between the DimTime dimension and the FactSales
measure group.

B.
Create a many-to-many relationship between the DimTime dimension and the FactSales
measure group.

C.
Create two regular relationships between the DimTime dimension and the FactSales
measure group. Use identical measure group columns.

D.
Create two regular relationships between the DimTime dimension and the FactSales
measure group. Use different measure group columns.


Leave a Reply