PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer to make sure that you could develop a called setTester that connects with the firs

You are developing a SQL Server 2008 Analysis Services (SSAS) method which owns a date dimension called DateTester along with a rule called CalendarTester for Company.com.

The CalendarTester rule owns levels for the Year, Quarter, Month, and Date properties.
You should make sure that you could develop a called setTester that connects with the first eight months of the year 2008.

Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should use the expression below:
[ Yr-Qtr-Mth].[Year], [DimTime].[Yr-Qtr-Mth].[Month].[August 2008])

B.
You should use the expression below:
[ yr-day].[Month], [DimTime].[Yr-Qtr-Mth].[Month].[ August 2008])

C.
You should use the expression below:
[yr-day]. [Month],8, [DimTime].[ yr-day].[Month].[ August 2008])

D.
You should use the expression below:
[ yr-day].[Year],8, [DimTime].[ yr-day].[Month].[ August 2008])


Leave a Reply