DRAG DROP
You are administering a SQL Server Analysts Services (SSAS) database on a server. The
database hosts a financial cube based on a SQL Azure database.
You need to grant write access to the financial cube for all users in the group
USA\PowerUsers.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)

Answer: See the explanation

Explanation:
Box 1: In the SQL Management Studio (SSMS), connect to the SSAS instance on the
server.
Box 2: Create a new role for the database.
Box 3: Add the USA\PowerUsers group to the role. Set the cube access for the role to Read
and Process.

Note:
* A member of the server role for Microsoft SQL Server Analysis Services, or a member of a
database role that has Full Control (Administrator) permissions in a particular database, can
create a database role that only has permission to process specified objects within the
database. Giving a database role permission to process a database object lets an
administrator delegate the task of processing certain objects, without also granting
extraneous permissions to the user who is performing the processing.
* To give a database role permission to process a cube
1. In SQL Server Management Studio, connect to the instance of Analysis Services,
expandRolesfor the appropriate database in Object Explorer, and then double-click a
database role (or right-click Rolesand selectNew Roleto create a new database role). If this
is a new role, make sure that you enter a name for the role in theRole namebox.
2. ClickCubesin theSelect a Pagepane, locate the cube in theCubelist, and then select
theProcesscheck box for the cube.
3. Click theOKbutton.
* There is no write permissions on a cube.
Grant Process Permissions on an Analysis Services Multidimensional Database