Salesforce ANC-301 Exam - 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

Laila

7 months ago

Flattening won't help identify new vs. renewal, just saying!

upvoted 0 times

...

Marylou

7 months ago

Not sure if a Custom Multiple row formula is the right choice.

upvoted 0 times

...

Luis

7 months ago

Wait, can we really tell renewals from new subscriptions without extra data?

upvoted 0 times

...

Samira

8 months ago

Totally agree, it’s the most straightforward approach!

upvoted 0 times

...

Staci

8 months ago

I think a Custom Formula would work best here.

upvoted 0 times

...

Shaun

8 months ago

I definitely recall that we need to analyze the relationship between opportunities, but I'm not clear if a Custom Formula is the best choice for this specific scenario.

upvoted 0 times

...

Claribel

8 months ago

I'm a bit confused about whether we should use Flatten or a Custom Formula. I feel like Flatten is more for simplifying data, not for determining renewal status.

upvoted 0 times

...

Cordelia

8 months ago

I remember practicing a similar question where we had to identify records based on conditions, and I think a Custom Multiple row formula could work here too.

upvoted 0 times

...

Jamey

8 months ago

I think we might need a Custom Formula to differentiate between new and renewal subscriptions, but I'm not entirely sure how to set that up.

upvoted 0 times

...

Janet

8 months ago

Okay, I think I've got this. The key is to find the setting that will automatically log out users after 10 minutes of inactivity, so they can't view sensitive data. I'm leaning towards option D, "Force logout on session timeout."

upvoted 0 times

...

Clorinda

8 months ago

I remember learning about redundant storage systems during our cloud architecture module. That might be the right choice for failover.

upvoted 0 times

...

Tien

8 months ago

Hmm, I'm a bit unsure about this one. I know Genesys Cloud has a lot of different features, and I want to make sure I select the right one. Let me think this through carefully.

upvoted 0 times

...

Phil

1 year 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

Lashunda

11 months ago

C) Custom Formula

upvoted 0 times

...

Laurene

12 months ago

B) Custom Multiple row formula

upvoted 0 times

...

Thersa

1 year ago

A) Flatten

upvoted 0 times

...

Leigha

1 year 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

12 months ago

C) Custom Formula

upvoted 0 times

...

Mindy

12 months ago

B) Custom Multiple row formula

upvoted 0 times

...

Donte

1 year ago

A) Flatten

upvoted 0 times

...

Daren

1 year 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

1 year ago

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

upvoted 0 times

...

Lynna

1 year ago

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

upvoted 0 times

...

Emelda

1 year 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

...