PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

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