PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are managing a Microsoft SQL Server 2005 Analysis Services (SSAS) instance. You have a machine named COMPANYCUBE for a SSAS instance. The COMPANYCUBE machine hosts a SSAS database that has a cube named HR. You need to restrict the local administrators from accessing any data stored in the HR cube. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Remove all the local administrators from the membership in the server role.

B.
Change the Security\BuiltInAdminsareServerAdmins property of the SSAS instance to false.

C.
Create a role called AdminRole. Set the Access to the HR cube to None. Add the local administrators to the role.

D.
Remove the local administrators from the SQLServer2005MSOLAPUser$COMPANYCUBE$MSSQLSERVER local group.


Leave a Reply