nerdexam
Microsoft

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.

Build a tabular data model

Question

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 should you use?

Options

  • AExplorer
  • BProcess
  • CAdministrator
  • DSelect
  • EBrowser
  • FRead

How the community answered

(41 responses)
  • A
    2% (1)
  • D
    2% (1)
  • E
    5% (2)
  • F
    90% (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.

AExplorer

Explorer is not a valid permission level in SSAS tabular role definitions; it belongs to a different product context.

BProcess

Process permission allows users to trigger model refresh/processing operations but does not grant the ability to query data.

CAdministrator

Administrator grants full control over the model including structural modifications and server management, far exceeding the minimum required for data queries.

DSelect

Select is not a recognized permission level in SSAS tabular role configuration.

EBrowser

Browser is a permission level found in SSAS multidimensional (cube) models, not in tabular model role definitions.

FReadCorrect

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

#role permissions#Read permission#tabular security#minimum access

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice