BlackFriday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

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

Contribute your Thoughts:

Kami
21 days 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
Rosio
6 days 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
7 days 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
9 days ago
I think the answer is using a SOQL query with a WHERE clause to filter for the 'ACME' phrase.
upvoted 0 times
...
...
Edelmira
30 days ago
I'm just here for the 'ACME' reference. Wile E. Coyote would be proud.
upvoted 0 times
Charolette
10 days ago
That's correct! ACME always reminds me of the Road Runner and Wile E. Coyote.
upvoted 0 times
...
Mignon
12 days 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
21 days ago
Me too! I love the ACME reference.
upvoted 0 times
...
...
Whitney
1 months ago
Why do you think D is the correct answer?
upvoted 0 times
...
Shaun
1 months ago
Wait, do we get partial credit if we choose 'ACME Explosives' instead of just 'ACME'?
upvoted 0 times
Rosio
4 days ago
I think it's better to stick with just 'ACME' to be safe.
upvoted 0 times
...
Louvenia
18 days ago
No, you will not get partial credit if you choose 'ACME Explosives' instead of just 'ACME'.
upvoted 0 times
...
Merissa
28 days ago
Yes, you will get partial credit if you choose 'ACME Explosives' instead of just 'ACME'.
upvoted 0 times
...
...
Judy
1 months ago
I disagree, I believe it's D.
upvoted 0 times
...
Whitney
1 months ago
I think the correct answer is B.
upvoted 0 times
...
Amber
2 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
2 months ago
I think option D is the way to go. Simple and straightforward.
upvoted 0 times
...
Katie
2 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
11 days ago
Venita: No problem, happy to help!
upvoted 0 times
...
Zack
11 days ago
That makes sense, thanks for clarifying.
upvoted 0 times
...
Venita
15 days ago
I agree, option B uses the FIND keyword to search for 'ACME' in all fields.
upvoted 0 times
...
Yoko
29 days ago
I think the answer is B.
upvoted 0 times
...
...

Save Cancel