You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to create a SQL Server 2008 Analysis Services (SSAS) solution and then you design a Business Intelligence (BI) solution. There’s a dimension named DEClients in the solution. And the dimension is used to stand for clients who buy products
in your company. The solution gives a list of top 8 Clients according to the sales amount. End users of the solution use filters in Microsoft Excel worksheet to analyze data. Now you’re assigned a task to make sure that when the filters are applied, the list must be updated. So which named set expression should you use to achieve this?
A.
CREATE SESSION SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
B.
CREATE HIDDEN SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
C.
CREATE DYNAMIC SET CURRENTCUBE.[Top 10 Clients] AS TOPCOUNT([DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])
D.
CREATE SET CURRENTCUBE.[Top 10 Clients] ASTOPCOUNT([DClients].[Clients].MEMBERS,10,[Measures].[SalesAmount])