PrepAway - Latest Free Exam Questions & Answers

You need to configure the Dimension Data settings to meet the following requirements…

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?

PrepAway - Latest Free Exam Questions & Answers

A.
Add all the country members except those of France and Germany to the Allowed Set
property.

B.
Add the following set to the Denied Set property.
{[Customer].[Country].&[Germany],[Customer].[Country].&[France]}

C.
Add the following set to the Denied Set property.
Except([Customer].[Country].[Country],{[Customer].[Country].&[Germany],[Customer].[Count
ry].&[
France]})

D.
Add the following set to the Allowed Set property.

Extract({[Customer].[Country].&[Germany],[Customer].[Country].&[France]},[Customer].[Cou
ntry])


Leave a Reply