Microsoft
70-448 · Question #192
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…
The correct answer is D. Country = "USA" AND Year = 2008. See the full explanation below for the reasoning.
Question
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?
Options
- ACountry = "USA"
- BCountry = "USA" AND Year = 2008
- CCountry = "USA" AND Year = 2008
- DCountry = "USA" AND Year = 2008
How the community answered
(15 responses)- A7% (1)
- C13% (2)
- D80% (12)
Community Discussion
No community discussion yet for this question.