Discuss Salesforce DEX-450 Exam Topic 1 Question 49

Which query should a developer use to obtain the Id and Name of all the Leads, Accounts, and Contacts that have the company name 'Universal Containers'?

AIND 'Universal Containers' IN Name Fields RETURNING lead(id, name), account(id,name), contact(id,name)

BSELECT lead(id, name), account(id, name), contact(id,name) FROM Lead, Account, Contact WHERE Name = 'Universal Containers'

CFIND 'Universal Containers' IN CompanyName Fields RETURNING lead(id,name), account (id,name), contact(id,name)

DSELECT Lead.id, Lead. Name, Account.id, Account.Name, Contact.Id, Contact. Name FROM Lead, Account, Contact WHERE CompanyName = 'Universal Containers'

Suggested Answer: A

Get Premium DEX-450 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

11 comments · newest first

Izetta 12 months ago

Why are we using 'FIND' in C? That seems off.

Olive 12 months ago

I agree with D, seems more straightforward.

Brice 12 months ago

Wait, isn't 'CompanyName' a field in the Account object only?

Tawna 1 year ago

I think D is the right choice.

Caren 1 year ago

Option C looks correct to me!

Nada 1 year ago

Option D looks like it follows the SQL style, but I’m not sure if it’s the correct approach for this specific query.

Gerri 1 year ago

I’m a bit confused about the syntax in option B. It seems off to me, but I can't recall the exact reason why.

Tesha 1 year ago

I remember practicing a similar question, and I feel like the "RETURNING" keyword is important, which makes me lean towards option A or C.

Carrol 1 year ago

I think option C sounds familiar, but I'm not entirely sure if "CompanyName" is the right field to use.

Noemi 1 year ago

Okay, I think I've got this. The key is to determine how the acquisition price of Flavoring will impact Fashion's post-merger earnings. If the price is $20 or lower, that should create a bootstrap earnings effect, which is what the question is asking about.

Vashti 1 year ago

I'm confident I know the answer to this one. Based on my understanding of PRINCE2, the Project Board would need to approve replacing a Stage Plan with an Exception Plan, as they are responsible for managing project exceptions.

Salesforce DEX-450 Exam - Topic 1 Question 49 Discussion