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…

The correct answer is C. Read. In SSAS Tabular, role-based security has five permission levels: None, Read, Read and Process, Process, and Administrator. The 'Read' permission is the minimum level that allows users to connect to and query data in the tabular model. 'Process' allows users to process (refresh)…

Design BI data models

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

ABrowser
BProcess
CRead
DAdministrator
EExplorer
FSelect

How the community answered

(56 responses)

B
7% (4)
C
88% (49)
D
2% (1)
E
4% (2)

Explanation

In SSAS Tabular, role-based security has five permission levels: None, Read, Read and Process, Process, and Administrator. The 'Read' permission is the minimum level that allows users to connect to and query data in the tabular model. 'Process' allows users to process (refresh) the model but not query it. 'Administrator' grants full control and is far more than minimum. 'Browser' and 'Explorer' are not valid SSAS Tabular permission types - 'Browser' applies to SSAS Multidimensional roles. 'Select' is a database-level SQL permission, not an SSAS role permission. To grant the least privilege necessary for querying, always assign 'Read'.

Topics

#SSAS tabular#role permissions#Read permission#security

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice