Salesforce Exam ANC-301 Topic 1 Question 11 Discussion

Actual exam question for Salesforce's ANC-301 exam

Question #: 11
Topic #: 1

An CRM Analytics consultant is working with Ursa Major Solar to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account should only have one active subscription. The consultant notices the Opportunity record does NOT specify whether it is a renewal or a net new subscription.

Which data transformation should the consultant use to determine if a subscription is new or a renewal?

AFlatten

BCustom Multiple row formula

CCustom Formula

Show Suggested Answer

Suggested Answer: A

https://help.salesforce.com/articleView?id=bi_security_datasets_row_level.htm

https://help.salesforce.com/articleView?id=managing_the_sharing_model.htm&type=5

by Skye at Feb 26, 2023, 10:31 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Phil

1 months ago

I'm with the rest of you on C) Custom Formula. Seems like the obvious choice here, unless the consultant has some serious data wrangling skills up their sleeve.

upvoted 0 times

Laurene

3 days ago

B) Custom Multiple row formula

upvoted 0 times

...

Thersa

10 days ago

A) Flatten

upvoted 0 times

...

Leigha

2 months ago

Ha! Looks like the consultant needs to do a bit of data gymnastics to figure this out. C) Custom Formula is definitely the way to go, but I'd also suggest a pep talk for the poor consultant before they dive in.

upvoted 0 times

Brynn

4 days ago

C) Custom Formula

upvoted 0 times

...

Mindy

5 days ago

B) Custom Multiple row formula

upvoted 0 times

...

Donte

8 days ago

A) Flatten

upvoted 0 times

...

Daren

2 months ago

I agree, C) Custom Formula seems like the way to go. We can use that to create a calculated field that flags whether the subscription is new or a renewal.

upvoted 0 times

Arthur

26 days ago

Agreed, using a custom formula to flag new or renewal subscriptions is the way to go.

upvoted 0 times

...

Lynna

1 months ago

Yes, I think C) Custom Formula would be the best option for this situation.

upvoted 0 times

...

Emelda

2 months ago

Hmm, this is a tricky one. I'm leaning towards C) Custom Formula, since we need to determine if the subscription is new or a renewal based on the information available in the Opportunity record.

upvoted 0 times

...