Microsoft
70-448 · Question #92
70-448 Question #92: Real Exam Question with Answer & Explanation
Sign in or unlock 70-448 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
Question
You are developing a SQL Server 2008 Analysis Services (SSAS) solution which includes a time dimension called TestTime which includes a hierarchy called Year-By-Day for Company.com. You own a measure called Number from a measure group called MeasureTester. In the previous time period for the current level of the Yer-Bet-Day hierarchy, you should make sure that you develop a calculated member to show the Number measure. Which is the correct answer?
Options
- AYou should utilize [Measures].[ Number],OPENINGPERIOD [TestTime].[Yer-Bet- Day].FirstSibling.Level))
- BYou should utilize ([Measures].[ Number],LASTPERIODS( 0,[TestTime].[Yer-Bet- Day].PrevMember))
- CYou should utilize ([Measures].[ Number],LASTPERIODS( 1,[TestTime].[Yer-Bet- Day].PrevMember))
- DYou should utilize ([Measures].[ Number],[ TestTime].[Yer-Bet-Day].NextSibling)
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.