70-467 Question #69: Real Exam Question with Answer & Explanation

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?

MDX dimension security expressions control what cube data sales representatives can access based on their context.

Common mistakes.

B. This expression does not correctly implement the required filter logic for restricting access by sales representative context.
C. This expression produces an incorrect result set or applies the filter to the wrong dimension or hierarchy.
D. 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

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/roles-and-permissions-analysis-services

No community discussion yet for this question.