PDI Question #110: Real Exam Question with Answer & Explanation

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 =

Explanation

The most efficient SOQL statement to retrieve Contacts with related Job Applications based on the parent Account's industry uses a subquery for Job Applications and correctly references the parent Account's Industry field as Account.Industry.

Common mistakes.

• A. This option incorrectly uses Accounts.Industry in the WHERE clause; the relationship from Contact to Account is singular, so it should be Account.Industry.
• C. This option incorrectly uses Job_Applications_c in the subquery instead of the relationship name Job_Applications__r, and also incorrectly uses Accounts.Industry in the WHERE clause.
• D. This option incorrectly uses Job_Application_c in the subquery instead of the plural child relationship name Job_Applications__r.

Concept tested. SOQL relationship queries (parent-to-child, child-to-parent)

Reference. https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships.htm

No community discussion yet for this question.