nerdexam
Microsoft

70-466 · Question #69

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant permission for salespersons to be able to view only the data based on their sales territory. What should…

The correct answer is D. Create a role and then create a Data Analysis Expressions (DAX) filter. SSAS Tabular models use roles for security and DAX for row-level filters; MDX applies to multidimensional models and 'member' is not a valid security object in tabular.

Build a tabular data model

Question

You are developing a SQL Server Analysis Services (SSAS) tabular project. You need to grant permission for salespersons to be able to view only the data based on their sales territory. What should you do?

Options

  • ACreate a member and then create a Multidimensional Expressions (MDX) filter.
  • BCreate a member and then create a Data Analysis Expressions (DAX) filter.
  • CCreate a role and then create a Multidimensional Expressions (MDX) filter.
  • DCreate a role and then create a Data Analysis Expressions (DAX) filter.

How the community answered

(51 responses)
  • A
    6% (3)
  • B
    2% (1)
  • C
    12% (6)
  • D
    80% (41)

Why each option

SSAS Tabular models use roles for security and DAX for row-level filters; MDX applies to multidimensional models and 'member' is not a valid security object in tabular.

ACreate a member and then create a Multidimensional Expressions (MDX) filter.

MDX filters are used in multidimensional (OLAP cube) models, not tabular models, and 'member' is not a valid security object in SSAS Tabular - roles are required.

BCreate a member and then create a Data Analysis Expressions (DAX) filter.

While DAX is the correct filter language for tabular models, the security principal must be a role, not a 'member' - members are not a recognized security construct in SSAS Tabular.

CCreate a role and then create a Multidimensional Expressions (MDX) filter.

MDX is the filter language for SSAS multidimensional models; SSAS Tabular requires DAX filters, so an MDX filter cannot enforce row-level security in a tabular project.

DCreate a role and then create a Data Analysis Expressions (DAX) filter.Correct

In SSAS Tabular, roles are the mechanism for defining user permissions, and row-level security filters are written in DAX, which is the native expression language for tabular models. Applying a DAX filter on the sales territory column within a role restricts each salesperson's view to only their own territory's rows at query execution time.

Concept tested: SSAS Tabular row-level security with DAX filters

Source: https://learn.microsoft.com/en-us/analysis-services/tabular-models/roles-ssas-tabular

Topics

#SSAS tabular row-level security#DAX filter#role-based access#sales territory

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice