PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
You should develop a one-to-many relationship between the TimeTester dimension and
the OrderTester measure group.

B.
You should develop a many-to-one relationship between the ShipTester dimension and
the SalesTester measure group.

C.
You should develop a many-to-many relationship between the TimeTester dimension and
the ShipTester measure group.

D.
You should develop two common relationships between the TimeTester dimension and
the SalesTester measure group. You should not utilize same columns of measure group.


Leave a Reply