Microsoft
70-448 · Question #65
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…
The correct answer is B. You should have the code segment below added at line D. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server 2008. To meet the business development, you create a SQL Server 2008 Analysis Server (SSAS) solution, which has a measure named ProductQuantity and a price dimension named DimPrice along with a hierarchy named Price. Then the code segment is added to the calculation script of the cube as the following: (Line letters are used only for reference.) Now you get an order from your manager to accomplish the following tasks: 1. Increase the value of the ProductionQuantity measure by 60% for each month in the fourth quarter of 2006. 2. Keep the value for the fourth quarter of 2006 unchanged. What action should you perform to accomplish the tasks above?
Options
- AYou should have the code segment below added at line A:
- BYou should have the code segment below added at line D:
- CYou should have the code segment below added at line A:
- DYou should have the code segment below added at line D:
How the community answered
(24 responses)- A8% (2)
- B83% (20)
- C4% (1)
- D4% (1)
Community Discussion
No community discussion yet for this question.