Which two of the following steps should you perform?

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Data Tools (SSDT) to author a SQL Server 2012 Analysis Services
(SSAS) tabular model project.

You need to restrict which rows are visible to users based on their office department.
Which two of the following steps should you perform? (Choose two)

You work as a developer at ABC.com. The company uses a Microsoft SQL Server 2012
infrastructure.
You are using SQL Server Data Tools (SSDT) to author a SQL Server 2012 Analysis Services
(SSAS) tabular model project.

You need to restrict which rows are visible to users based on their office department.
Which two of the following steps should you perform? (Choose two)

A.
Configure a DAX (Data Analysis Expressions) formula to create row filters.

B.
Configure a MDX (Multidimensional Expressions) formula to create row filters.

C.
Apply the filter to a role.

D.
Apply the filter to a member.

Explanation:



Leave a Reply 1

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