PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer make sure that the value for the second quarter of 2008 keeps common?

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