Microsoft
70-466 · Question #124
70-466 Question #124: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #124. The question stem and answer options stay visible for context.
Build a tabular data model
Question
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.)
Options
- ACreate a separate tabular project for each sales territory. Grant each salesperson access to the corresponding tabular model of the assigned sales territory.
- BCreate 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.
- CAdd the group as a member to the role. Create a new role with Read permission and then add each salesperson's logon as a member to the role.
- DAdd 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.
Unlock 70-466 to see the answer
You've previewed enough free 70-466 questions. Unlock 70-466 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.
Topics
#dynamic row-level security#DAX USERNAME#row filters#tabular model roles