You are developing a SQL Server Analysis Services (SSAS) tabular project. In the data warehouse, a table named Sales Persons and Territories 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 need to use the least amount of development effort to achieve this goal. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Question

Accepted Answer

B. Add the Sales Persons and Territories table to the model, define the relationships, and then

Answer

A. Create a new role named Sales Persons with Read permission.

Answer

C. Create a new Active Directory Domain Services (AD DS) security group and add each salesperson

Answer

D. Create a separate tabular model for each sales territory and assign each tabular model a

You are developing a SQL Server Analysis Services (SSAS) tabular project. In the data warehouse, a table named Sales Persons and Territories defines a relationship between a salesperson's name…

Question

Options

How the community answered

Community Discussion