Salesforce Exam CRT-450 Topic 5 Question 53 Discussion

Actual exam question for Salesforce's CRT-450 exam

Question #: 53
Topic #: 5

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 Rolande at Jun 03, 2024, 06:13 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Loreta

4 months ago

I'm going with Option A. It just makes the most sense to me. Although, I have to admit, I'm a little disappointed they didn't include a joke about the 'Technology' industry. Missed opportunity, if you ask me.

upvoted 0 times

...

Kandis

4 months ago

Option A for the win! Gotta love that subquery syntax. It's like a secret code that only us Salesforce wizards can decipher.

upvoted 0 times

...

Goldie

4 months ago

Haha, 'Accounts.Industry'? Really? I'm pretty sure it's 'Account.Industry'. But hey, at least they're trying, right?

upvoted 0 times

Hildegarde

3 months ago

Haha, yeah, they almost had it right with 'Accounts.Industry' but it should be 'Account.Industry'.

upvoted 0 times

...

Madonna

4 months ago

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

upvoted 0 times

...

5 months ago

I think the answer is A.

upvoted 0 times

...