Posted by: Pdfprep
Post Date: November 21, 2020
You need to configure permissions for the Customers dimension.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A . In SQL Server Management Studio, configure the Business Users role to disallow the reading of all definitions.
B . In SQL Server Data Tools, configure the Business Users role to disallow the reading of the Customers dimension definition.
C . In SQL Server Management Studio, deny the member set for the Customers dimension data by using the Multidimensional Expressions (MDX) expression Filter ([Business Users]).
D . In SQL Server Management Studio, configure the Business Users role to disallow the reading of the Customers dimension definition.
Answer: B, D
Leave a Reply