You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. CubeA has a time dimension named CKTime that has an attribute named Month and a fact table named FactUsersTable. You need to include different hierarchies in the CKTime dimension. What should you do?

Question

TuteeHUB · Accepted Answer

You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a many-to-many relationship.

TuteeHUB · Answer

You should consider designing three dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table.

TuteeHUB · Answer

You should consider designing a single dimension usage relationship between the CKTime dimension as well as the FactUsersTable fact table by identifying a one-to-one relationship.

TuteeHUB · Answer

You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a regular relationship.

1.	You work as a database administrator for Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) project for Abc.com. CubeA has a time dimension named CKTime that has an attribute named Month and a fact table named FactUsersTable. You need to include different hierarchies in the CKTime dimension. What should you do?
A.	You should consider designing three dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table.
B.	You should consider designing a single dimension usage relationship between the CKTime dimension as well as the FactUsersTable fact table by identifying a one-to-one relationship.
C.	You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a regular relationship.
D.	You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a many-to-many relationship.
Answer» D. You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a many-to-many relationship.

Discussion

No Comment Found

Related MCQs

Reply to Comment