PrepAway - Latest Free Exam Questions & Answers

What action should you perform to accomplish the tasks above?

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server2008.

Now you are employed in a company which is named NaproStar and work as the technical support for the company which uses SQL Server2008.
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?

PrepAway - Latest Free Exam Questions & Answers

A.
You should have the code segment below added at line A:
Scope([Measures].[Quantity],[DimPrice].[Price].[Quarter]. [Q4 2006]);This=[DimPrice].[Price].currentmember * 1.6;End Scope

B.
You should have the code segment below added at line D:
Scope([Measures].[ProductQuantity],Descendants([DimPrice].[Price].[Quarter]. [Q4 2006][DimPrice].[Price].[Month]));This=[DimPrice].[Price].currentmember * 1.6;End Scope;

C.
You should have the code segment below added at line A:
Scope([Measures].[ProductQuantity],Descendants([DimPrice].[Price].[Quarter].[Q4 2006][DimPrice].[Price].[Month]));This=[DimPrice].[Price].currentmember * 1.6;End Scope;

D.
You should have the code segment below added at line D:
Scope([Measures].[Quantity],[DimPrice].[Price].[Quarter]. [Q4 2006]);This=[DimPrice].[Price].currentmember * 1.6;End Scope;


Leave a Reply