Microsoft
70-448 · Question #84
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…
The correct answer is C. By defining a regular relationship for both the dimension usages, you should design two dimension. See the full explanation below for the reasoning.
Question
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?
Options
- AYou should design three dimension usage relationships between the Time dimension and the
- BBy defining a one-to-one relationship, you should design a single dimension usage relationship
- CBy defining a regular relationship for both the dimension usages, you should design two dimension
- DBy defining a many-to-many relationship for both the dimension usages, you should design two dimension
How the community answered
(27 responses)- A4% (1)
- B19% (5)
- C70% (19)
- D7% (2)
Community Discussion
No community discussion yet for this question.