Salesforce Exam ANC-201 Topic 5 Question 36 Discussion

Actual exam question for Salesforce's ANC-201 exam

Question #: 36
Topic #: 5

Cloud Kicks (CK) has a dashboard in CRM Analytics with forecasting dat

a. One widget is a compare table using the timeseries function showing the quarterly forecast. However, CK is interested in enhancing the dashboard with a weekly forecast per customer.

How should CK achieve this?

AAn SAQL query with a timeseries statement specifying Opportunity Name as the partition and Y-M-W as the Date Cols

BAn SAQL query with a timeseries statement specifying Account Name as the partition and Y-M-W as the Date Cols

CAn SAQL query with @ timeseries statement specifying Account Name as the partition and Y-M-D as the Date Cols

Show Suggested Answer

Suggested Answer: B, D

by Charlene at Jun 03, 2024, 08:42 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Bonita

1 months ago

Weekly forecasts? Sounds like a recipe for information overload if you ask me. But hey, if the client wants it, option C is the way to go. Time to get your data-crunching pants on!

upvoted 0 times

Cassie

4 days ago

I think option C is the best choice for adding a weekly forecast per customer.

upvoted 0 times

...

Felix

2 months ago

Weekly forecasts? Yikes, that's going to be a big change. I think option A is the way to go - the Opportunity Name will give us the customer-level detail we need.

upvoted 0 times

Viola

16 days ago

Weekly forecasts will definitely be a big change, but option A seems like the right approach.

upvoted 0 times

...

Goldie

1 months ago

I think option A is the best choice for enhancing the dashboard with a weekly forecast per customer.

upvoted 0 times

...

Cathrine

1 months ago

I agree, using Opportunity Name as the partition will give us the customer-level detail we need.

upvoted 0 times

...

Stephaine

2 months ago

Weekly forecasts, huh? That's going to be a lot of data to crunch. Option C looks like the way to go - Y-M-D should give us the granularity we need.

upvoted 0 times

Devorah

18 hours ago

Great choice! Y-M-D will provide the weekly forecast per customer that Cloud Kicks is looking for.

upvoted 0 times

...

Lavonna

13 days ago

Let's go with Option C then. It seems like the best choice for enhancing the dashboard.

upvoted 0 times

...

Mitsue

16 days ago

I agree, weekly forecasts will require a lot of data to crunch.

upvoted 0 times

...

Barb

17 days ago

Option C looks good. Y-M-D will definitely give us the granularity we need.

upvoted 0 times

...

Lezlie

2 months ago

But using Opportunity Name as the partition makes more sense for a weekly forecast.

upvoted 0 times

...

Vernell

2 months ago

I disagree, I believe option B is the better choice.

upvoted 0 times

...

Annalee

2 months ago

Weekly forecasts per customer? Sounds like a lot of work, but it could be useful. I'd go with option B to keep things simple and focus on the Account Name.

upvoted 0 times

Vincenza

2 months ago

User2: Yeah, keeping it simple with Account Name makes sense for weekly forecasts per customer.

upvoted 0 times

...

Joanna

2 months ago

User1: I agree, option B seems like the best choice to focus on the Account Name.

upvoted 0 times

...

Lezlie

2 months ago

I think CK should go with option A.

upvoted 0 times

...