get the app get the app       get the app       get the app


Question: 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?
1)You should consider designing three dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table.
2)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.
3)You should consider designing two dimension usage relationships between the CKTime dimension as well as the FactUsersTable fact table by identifying a regular relationship.
4)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.


Previous Next
Exam


Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material