Microsoft
70-448 · Question #259
You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Sales group. You configure a new role named…
The correct answer is C. Add the Roles=Northern Region; parameter to the connection string. See the full explanation below for the reasoning.
Question
You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains a database that is used by the members of the Sales group. You configure a new role named Northern Region by using the "{[Customers].[Region].[Region].[Northern]}' allowed permission set. You assign the Sales group to the Northern Region role. You need to verify that users in the Northern Region role can view data only for their region. What should you do?
Options
- ATemporarily add your account to the Northern Region role.
- BAdd the User ID=Northern Region; parameter to the connection string.
- CAdd the Roles=Northern Region; parameter to the connection string.
- DSelect the Enable Visual Totals check box for the Northern Region role.
How the community answered
(27 responses)- A7% (2)
- B19% (5)
- C70% (19)
- D4% (1)
Community Discussion
No community discussion yet for this question.