Microsoft
70-448 · Question #233
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Engineering group. You configure a new role named Engineering…
The correct answer is C. Add the Roles= [Engineering and Design]; parameter to the connection string. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Engineering group. You configure a new role named Engineering and Design by using the following allowed permission set:
{[Employees].[Department].[Engineering and Design]} You assign the Engineering group to the Engineering and Design role. You need to ensure that users in the Engineering and Design role can only view data for their department. What should you do?
Options
- AAdd your account temporarily to the Engineering and Design role.
- BSelect the Enable Visual Totals check box for the Engineering and Design role.
- CAdd the Roles= [Engineering and Design]; parameter to the connection string.
- DAdd the User ID= [Engineering and Design]; parameter to the connection string.
How the community answered
(39 responses)- A5% (2)
- B3% (1)
- C85% (33)
- D8% (3)
Community Discussion
No community discussion yet for this question.