Home » Microsoft » 70-466 » Which permission should you use?
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.)
A. Browse and Manage
B. Administrator
C. Read and Process
D. Explore and Manage
Correct Answer: C
Explanation/Reference:
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.