You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
Now you are in charge of a SQL Server 2008 Analysis Services (SSAS) database.
The database has a dimension which is named Client.
Now your company manager assigns a task to you.
You are asked to perform the configuration on the Dimension Data settings, after the configuration, the two requirements below must be met:
* First, new members added to the attribute must be visible by default;
* Second, deny access to the {[Customer].[Country].[Germany],[Customer].[Country].[France]} set of attribute members.
So what action should you perform?
A.
The following set should be added to the Denied Set property. {[Customer].[Country].[Germany],[Customer].[Country].[France]}
B.
All the country members except those of France and Germany has to be added to the Allowed Set property.
C.
The following set should be added to the Allowed Set property. Extract({[Customer].[Country].[Germany],[Customer].[Country].[France]},[Customer].[Country])
D.
The following set should be added to the Denied Set property Except([Customer].[Country].[Country],{[Customer].[Country].[Germany],[Customer].[Country].[ France]})