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

The correct answer is B: In SQL Server Data Tools, configure the BusinessUsers role to disallow the reading of the. SSAS dimension security restricting read access for a role can be configured either in SQL Server Data Tools at design time or in SQL Server Management Studio against a deployed database.

Question

You need to configure permissions for the Customers dimension. What should you do? (Each correct answer presents a complete solution. Choose all that apply.)

Options

AIn SQL Server Management Studio, configure the BusinessUsers role to disallow the reading
BIn SQL Server Data Tools, configure the BusinessUsers role to disallow the reading of the
CIn SQL Server Management Studio, deny the member set for the Customers dimension data
DIn SQL Server Management Studio, configure the BusinessUsers role to disallow the reading

Explanation

SSAS dimension security restricting read access for a role can be configured either in SQL Server Data Tools at design time or in SQL Server Management Studio against a deployed database.

Common mistakes.

A. This option in SSMS does not correctly configure the BusinessUsers role to restrict dimension data access because it applies the wrong security setting or targets the wrong object for the required disallow-read configuration.
C. Denying the member set directly in SSMS is not the correct mechanism for restricting dimension data access; the proper approach is to configure the role's dimension data permissions using the AllowedSet or DeniedSet within the role definition, not a direct member set deny.

Concept tested. SSAS role-based dimension data security configuration

Reference. https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/grant-custom-access-to-dimension-data-analysis-services

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice