You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
A Windows Server 2012 server named ABC-SSAS01 runs SQL Server 2012 Analysis
Services (SSAS). You have an SSAS cube named SalesCube1.
Users in the Sales department are members of an Active Directory global group named
SalesUsers.
You need to grant the users in the Sales department write access to SalesCube1. You open
SQL Server Management Studio (SSMS).
Which four of the following actions should you perform next? (Choose four)
A.
Connect to the Database Engine instance.
B.
Connect to the Analysis Services instance.
C.
Create a new role for the database.
D.
Create a new SQL Server Login to the server.
E.
Add the ABC\SalesUsers group to the role.
F.
Add the ABC\SalesUsers group to the SQL Server Login.
G.
Assign Read/Write access to SalesCube1 for the role.
H.
Assign Read and Process access to SalesCube1 for the SQL Server Login.
Explanation:
B, C, E, H
There’s no Read/Write Permission for the Role
Answer are B, C , E and G.
There is read/write permission for the role.