PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

You are developing a SQL Server 2008 Reporting Services (SSRS) method for
Company.com.
There are some components listed below:
A hierarchy called Test in a time dimension called DimTestTime
A method called SalesNumber You decide to increase codes to the cube’s calculation
11. . . .
12 Freeze([Measures].[ SalesNumber],
13 [DimTestTime].[ Test].[Quarter].[Q0 2008]);
14. . . .
For every month in the second quarter of 2008, not only should you add the value of the
SalesNumber measure through 80%. But also you should make sure that the value for the
second quarter of 2008 keeps common.
Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should increase codes below at line 14.
Scope([Measures].[DimTime].[Date].[Quarter].[Q0
2008]);This= [DimTime].[Date].currentmember * 3;End Scope;

B.
You should increase codes below at line 11. Scope([Measures].[ SalesNumber],[
DimTestTime].[ Test]. [Quarter]. [Q0 2008]);End Scope;

C.
You should increase codes below at line 14 [
SalesNumber],Descendants([DimTestTime].[
Test].[Quarter]. [Q0 2008][ DimTestTime].[ Test].[Month]));This=[ DimTestTime].[
Test].currentmember * 5;End Scope;

D.
You should increase codes below at line 11. Scope([Measures]
SalesNumber],Descendants([DimTestTime]. [ Test].[Second].[ Q0 2008][ DimTestTime].[
Test].[
Second]));This=[ [ Test] [Second].currentmember * 1.5; End Scope;


Leave a Reply