70-466 · Question #123
You are administering 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 sho
The correct answer is A. Read and Process. SSAS tabular role permissions are discrete levels - Read allows querying and Process allows data refresh, so combining both grants exactly the required capabilities without excess privilege.
Question
Options
- ARead and Process
- BExplore and Manage
- CBrowse And Manage
- DAdministrator
How the community answered
(18 responses)- A89% (16)
- B6% (1)
- D6% (1)
Why each option
SSAS tabular role permissions are discrete levels - Read allows querying and Process allows data refresh, so combining both grants exactly the required capabilities without excess privilege.
The 'Read' permission in an SSAS tabular role grants members the ability to query and browse model data, while the 'Process' permission grants the ability to trigger data refresh (processing) operations. Assigning a role with both Read and Process covers both stated requirements - querying data and refreshing the model - without granting unnecessary administrative access.
'Explore and Manage' is not a valid SSAS tabular role permission; the valid permission levels are None, Read, Read and Process, and Administrator.
'Browse And Manage' is not a valid SSAS tabular role permission set; it does not correspond to any of the four supported permission levels.
Administrator permission grants unrestricted control over the database including security, schema, and configuration, which far exceeds the minimum privilege needed simply to query and refresh data.
Concept tested: SSAS tabular model role permission levels
Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/roles-ssas-tabular
Topics
Community Discussion
No community discussion yet for this question.