Microsoft
70-448 · Question #24
70-448 Question #24: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #24. The question stem and answer options stay visible for context.
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.
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.