PrepAway - Latest Free Exam Questions & Answers

You need to increase the value of the SalesAmount measure by 50% for each month in the first quarter of 2007

You create a SQL Server 2008 Analysis Services (SSAS) solution. Your solution has the
following components:
A hierarchy named Date in a time dimension named DimTime
A measure named SalesAmount
You add the following code segment to the calculation script of the cube. (Line numbers are
included for reference only.)
01 . . .
02 Freeze([Measures].[SalesAmount],
03 [DimTime].[Date].[Quarter].[Q1 2007]);
04 . . .
You need to increase the value of the SalesAmount measure by 50% for each month in the
first quarter of 2007.
You also need to ensure that the value for the first quarter of 2007 remains unchanged.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Add the following code segment at line 04.
Scope([Measures].[Amount],[DimTime].[Date].[Quarter]. [Q1
2007]);This=[DimTime].[Date].currentmember * 1.5;End Scope;

B.
Add the following code segment at line 01.
Scope([Measures].[Amount],[DimTime].[Date].[Quarter]. [Q1
2007]);This=[DimTime].[Date].currentmember * 1.5;End Scope;

C.
Add the following code segment at line 04.
Scope([Measures].[SalesAmount],Descendants([DimTime].[Date].[Quarter]. [Q1
2007][DimTime].[Date].[Month]));This=[DimTime].[Date].currentmember * 1.5;End Scope;

D.
Add the following code segment at line 01.
Scope([Measures].[SalesAmount],Descendants([DimTime].[Date].[Quarter].[Q1

2007][DimTime].[Date].[Month]));This=[DimTime].[Date].currentmember * 1.5;End Scope;


Leave a Reply