PLAT-ADMN-202 practice question 26 of 35
Ursa Major Solar wants to create a relationship between the standard Contact object and a custom Solar Project object Contacts potentially be related to multiple Solar Project objects, and a Solar Project can have multiple Contacts associated with it. How should an app builder configure the data model?
Full set: 311 questionsDomain Object Manager and Lightning App Builder
The scenario requires a many-to-many relationship, where one Contact can be associated with multiple Solar Projects, and one Solar Project can be associated with multiple Contacts. The standard and most robust method to model this in Salesforce is by creating a third custom object, known as a junction object. This junction object should have two master-detail relationships: one to the Contact object and one to the Solar Project object. This configuration creates the strongest-typed relationship, enables cascading record deletion, inherits security from parent records, and allows for roll-up summary fields on both master objects.
A. One Master-detail relationship on Contact and one Master-detail relationship on Solar Project: This configuration does not create a junction object and cannot model a many-to-many relationship. It describes two separate, unrelated one-to-many relationships.
B. Two Lookup relationships on a new custom object: While this also creates a many-to-many relationship, it is a loosely coupled version. The master-detail relationship (Option D) is the standard, recommended pattern unless specific requirements (like separate ownership or preventing cascading deletes) exist.
C. One Lookup relationship on Contact and one Lookup relationship on Solar Project: This model fails to meet the requirement. A lookup field on the Contact object would only allow each Contact to relate to a single Solar Project, which contradicts the scenario.
1. Salesforce Help, "Create Object Relationships": This document outlines the different relationship types. For many-to-many, it states, "To create a many-to-many relationship, you simply create a custom junction object... Then, on the junction object, you create two master-detail relationships." This directly supports creating a new object with two master-detail relationships.
2. Salesforce Help, "Object Relationships Overview": Under the "Master-Detail" section, it explains, "Use a master-detail relationship to model a many-to-many relationship between any two objects." It then describes the use of a junction object with two master-detail fields as the method for implementation.
3. Trailhead, "Data Modeling" Module, "Create Object Relationships" Unit: This official training module explicitly teaches the creation of a many-to-many relationship using a junction object that contains two master-detail relationship fields, one for each object being related.
Keep practicing
Take the free PLAT-ADMN-202 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PLAT-ADMN-202 practice questions
- Question 1Universal Containers manages leads in a Lead qualification queue where sales reps can acc…
- Question 2Ursa Major Solar wants to see the Type field from the parent object Galaxy listed on the …
- Question 3Universal Containers (UC) utilizes two custom picklist fields called sales_Organization__…
- Question 4Which two features can be used to allow users to access Flows? Choose 2 answers
- Question 5Universal Containers wants some enhancements on its Opportunity page layout to improve ef…
- Question 6A business user wants a quick way to edit a record's status and enter a custom due date f…
