Microsoft
70-466 · Question #128
70-466 Question #128: Real Exam Question with Answer & Explanation
Sign in or unlock 70-466 to reveal the answer and full explanation for question #128. The question stem and answer options stay visible for context.
Configure and maintain an analysis services database
Question
You need to recommend a solution for the sales department that meets the security requirements. What should you recommend?
Options
- ACreate a one role for all of the sales department users. Add a DAA role that reads the current user name and retrieves the user's region. Create one role for each region.
- BConfigure each role to have read access to a specific region. Add the sales department users to their corresponding role. Create a table to for each region.
- CCreate a role for each region. Grant each role read access to its corresponding table. Add a DAA role that reads the current user name and retrieves the user's region.
- DCreate one role for all of the sales department users. Configure the role to have read access to the sales transactions. Ensure that all of the reports that access the sales transaction data restrict read access to the data from the corresponding sales department region only.
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
#SSAS role design#region-based security#dynamic access#row-level security