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 DEX-450 Exam - Topic 1 Question 49 Discussion

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'?
A) IND 'Universal Containers' IN Name Fields RETURNING lead(id, name), account(id,name), contact(id,name)
B) SELECT lead(id, name), account(id, name), contact(id,name) FROM Lead, Account, Contact WHERE Name = 'Universal Containers'
C) FIND 'Universal Containers' IN CompanyName Fields RETURNING lead(id,name), account (id,name), contact(id,name)
D) SELECT Lead.id, Lead. Name, Account.id, Account.Name, Contact.Id, Contact. Name FROM Lead, Account, Contact WHERE CompanyName = 'Universal Containers'

Salesforce DEX-450 Exam - Topic 1 Question 49 Discussion

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

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

Show Suggested Answer Hide Answer
Suggested Answer: A

by Dalene at May 09, 2022, 05:15 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Izetta
7 months ago
Why are we using 'FIND' in C? That seems off.
upvoted 0 times
...
Olive
7 months ago
I agree with D, seems more straightforward.
upvoted 0 times
...
Brice
7 months ago
Wait, isn't 'CompanyName' a field in the Account object only?
upvoted 0 times
...
Tawna
8 months ago
I think D is the right choice.
upvoted 0 times
...
Caren
8 months ago
Option C looks correct to me!
upvoted 0 times
...
Nada
8 months 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.
upvoted 0 times
...
Gerri
8 months 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.
upvoted 0 times
...
Tesha
8 months 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.
upvoted 0 times
...
Carrol
8 months ago
I think option C sounds familiar, but I'm not entirely sure if "CompanyName" is the right field to use.
upvoted 0 times
...
Noemi
8 months 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.
upvoted 0 times
...
Vashti
8 months 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.
upvoted 0 times
...

Save Cancel