You are managing a SQL Server 2008 Analysis Services (SSAS) database for Company.com.
A sales manager called Clerk is responsible for the sales of bikes in the Northeast region.
You decide to give some rights to the rights to Clerk to visit the database.You won two roles below called Northeast Region and Bikes.
Their schemas are listed below:
You have make The Visual Totals properties attribute true for roles above.
You should make sure that Clerk could browser the workers in the Product dimension which link to the Bikes category in the Northeast region.
Which is the correct answer? (Exhibit)
A.
You should increase Clerk to a Bikes role
B.
You should increase Clerk to the Northeast Region role.
C.
You should increase Clerk to a new role which owns components below:
[ Products Territory Region].[Northeast]} as the permitted configuration.{[Product].[Product Category].[Product Category].[Bikes]} as the permitted
D.
You should increase Clerk to the default Region role.
Explanation:
There was a mess in original q – Nikes, Bikes, Southwest, Northwest…
I think I have fixed it 🙂
another version of the q is:You work as a database administrator at Domain.com. Your duties include managing a SQL Server 2008 Analysis Services (SSAS) database named CKSales.
A Domain.com employee named Rory Allen is responsible for the sales in the Southern region.
You need to ensure that Rory Allen is able to use the CKSales database. You thus have to grant him some access to the database.The diagram below depicts the schema of the two roles for the CKSales database:
You decide to make the Visual Totals properties feature for roles above true. You have to make
sure that Rory Allen is able to browse the employees in the Product dimension which link to the
Tests category in the Southern region. What should you do?A. You should consider adding Rory Allen to the Tests role.
B. You should consider adding Rory Allen to the Southern Region role.
C. You should consider adding Rory Allen to a new role which owns components:
[ProductsTerritory Region].[Southern]} as the permitted configuration
and {[Product].[ProductCategory].[Product Category].[Tests]} as the permitted configuration.
D. You should consider adding Rory Allen to the default Region role.