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


Question: You work as a database administrator at Abc.com. You are responsible for managing a SQL Server 2008 Analysis Services (SSAS) database for Abc.com. The SSAS database contains a dimension named CKOrders. You are in the process of updating a role named Analyze. You decide to set the security for the Managers role at a later stage. You need to ensure that member of the Managers role are able to run data based on two or less customers. What should you do?
1)You should consider removing the customers of the [CKOrders].[Order] hierarchy which has more than two lower level roles to the allowed configuration for the Analyze role.
2)You should consider adding the customers of the [CKOrders].[Order] hierarchy which has more than two lower level roles to the allowed configuration for the Analyze role.
3)You should consider inserting the expression: [CKOrders].CurrentMember,,LEAVES).Count <= 2
4)You should consider inserting the expression: [CKOrders].CurrentMember,,LEAVES).Count <= 2, [CKOrders].[Order].CurrentMember, 0)


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