You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson

You are developing a SQL Server Analysis Services (SSAS) tabular project.

In the data warehouse, a table named Employee Security defines a relationship between a
salesperson’s name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory
assigned to that salesperson. You also need to minimize the development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

You are developing a SQL Server Analysis Services (SSAS) tabular project.

In the data warehouse, a table named Employee Security defines a relationship between a
salesperson’s name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory
assigned to that salesperson. You also need to minimize the development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

A.
Create a new role with Read permission and then add each salesperson’s logon as a
member to the role.

B.
Create a separate tabular project for each sales territory. Grant each salesperson access
to the corresponding tabular model of the assigned sales territory.

C.
Add the Employee Security table to the model, define the relationships, and then
implement dynamic security by using row filters. Grant each salesperson access to the
model.

D.
Create a new Active Directory Domain Services (AD DS) security group and add each
salesperson as a member. Then create a new role with Read permission. Add the group as
a member to the new role.



Leave a Reply 1

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


Ralph

Ralph

C is the easiest and working solutions.