Exam Certified Einstein Analytics and Discovery Consultant topic 1 question 3 discussion

Actual exam question from Salesforce's Certified Einstein Analytics and Discovery Consultant

Question #: 3
Topic #: 1

Which set of statements generates monthly amount on a cumulative basis annually?

A. result = load “opportunity1”;
result = group result by (‘CloseDate_Year’,’CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([..0] partition by ‘CloseDate_Year’ order by (‘CloseDate_Year’,’CloseDate_Month’)) as ‘Cumulative Closed Amount’;
B. result = load “opportunity1”;
result = group result by (‘CloseDate_Year’,’CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([..] partition by ‘CloseDate_Year’ order by (‘CloseDate_Year’,’CloseDate_Month’)) as ‘Cumulative Closed Amount’;
C. result = load “opportunity1”;
result = group result by (‘CloseDate_Year’,’CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([..0] partition by all order by (‘CloseDate_Year’,’CloseDate_Month’)) as ‘Cumulative Closed Amount’;
D. result = load “opportunity1”;
result = group result by (‘CloseDate_Year ~ ~ ~ CloseDate_Month’); result = foreach result generate ‘CloseDate_Year’,’CloseDate_Month’, sum(sum(Amount)) over ([..0] partition by ‘CloseDate_Year’ order by (‘CloseDate_Year’,’CloseDate_Month’)) as ‘Cumulative Closed Amount’;

Show Suggested Answer

Suggested Answer: D 🗳️

by [deleted] at Oct. 13, 2023, 7:17 a.m.

Submit Cancel

1 year, 1 month ago

Selected Answer: A

The correct answer is A, D uses an old syntax ~~~

upvoted 2 times

...