Salesforce Exam DEX-450 Topic 10 Question 86 Discussion

Actual exam question for Salesforce's DEX-450 exam

Question #: 86
Topic #: 10

The Job_Application__c custom object has a field that is a Master-Detail relationship to the Contact object, where the Contact object is the Master. As part of a feature implementation, a developer needs to retrieve a list containing all Contact records where the related Account Industry is 'Technology' while also retrieving the contact's Job_Application__c records.

Based on the object's relationships, what is the most efficient statement to retrieve the list of contacts?

A[SELECT Id, (SELECT Id FROM Job_Applications_r) FROM Contact WHERE
Account.Industry = 'Technology'];

B[SELECT Id, (SELECT Id FROM Job_Applications_r) FROM Contact WHERE
Accounts.Industry = 'Technology'];

C[SELECT Id, (SELECT Id FROM Job_Applications_c) FROM Contact WHERE
Accounts.Industry = 'Technology'];

D[SELECT Id, (SELECT Id FROM Job_Application_c) FROM Contact WHERE
Account.Industry = 'Technology'];

Show Suggested Answer

Suggested Answer: B

by Kris at Apr 10, 2024, 09:55 PM

Limited Time Offer

25%

Off

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

Comments

Submit Cancel

Regenia

1 days ago

Okay, let's break this down. We need to retrieve all Contact records where the related Account Industry is 'Technology', and also get the associated Job_Application__c records. I'm leaning towards option A, since it seems to be the most straightforward approach.

upvoted 0 times

...

Hubert

3 days ago

Hmm, this is an interesting question. I'm not too sure about the difference between using 'Job_Applications_r' and 'Job_Application_c' in the subqueries. I'll have to think through this carefully.

upvoted 0 times

...