Microsoft
70-448 · Question #317
70-448 Question #317: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #317. The question stem and answer options stay visible for context.
Question
You are a database developer and you have about two years experience in reating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You use SQL Server 2008 Reporting Services (SSRS) to create a solution. Your solution includes a time dimension named DimDay. And the DimDay dimension contains a hierarchy named Yr-Qtr-Mth. There is a measure group named Measures01 which contains a measure named Number. Now a calculated member has to be created, then it will be used to display the Number measure in the previous time period for the current level of the Yr-Qtr-Mth hierarchy. In the following options, which expression should be used?
Options
- A([Measures01].[Number],OPENINGPERIOD( [DimDay].[Yr-Qtr-Mth].FirstSibling.Level))
- B([Measures01].[Number],LASTPERIODS( 0,[DimDay].[Yr-Qtr-Mth].PrevMember))
- C([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].PrevMember)
- D([Measures01].[Number],[DimDay].[Yr-Qtr-Mth].FirstSibling)
Unlock 70-448 to see the answer
You've previewed enough free 70-448 questions. Unlock 70-448 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.