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?

Question

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?

Accepted Answer

A. You should develop a partition with the Source property set to "Select * from FactOrderstest where

Answer

B. You should develop a partition with the Source property set to "Select * from FactOrderstest where

Answer

C. You should develop a partition with the Source property set to "Select * from FactOrderstest where

Answer

D. You should develop a partition with the Source property set to "Select * from FactOrderstest where

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…

Question

Options

How the community answered

Community Discussion