Microsoft
70-448 · Question #24
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…
The correct answer is D. Create two regular relationships between the DimTime dimension and the FactSales measure group. See the full explanation below for the reasoning.
Question
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?
Options
- ACreate a reference relationship between the DimTime dimension and the FactSales measure group.
- BCreate a many-to-many relationship between the DimTime dimension and the FactSales measure group.
- CCreate two regular relationships between the DimTime dimension and the FactSales measure group.
- DCreate two regular relationships between the DimTime dimension and the FactSales measure group.
How the community answered
(67 responses)- A10% (7)
- B6% (4)
- C3% (2)
- D81% (54)
Community Discussion
No community discussion yet for this question.