Microsoft
70-768 · Question #64
70-768 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 70-768 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
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.)
Options
- ACreate a new role named Sales Persons with Read permission.
- BAdd the Sales Persons and Territories table to the model, define the relationships, and then
- CCreate a new Active Directory Domain Services (AD DS) security group and add each salesperson
- DCreate a separate tabular model for each sales territory and assign each tabular model a
Unlock 70-768 to see the answer
You've previewed enough free 70-768 questions. Unlock 70-768 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.