Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Salesforce ANC-201 Exam - Topic 5 Question 36 Discussion

Cloud Kicks (CK) has a dashboard in CRM Analytics with forecasting data. 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?
B) An SAQL query with a timeseries statement specifying Account Name as the partition and Y-M-W as the Date Cols
A) An SAQL query with a timeseries statement specifying Opportunity Name as the partition and Y-M-W as the Date Cols
C) An SAQL query with @ timeseries statement specifying Account Name as the partition and Y-M-D as the Date Cols

Salesforce ANC-201 Exam - Topic 5 Question 36 Discussion

Actual exam question for Salesforce's ANC-201 exam
Question #: 36
Topic #: 5
[All ANC-201 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B, D

Contribute your Thoughts:

0/2000 characters
Vernell
8 months ago
Wait, can we really get accurate weekly forecasts? Sounds tricky!
upvoted 0 times
...
Ryan
8 months ago
Totally agree with B, it’s the most logical choice here!
upvoted 0 times
...
Florinda
8 months ago
C looks interesting, but why use Y-M-D instead of Y-M-W?
upvoted 0 times
...
Rolande
9 months ago
I think A is better, Opportunity Name gives more detail on sales.
upvoted 0 times
...
Clement
9 months ago
Option B seems right, using Account Name makes sense for customer-level forecasts.
upvoted 0 times
...
Stephane
9 months ago
I’m a bit confused about the partitioning. I thought Opportunity Name was more common, but now I’m not so sure.
upvoted 0 times
...
Cordelia
9 months ago
I’m leaning towards option C because it mentions the @ timeseries, which seems relevant for detailed timeframes like weekly.
upvoted 0 times
...
Barney
9 months ago
I think we did a similar question where we had to specify the date columns. I feel like Y-M-D might be the right choice for weekly forecasts.
upvoted 0 times
...
Lucia
9 months ago
I remember we practiced using SAQL queries, but I'm not sure if we should use Opportunity Name or Account Name for the partition.
upvoted 0 times
...
Renea
9 months ago
This is a tricky one, but I think option B is the way to go. Partitioning by Account Name and using Y-M-W for the date should give us the weekly forecast per customer that the question is asking for.
upvoted 0 times
...
Derrick
9 months ago
I'm not too familiar with SAQL, but it seems like option A with the Opportunity Name partition could also work to get the weekly forecast per customer. I'll have to double-check the details on that one.
upvoted 0 times
...
Dana
9 months ago
Okay, I think I've got this. The key is to use the timeseries function in SAQL and partition by the customer/account to get the weekly forecast per customer. Option B seems like the right approach to me.
upvoted 0 times
...
Beckie
9 months ago
I'm a bit confused on the difference between the Y-M-W and Y-M-D date options. Does Y-M-W give a true weekly forecast, or is Y-M-D the better choice here?
upvoted 0 times
...
Barb
10 months ago
Hmm, this looks like it's asking for a weekly forecast per customer. I think option B with the SAQL query using Account Name as the partition and Y-M-W as the Date Cols could work for that.
upvoted 0 times
...
Hermila
10 months ago
Hmm, I'm not totally sure about this one. I'll have to review my notes on container security to try to figure out the best answer.
upvoted 0 times
...
Carlene
10 months ago
Okay, the key here is to update the username without losing the application history. I think the admin portal solution is a good starting point, but I'll need to double-check if that meets the stated goal.
upvoted 0 times
...
Marica
10 months ago
RADIUS seems out of place here; I can't recall it being an Enterprise CA option like the others.
upvoted 0 times
...
Darell
10 months ago
Hmm, this seems like a tricky one. I'll need to think through the capabilities of each service to determine which one can handle both ingesting and storing the data in Parquet format.
upvoted 0 times
...
Janella
10 months ago
This question seems straightforward, I'll just need to carefully read through the options and choose the three most desirable characteristics.
upvoted 0 times
...
Bonita
1 year 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
Laquita
1 year ago
Time to crunch some numbers and make that dashboard even better!
upvoted 0 times
...
Latanya
1 year ago
Agreed, it might be a lot of data to handle, but that's what the client wants.
upvoted 0 times
...
Cassie
1 year ago
I think option C is the best choice for adding a weekly forecast per customer.
upvoted 0 times
...
...
Felix
1 year 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
1 year ago
Weekly forecasts will definitely be a big change, but option A seems like the right approach.
upvoted 0 times
...
Goldie
1 year ago
I think option A is the best choice for enhancing the dashboard with a weekly forecast per customer.
upvoted 0 times
...
Cathrine
1 year ago
I agree, using Opportunity Name as the partition will give us the customer-level detail we need.
upvoted 0 times
...
...
Stephaine
1 year 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
1 year ago
Great choice! Y-M-D will provide the weekly forecast per customer that Cloud Kicks is looking for.
upvoted 0 times
...
Lavonna
1 year ago
Let's go with Option C then. It seems like the best choice for enhancing the dashboard.
upvoted 0 times
...
Mitsue
1 year ago
I agree, weekly forecasts will require a lot of data to crunch.
upvoted 0 times
...
Barb
1 year ago
Option C looks good. Y-M-D will definitely give us the granularity we need.
upvoted 0 times
...
...
Lezlie
1 year ago
But using Opportunity Name as the partition makes more sense for a weekly forecast.
upvoted 0 times
...
Vernell
1 year ago
I disagree, I believe option B is the better choice.
upvoted 0 times
...
Annalee
1 year 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
1 year ago
User2: Yeah, keeping it simple with Account Name makes sense for weekly forecasts per customer.
upvoted 0 times
...
Joanna
1 year ago
User1: I agree, option B seems like the best choice to focus on the Account Name.
upvoted 0 times
...
...
Lezlie
1 year ago
I think CK should go with option A.
upvoted 0 times
...

Save Cancel