You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.
The fact table named FactOrderstest should be included in the project; the table contains columns named
*Order Amount,
*Country,
*Order Date Key
“Select * from FactOrderstest where [Order Date Key]>400 or Country=’CHINA'” is created by the first partition for the fact table with the Source property the second partition for the fact table to make sure that accurate results is outputted when queried should be created.
Which is the correct answer?
A.
You should develop a partition with the Source property set to “Select * from FactOrderstest where [Order Date Key]<= 400and Country<>’ CHINA ‘”.
B.
You should develop a partition with the Source property set to “Select * from FactOrderstest where [Order Date Key]<= 400”.
C.
You should develop a partition with the Source property set to “Select * from FactOrderstest where Country<>’USA'”.
D.
You should develop a partition with the Source property set to “Select * from FactOrderstest where [Order Date Key]>=400and Country!’ CHINA ‘”.