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.
Question
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)- A6% (3)
- B2% (1)
- C12% (6)
- D80% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.