Which option should you select?

HOTSPOT
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A
role named USA allows users to browse data pertaining to the United States. A role named
Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data
pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.

HOTSPOT
A SQL Server Analysis Services (SSAS) cube has roles to define dimension data security. A
role named USA allows users to browse data pertaining to the United States. A role named
Canada allows users to browse data pertaining to Canada.
A user can browse sales data pertaining to the United States but cannot browse sales data
pertaining to Canada. You validate that the user belongs to the USA and Canada roles.
You need to reproduce the issue in SQL Server Management Studio (SSMS).
Which option should you select? To answer, select the appropriate action in the answer area.

Answer:

Show Hint

Leave a Reply 5

Your email address will not be published. Required fields are marked *

Ralph

Ralph

That button allows you to simulate work as a chosen user. You will not need to enter any password, or make any impersonation. Everything is done by tools and SSAS.

Reply

Myra

Myra

Is it only me who cannot open all the images Carlos uploaded?

Reply

Henk Schenkworst

Henk Schenkworst

same here. it’s useless i am afraid.
So far the comments by Ralph are most helpful (although i disagree with a few answers, but mostly he’s spot on)

Reply