You are administrating a SQL Server Analysis Services (SSAS) tabular database. You need to create a new role that allows its members to query data and to refresh data in the model. Which permission…

The correct answer is C. Read and Process. Giving a database role permission to process an Analysis Services database means that the role has permission to perform all processing options on the database. This includes the processing of all cubes, dimensions, mining structures, and mining models in the database. However…

Configure and maintain SQL Server Analysis Services (SSAS)

Question

You are administrating a SQL Server Analysis Services (SSAS) tabular database. You need to create a new role that allows its members to query data and to refresh data in the model. Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

ABrowse and Manage
BAdministrator
CRead and Process
DExplore and Manage

How the community answered

(30 responses)

A
17% (5)
B
3% (1)
C
70% (21)
D
10% (3)

Explanation

Giving a database role permission to process an Analysis Services database means that the role has permission to perform all processing options on the database. This includes the processing of all cubes, dimensions, mining structures, and mining models in the database. However, the role does not have permission to read database metadata or access any data in the database itself.

Topics

#roles#permissions#Read and Process#tabular model security

Community Discussion

No community discussion yet for this question.

Full 70-768 Practice