You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a SQL Server Analysis Services (SSAS) cube named MaintenanceCube1.
You are using Multidimensional Expressions (MDX) to define a named set in
MaintenanceCube1.
The Engineer dimension in MaintenanceCube1 contains a hierarchy named Location and
an attribute hierarchy named Availability.
You need to configure the MDX to return all the engineers in the Location hierarchy with
the availability value of Available.
Which of the following should you use for the named set?

A.
Filter
(
[Engineer] . [Engineer Location] . [Engineer Name] . Members, ([Engineer] . [Availability] .
&[Available], [Measures] . [Quantity]) > 0
)

B.
CrossJoin
(
[Engineer] . [Engineer Location] . [Engineer Name] . Members, [Engineer] . [Availability] .
&[Available]
)

C.
Exists
(
[Engineer] . [Engineer Location] . [Engineer Name] . Members, [Engineer] . [Availability] .
&[Available]
)

D.
Generate
(
[Engineer] . [Availability] . &[Available], [Engineer] . [Engineer Name] . [Engineer Location] .
Members, ALL
)

Explanation: