You create a SQL Server 2008 Analysis Services (SSAS) solution.
You have a table named FactSales that contains columns named Country and Year.
You discover that data is frequently queried for the following values:
The Country column as USA
The Year column as 2008
You decide to implement two partitions for the measure group based on the FactSales table.
The first partition contains the frequently queried data and the second partition contains the
remaining fact table data.
Which partition query WHERE clauses should you use?
A.
Country = “USA”
Year = 2008
B.
Country = “USA” AND Year = 2008
Country <> “USA” AND Year <> 2008
Country = “USA” OR Year = 2008
C.
Country = “USA” AND Year = 2008
Country <> “USA” AND Year <> 2008
D.
Country = “USA” AND Year = 2008
(Country = “USA” AND Year <> 2008)
OR (Country <> “USA”)