Microsoft
70-448 · Question #299
You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis Services (SSAS) database. The database contains a dimension named Employee. You plan to configure the…
The correct answer is C. Add the following expression to the Allow Reading property in Cell Data in the Managers role. See the full explanation below for the reasoning.
Question
You update a role named Managers for the Human Resources cube in your SQL Server 2008 Analysis Services (SSAS) database. The database contains a dimension named Employee. You plan to configure the security for the Managers role. You need to allow the Managers role to access aggregate data based on only three or less employees. What should you do?
Options
- AAdd members of the [Employee].[Employees] hierarchy that contain three or less children to the denied
- BAdd members of the [Employee].[Employees] hierarchy that contain more than three children to the
- CAdd the following expression to the Allow Reading property in Cell Data in the Managers role.
- DAdd the following expression to the Allow Reading property in Cell Data in the Managers role.
How the community answered
(21 responses)- A5% (1)
- B10% (2)
- C81% (17)
- D5% (1)
Community Discussion
No community discussion yet for this question.