Microsoft
70-448 · Question #94
70-448 Question #94: Real Exam Question with Answer & Explanation
The correct answer is D. You should develop two common relationships between the TimeTester dimension and the SalesTester. See the full explanation below for the reasoning.
Question
You are managing a SQL Server 2008 Analysis Services (SSAS) method which includes a dimension called TimeTester for Company.com. There is a table called SalesTester which includes the two columns named OrderTester and ShipTester. they are connected with TimeTester. You should make sure that you could get information by measures using the DimTime TimeTester. Which is the correct answer?
Options
- AYou should develop a one-to-many relationship between the TimeTester dimension and the OrderTester
- BYou should develop a many-to-one relationship between the ShipTester dimension and the SalesTester
- CYou should develop a many-to-many relationship between the TimeTester dimension and the ShipTester
- DYou should develop two common relationships between the TimeTester dimension and the SalesTester
Community Discussion
No community discussion yet for this question.