You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The project has a fact table named FactOrders that contains columns named Order Amount, Country, and Order Date Key. You create the first partition for the fact table with the Source property set to “Select * from FactOrders where [Order Date Key]>354 or Country=’USA'”. You need to create the second partition for the fact table to ensure accurate results when queried. What should you do?
A.
Create a partition with the Source property set to “Select * from FactOrders where [Order Date Key]<=354 and Country<>’USA'”.
B.
Create a partition with the Source property set to “Select * from FactOrders where [Order Date Key]<=354”.
C.
Create a partition with the Source property set to “Select * from FactOrders where Country<>’USA'”.
D.
Create a partition with the Source property set to “Select * from FactOrders”.