PDI · Question #38
Universal Container is building a recruiting app with an Applicant object that stores information about an individual person that represents a job. Each application may apply for more than one job…
The correct answer is C. Junction object between Applicant and Job. To represent a many-to-many relationship where one applicant can apply for multiple jobs and one job can have multiple applicants, a junction object should be implemented.
Question
Universal Container is building a recruiting app with an Applicant object that stores information about an individual person that represents a job. Each application may apply for more than one job. What should a developer implement to represent that an applicant has applied for a job?
Options
- AMaster-detail field from Applicant to Job
- BFormula field on Applicant that references Job
- CJunction object between Applicant and Job
- DLookup field from Applicant to Job
How the community answered
(26 responses)- A4% (1)
- B15% (4)
- C77% (20)
- D4% (1)
Why each option
To represent a many-to-many relationship where one applicant can apply for multiple jobs and one job can have multiple applicants, a junction object should be implemented.
A master-detail field would imply a one-to-many relationship, which contradicts the requirement for both 'many jobs' and 'many applicants'.
A formula field is used for calculating or displaying data, not for establishing record-to-record relationships.
A junction object is necessary to represent a many-to-many relationship between Applicant and Job, allowing each applicant to relate to multiple jobs and each job to relate to multiple applicants.
A lookup field creates a one-to-many relationship, allowing an Applicant to be linked to only one Job, or a Job to have many Applicants, but not both in a many-to-many context.
Concept tested: Many-to-many relationships and junction objects
Source: https://help.salesforce.com/s/articleView?id=sf.custom_field_junc_object.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.