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?

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?

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 0

Your email address will not be published. Required fields are marked *