What should you do?

Posted by: Pdfprep Category: 70-467 Tags: , ,

You need to implement security in the cube to limit the sites visible to each user.

What should you do?
A . Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.
B . Create an SSAS server role for each user and assign the sites each user can access to his or her server role.
C . Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
D . Create a view on the Sales Transactions table that uses the Security Filter and User table data to limit the sites for each user.

Answer: C

Leave a Reply

Your email address will not be published.