nerdexam
Microsoft

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.

Configure and maintain an analysis services database

Question

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 should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)

Options

  • ARead and Process
  • BExplore and Manage
  • CBrowse And Manage
  • DAdministrator

How the community answered

(18 responses)
  • A
    89% (16)
  • B
    6% (1)
  • D
    6% (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.

ARead and ProcessCorrect

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.

BExplore and Manage

'Explore and Manage' is not a valid SSAS tabular role permission; the valid permission levels are None, Read, Read and Process, and Administrator.

CBrowse And Manage

'Browse And Manage' is not a valid SSAS tabular role permission set; it does not correspond to any of the four supported permission levels.

DAdministrator

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

#SSAS tabular roles#Read and Process permission#role-based access#data refresh

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice