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


Question: You create a SQL Server 2008 R2 Analysis Services (SSAS) solution.

You are configuring security settings for a new database role with the following requirements:

Only the West member can be viewed by the database role. All other existing members and any newly added members of the Region attribute will not be visible. Members in attribute hierarchies that include a member of the Region attribute remain visible. The members in other attribute hierarchies remain visible.
The state of Washington is visible.
The aggregated totals for the ALL Level and Region attributes include only the values for members that are visible.

You need to ensure that the database role has these security settings.

What should you do? (Each correct answer presents part of the solution. Choose two.)

1)Set the Region attribute's IsAllowed = False, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = False.
2)Set the Region attribute's IsAllowed = True, DeniedSet = "Except(Region..Members,{West})", ApplyDenied = False, and VisualTools = True.
3)Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West})", ApplyDenied = True, and VisualTools = False.
4)Set the State attribute's IsAllowed = True, AllowedSet = "Except(Region..Members,{West} + {Washington})", ApplyDenied = False, and VisualTools = False.


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