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'?

AList<List <sObject>> searchList = [SELECT Name, ID FROM Contact, Lead WHERE Name like 'tACME3'];

BList<List <sObject>> searchList = [FIND '*ACME*' IN ALL FIELDS RETURNING Contact, Lead];

CMap <sObject> searchList = [FIND '*ACME*' IN ALL FIELDS RETURNING Contact, Lead];

DList <sObject> searchList = [FIND '*ACME*' IN ALL FIELDS RETURNING Contact, Lead];

Show Suggested 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

2 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

16 days ago

I'm not sure about the giant slingshot or Acme-brand anvil, but those are creative ideas!

upvoted 0 times

...

Leontine

17 days ago

Maybe you can create a custom report type that includes both Leads and Contacts with the 'ACME' field.

upvoted 0 times

...

Sarah

1 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

1 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

1 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

1 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

1 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

2 months ago

I'm just here for the 'ACME' reference. Wile E. Coyote would be proud.

upvoted 0 times

Charolette

1 months ago

That's correct! ACME always reminds me of the Road Runner and Wile E. Coyote.

upvoted 0 times

...

Mignon

1 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

2 months ago

Me too! I love the ACME reference.

upvoted 0 times

...

Whitney

2 months ago

Why do you think D is the correct answer?

upvoted 0 times

...

Shaun

2 months ago

Wait, do we get partial credit if we choose 'ACME Explosives' instead of just 'ACME'?

upvoted 0 times

Dwight

1 months ago

Let's go with 'ACME' to make sure we get full credit.

upvoted 0 times

...

Rosio

1 months ago

I think it's better to stick with just 'ACME' to be safe.

upvoted 0 times

...

Louvenia

2 months ago

No, you will not get partial credit if you choose 'ACME Explosives' instead of just 'ACME'.

upvoted 0 times

...

Merissa

2 months ago

Yes, you will get partial credit if you choose 'ACME Explosives' instead of just 'ACME'.

upvoted 0 times

...

Judy

2 months ago

I disagree, I believe it's D.

upvoted 0 times

...

Whitney

2 months ago

I think the correct answer is B.

upvoted 0 times

...

Amber

3 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

3 months ago

I think option D is the way to go. Simple and straightforward.

upvoted 0 times

...

Katie

3 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

1 months ago

Venita: No problem, happy to help!

upvoted 0 times

...

Zack

1 months ago

That makes sense, thanks for clarifying.

upvoted 0 times

...

Venita

2 months ago

I agree, option B uses the FIND keyword to search for 'ACME' in all fields.

upvoted 0 times

...

Yoko

2 months ago

I think the answer is B.

upvoted 0 times

...