Question 1 of 4 | Certs4All

Question 1 / 4

--:--

Question 1

A consultant wants to improve the performance of reports by moving calculations to the data layer
and materializing them in the extract.
Which calculation should the consultant use?

ZN([Sales])*(1 - ZN([Discount]))

CASE [Sector Parameter]
WHEN 1 THEN "green"
WHEN 2 THEN "yellow"

SUM([Profit])/SUM([Sales])

POWER(ZN(SUM([Sales]))/
LOOKUP(ZN(SUM([Sales])), FIRST()),ZN(1/(INDEX()-1)))
- 1
END

Correct Answer

Correct Answer:

You're on the free plan. Get Full Exam Access Unlock all questions, detailed explanations and more.

Get Premium →