nerdexam
Microsoft

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.

Design BI data models

Question

You need to implement the security requirement for the sales representatives. Which MDX expression should you use?

Exhibit

70-467 question #69 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(49 responses)
  • A
    55% (27)
  • B
    24% (12)
  • C
    6% (3)
  • D
    14% (7)

Why each option

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

AOption ACorrect

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.

BOption B

This expression does not correctly implement the required filter logic for restricting access by sales representative context.

COption C

This expression produces an incorrect result set or applies the filter to the wrong dimension or hierarchy.

DOption 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

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

Topics

#MDX security#dimension security#SSAS database roles#cube access control

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice