← Back to exam page

70-467 – Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Loading demo links...

Showing 10–10 of 10 questions

Question 10 (Case Study 1)

You need to define the trend calculation for the sales performance KPI.

Which KPI trend MDX expression should you use?

Select an option, then click Submit answer.

  • ○

    CASE
    WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN -1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE 1
    END
  • ○

    IIF([Sales Variance %3 < ([Sales Variance %], [Date].[Calendar].PrevMember), 1, 0)
  • ○

    IIF([Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember), 0, 1)
  • ○

    CASE
    WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE -1
    END