> > >

Data Warehousing MCQs

All else being equal, which of the following elements of a single MDX WHERE clause will evaluate first?

MEMBER [Measures].[A Squared] AS [Measures].[Measure A] * [Measures].[Measure A], SOLVE_ORDER = 2

MEMBER [Measures].[C Less One] AS [Measures].[Measure C] - 1, SOLVE_ORDER = 1

All elements evaluate simultaneously

MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4

Answer

Correct Answer: MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Data Warehousing Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it