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 ‘”.