Salesforce Exam ANC-301 Topic 2 Question 34 Discussion

Actual exam question for Salesforce's ANC-301 exam

Question #: 34
Topic #: 2

Which timeseries statement will fix the query?

Aq= timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=
('Date_Year', 'Date Quarter', 'Y-Q'), partition='Region', seasonality=4);

Bq = timeserles q generate 'sum_Sales' as 'Forecasted_Sales' with (length=12,
dateCols=('Date_Year', 'Date_Month', 'Y-M'), partition='Region');

Cq = timeseries q generate 'sum_Sales' as 'Forecasted_Sales' with (dateCols=
('Date_Quarter', 'Date_Month', 'Q-M'), partition='Region', ignoreLast=true);

Show Suggested Answer

Suggested Answer: A

by Denny at Jun 02, 2024, 05:41 PM

Limited Time Offer

25%

Off

Get Premium ANC-301 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Maxima

16 hours ago

Haha, looks like someone needs to double-check their spelling before submitting the exam!

upvoted 0 times

...

Luisa

6 days ago

Hold on, did you see that Option B has a typo in 'timeserles'? It should be 'timeseries'.

upvoted 0 times

...

Monte

7 days ago

I'm not sure about the 'Y-Q' in the dateCols parameter. Isn't it supposed to be 'Year-Quarter'?

upvoted 0 times

...

Lorrine

12 days ago

Option A seems to have the correct syntax for the timeseries statement. It includes the necessary parameters like dateCols, partition, and seasonality.

upvoted 0 times

...