Exam CRT-450 topic 1 question 160 discussion

Actual exam question from Salesforce's CRT-450

Question #: 160
Topic #: 1

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: A 🗳️

by Pally88 at July 13, 2021, 2:30 p.m.

Comments

Submit Cancel

Pally88

Highly Voted 3 years, 4 months ago

Correct is A

upvoted 20 times

...

JCTheGenius

Highly Voted 3 years, 3 months ago

Response A: Contact is parent of Job_Application__c hence it can access child records using "__r" relationship. Account must be a parent of Contact so it is related using Account.xxx.

upvoted 12 times

...