PrepAway - Latest Free Exam Questions & Answers

Which options below should be chosen to accomplish this task?

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and you are in charge of a SQL Server 2008 Analysis Services (SSRS) database for the company.
The database contains a Human Resources cube and a dimension named Salesman.

According to the business requirements, a role named Administrator should be updated for the cube.
After the update, you attempt to have the security deployed for the Administrators role.

Now you are assigned a task to prevent the Administrators role from accessing the aggregate data that based on more than three salesmen.
Which options below should be chosen to accomplish this task?

PrepAway - Latest Free Exam Questions & Answers

A.
The expression of IIF(Descendants([Salesman].[Salesmen].CurrentMember,,LEAVES).Count <= 3, [Salesman].[Salesmen].CurrentMember, null) should be added to the Allow Reading property in Cell Data in the Administrators role.

B.
Members of the [Salesman].[Salesmen] hierarchy that contain three or less children should be added to the denied set for the Administrators role.

C.
Members of the [Salesman].[Salesman] hierarchy that contain more than three children should be added to the allowed set for the Administrators role.

D.
The expression of Descendants([Salesman].[Salesmen].CurrentMember,,LEAVES).Count <= 3 should be added to the Allow Reading property in Cell Data in the Administrators role.


Leave a Reply