Microsoft Exam Questions

Which role permission should you assign to the role?

You work as a Database Administrator (DBA) at ABC.com. The company uses a Microsoft SQL
Server 2012 infrastructure.
A server named ABC-SSAS1 runs SQL Server Analysis Services (SSAS). You are configuring
security for a tabular model on ABC-SSAS1.
You need to assign role permissions to a role to ensure that users can query the data in the
tabular model but cannot see the model database in SSMS (SQL Server Management Studio).
Which role permission should you assign to the role?

A.
None.

B.
Read.

C.
Read and Process.

D.
Process.

E.
Administrator.

Explanation: