70-448 · Question #313
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is D. Tim should be added to a new role that has the following two components. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. Your company makes and sells Cars. You work as the technical support. Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database.Tim is the distributor of the Southern Area. Now according to the business requirement, Tim has to access the database. After discussion, your company decides to give Tim the necessary permissions. There are two roles respectively named Southern Area and Cars. The table below shows the schemas of the two roles. For both roles, you have set the Visual Totals property to True. Now you get another order from the company, according to the company requirement, Tim can only be able to view the members in the Product dimension that relate to the Cars category in the Southern Area. You have to accomplish this task. So what action should you perform?
Options
- ATim should be added to a new role that has the following two components:
- BTim should be added to the Cars role
- CTim should be added to the Southern Area role
- DTim should be added to a new role that has the following two components:
How the community answered
(58 responses)- A9% (5)
- B5% (3)
- C3% (2)
- D83% (48)
Community Discussion
No community discussion yet for this question.