Salesforce
CRT-450 · Question #110
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…
The correct answer is B. [SELECT Id, (SELECT Id FROM Job_Applications_r) FROM Contact WHERE Accounts.Industry. See the full explanation below for the reasoning.
Question
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?
Options
- A[SELECT Id, (SELECT Id FROM Job_Applications_r) FROM Contact WHERE Account.Industry =
- B[SELECT Id, (SELECT Id FROM Job_Applications_r) FROM Contact WHERE Accounts.Industry
- C[SELECT Id, (SELECT Id FROM Job_Applications_c) FROM Contact WHERE Accounts.Industry
- D[SELECT Id, (SELECT Id FROM Job_Application_c) FROM Contact WHERE Account.Industry =
How the community answered
(48 responses)- A8% (4)
- B71% (34)
- C4% (2)
- D17% (8)
Community Discussion
No community discussion yet for this question.