Microsoft
70-448 · Question #304
70-448 Question #304: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #304. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following table. The Visual Totals property is set to True for both roles. You need to ensure that the sales manager can view only the members in the Product dimension that relate to the Bikes category in the Northeast region. What should you do?
Options
- AAdd the manager to the Bikes role.
- BAdd the manager to the Northeast Region role.
- CAdd the manager to a new role that has the following two components:
- DAdd the manager to a new role that has the following four components:
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 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.