PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer to take method to do it?

You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.

Some object show below in the cube
* A time dimension named TimeDimension that has an attribute named TimeKiller.
* A fact table named FactOrdersTable.

Different hierarchies should be included in the Time dimension,
You should take method to do it

Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should design three dimension usage relationships between the Time dimension and the FactOrdersTable fact table.

B.
By defining a one-to-one relationship, you should design a single dimension usage relationship between the Time dimension and the FactOrdersTable fact table.

C.
By defining a regular relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table

D.
By defining a many-to-many relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table


Leave a Reply