70-466 · Question #37
You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant the minimum permissions necessary to enable users to query data in a data model. Which role permission shoul
The correct answer is F. Read. The Read role permission is the minimum permission level in SSAS tabular that allows users to query the data model without granting any administrative or processing capabilities.
Question
Options
- AExplorer
- BProcess
- CAdministrator
- DSelect
- EBrowser
- FRead
How the community answered
(41 responses)- A2% (1)
- D2% (1)
- E5% (2)
- F90% (37)
Why each option
The Read role permission is the minimum permission level in SSAS tabular that allows users to query the data model without granting any administrative or processing capabilities.
Explorer is not a valid permission level in SSAS tabular role definitions; it belongs to a different product context.
Process permission allows users to trigger model refresh/processing operations but does not grant the ability to query data.
Administrator grants full control over the model including structural modifications and server management, far exceeding the minimum required for data queries.
Select is not a recognized permission level in SSAS tabular role configuration.
Browser is a permission level found in SSAS multidimensional (cube) models, not in tabular model role definitions.
In SSAS tabular models, role permissions are None, Read, Read and Process, Process, and Administrator. Read is the lowest permission that grants users the ability to issue MDX or DAX queries against the model. It does not allow processing or structural changes, satisfying the principle of least privilege for query-only access.
Concept tested: Minimum SSAS tabular role permission for data querying
Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/roles-ssas-tabular
Topics
Community Discussion
No community discussion yet for this question.