Câu 3: Salesforce Certified Einstein Analytics and Discovery Consultant

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

1. 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’;
2. 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’;
3. 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’;
4. 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’; — đáp án hiện tại