Salesforce Certified Einstein Analytics and Discovery Consultant — Question 7

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

Answer options

• 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’;

Correct answer: D

Explanation

Option D is correct because it correctly groups the data by 'CloseDate_Year' while maintaining the necessary order for cumulative calculations. Options A and B use incorrect partition references, while option C incorrectly partitions by 'all', which does not yield cumulative results by year.