70-467 · Question #69
You need to implement the security requirement for the sales representatives. Which MDX expression should you use?
The correct answer is A. Option A. MDX dimension security expressions control what cube data sales representatives can access based on their context.
Question
You need to implement the security requirement for the sales representatives. Which MDX expression should you use?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(49 responses)- A55% (27)
- B24% (12)
- C6% (3)
- D14% (7)
Why each option
MDX dimension security expressions control what cube data sales representatives can access based on their context.
The correct MDX expression applies a dimension security filter that evaluates the current user's context and restricts member visibility to only the data the sales representative is authorized to see. SSAS role-based security uses MDX expressions in the Allowed Member Set property to dynamically enforce row-level access on dimension members.
This expression does not correctly implement the required filter logic for restricting access by sales representative context.
This expression produces an incorrect result set or applies the filter to the wrong dimension or hierarchy.
This expression either returns all members without restriction or targets the wrong attribute, failing to enforce the security requirement.
Concept tested: SSAS MDX dimension security for role-based access
Source: https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/roles-and-permissions-analysis-services
Topics
Community Discussion
No community discussion yet for this question.
