Home
Exams
Providers
About
Sign In
Sign Up
Home
/
Exams
/
Salesforce Certified Einstein Analytics and Discovery Consultant
/
Question #3
#3
Multiple Choice
Mark for review
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’;
Reveal Answer
Previous
Question 3 of 60
Exam CERTIFIED-EINSTEIN-ANALYTICS-AND-DISCOVERY-CONSULTANT Topic 1 Question 3
Back to all questions
Next
Sign In
Sign Up