Which four of the following actions should you perform next?

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 FinanceCube1.
Users in the Finance department are members of an Active Directory global group named
FinanceUsers.
You need to grant the users in the Finance department read access to FinanceCube1. You
open SQL Server Management Studio (SSMS).
Which four of the following actions should you perform next? (Choose four)

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 FinanceCube1.
Users in the Finance department are members of an Active Directory global group named
FinanceUsers.
You need to grant the users in the Finance department read access to FinanceCube1. 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\ FinanceUsers group to the role.

F.
Add the ABC\ FinanceUsers group to the SQL Server Login.

G.
Assign Read/Write access to FinanceCube1 for the role.

H.
Assign Read and Process access to FinanceCube1 for the SQL Server Login.

I.
Assign Read access to FinanceCube1 for the SQL Server Login.

Explanation:



Leave a Reply 3

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


Andrés

Andrés

BCEI, though option (I) should be “Assign Read access to FinanceCube1 for THE ROLE”.

Mahmoud Ibrahim

Mahmoud Ibrahim

agree