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
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Exam DEX-450 Topic 2 Question 102 Discussion

Actual exam question for Salesforce's DEX-450 exam
Question #: 102
Topic #: 2
[All DEX-450 Questions]

Which statement generates a list of Leads and Contacts that have a field with the phrase 'ACME'?

Show Suggested Answer Hide Answer
Suggested Answer: B

by Verona at Sep 18, 2024, 09:06 AM

Limited Time Offer

25%

Off

Get Premium DEX-450 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel
Kami
3 months ago
I wonder if the answer involves using a giant slingshot or an Acme-brand anvil to find those leads and contacts.
upvoted 0 times
Gracia
2 months ago
I'm not sure about the giant slingshot or Acme-brand anvil, but those are creative ideas!
upvoted 0 times
...
Leontine
2 months ago
Maybe you can create a custom report type that includes both Leads and Contacts with the 'ACME' field.
upvoted 0 times
...
Sarah
3 months ago
Actually, I think it's 'SELECT Id, Name FROM Lead WHERE Field LIKE 'ACME%' OR Id, Name FROM Contact WHERE Field LIKE 'ACME%'.
upvoted 0 times
...
Gearldine
3 months ago
No, I believe it's 'SELECT Id, Name FROM Lead WHERE Field = 'ACME' OR Id, Name FROM Contact WHERE Field = 'ACME'.
upvoted 0 times
...
Rosio
3 months ago
You could also use a report in Salesforce to generate a list of Leads and Contacts with the 'ACME' field.
upvoted 0 times
...
Alline
3 months ago
I think the answer is 'SELECT Id, Name FROM Lead WHERE Field LIKE '%ACME%' OR Id, Name FROM Contact WHERE Field LIKE '%ACME%'.
upvoted 0 times
...
Precious
3 months ago
I think the answer is using a SOQL query with a WHERE clause to filter for the 'ACME' phrase.
upvoted 0 times
...
...
Edelmira
4 months ago
I'm just here for the 'ACME' reference. Wile E. Coyote would be proud.
upvoted 0 times
Charolette
3 months ago
That's correct! ACME always reminds me of the Road Runner and Wile E. Coyote.
upvoted 0 times
...
Mignon
3 months ago
I think the statement you're looking for is 'SELECT Id, Name FROM Lead WHERE Field__c LIKE '%ACME%' OR Id, Name FROM Contact WHERE Field__c LIKE '%ACME%'.
upvoted 0 times
...
Arlyne
3 months ago
Me too! I love the ACME reference.
upvoted 0 times
...
...
Whitney
4 months ago
Why do you think D is the correct answer?
upvoted 0 times
...
Shaun
4 months ago
Wait, do we get partial credit if we choose 'ACME Explosives' instead of just 'ACME'?
upvoted 0 times
Dwight
3 months ago
Let's go with 'ACME' to make sure we get full credit.
upvoted 0 times
...
Rosio
3 months ago
I think it's better to stick with just 'ACME' to be safe.
upvoted 0 times
...
Louvenia
3 months ago
No, you will not get partial credit if you choose 'ACME Explosives' instead of just 'ACME'.
upvoted 0 times
...
Merissa
3 months ago
Yes, you will get partial credit if you choose 'ACME Explosives' instead of just 'ACME'.
upvoted 0 times
...
...
Judy
4 months ago
I disagree, I believe it's D.
upvoted 0 times
...
Whitney
4 months ago
I think the correct answer is B.
upvoted 0 times
...
Amber
4 months ago
Hmm, I'm not sure. They all look pretty similar to me. Maybe I'll just guess and hope for the best.
upvoted 0 times
...
Leeann
4 months ago
I think option D is the way to go. Simple and straightforward.
upvoted 0 times
...
Katie
4 months ago
Option B is the correct answer. It uses the FIND keyword to search for the phrase 'ACME' in all fields across both Contacts and Leads.
upvoted 0 times
Andree
3 months ago
Venita: No problem, happy to help!
upvoted 0 times
...
Zack
3 months ago
That makes sense, thanks for clarifying.
upvoted 0 times
...
Venita
3 months ago
I agree, option B uses the FIND keyword to search for 'ACME' in all fields.
upvoted 0 times
...
Yoko
4 months ago
I think the answer is B.
upvoted 0 times
...
...

Save Cancel