Microsoft
70-448 · Question #255
You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named Customer. You need to configure the Dimension Data settings to meet the following requirements…
The correct answer is B. Add the following set to the Denied Set property. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 Analysis Services (SSAS) database that contains a dimension named Customer. You need to configure the Dimension Data settings to meet the following requirements:
- Deny access to the
{[Customer].[Country].&[Germany],[Customer].[Country].&[France]} set of attribute members.
- New members added to the attribute are visible by default.
What should you do?
Options
- AAdd all the country members except those of France and Germany to the Allowed Set property.
- BAdd the following set to the Denied Set property.
- CAdd the following set to the Denied Set property.
- DAdd the following set to the Allowed Set property.
How the community answered
(45 responses)- A11% (5)
- B80% (36)
- C2% (1)
- D7% (3)
Community Discussion
No community discussion yet for this question.