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


Question: You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) solution for Abc.com. Your solution contains a data source view (DSV) that owns a table named CKUsers. The CKUsers table contains a field named UserKey and a field named ManagerKey. The ManagerKey references the manager of the Abc.com user. You need to create a relationship between the users and their managers in the DSV. What should you do?
1)You should consider developing a View that makes use of UserKey and ManagerKey.
2)You should consider developing a Measure that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column.
3)You should consider developing a Query that makes use of a relationship with UserKey as the source column and ManagerKey as the destination column.
4)You should consider developing a relationship as the source column and UserKey as the destination column using the ManagerKey.


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