Salesforce Certified Data Architecture Practice Test

What relationship should be created to ensure a Shipment custom object relates to a Product, Sender, and Receiver?

1. Associate the Shipment to each parent record using a VLOOKUP formula field.

2. Create a required Lookup relationship to each of the three parent records.

3. Create a Master-Detail relationship to each of the three parent records.

4. Create two Master-Detail and one Lookup relationship to the parent records.

The correct answer is: Create a required Lookup relationship to each of the three parent records.

Creating a required Lookup relationship to each of the three parent records (Product, Sender, and Receiver) is the most appropriate choice for ensuring that the Shipment custom object relates effectively to these parent entities. A Lookup relationship allows you to establish a link between two objects, where one object (in this case, the Shipment) references another object (the parent records). By making these relationships required, you ensure that every Shipment record must be associated with a corresponding Product, Sender, and Receiver, thus maintaining data integrity. This setup is particularly useful when the relationships are not tightly coupled, as it allows for independent management of the related records while still linking them together. While a Master-Detail relationship provides a stronger bond between objects (where the child record's lifecycle is dependent on the parent), it is not necessary if these relationships do not need to enforce such strict dependencies or if you want the flexibility to have Shipment records stand alone without being deleted when their associated Products, Senders, or Receivers are deleted. The alternative options either add unnecessary complexity or do not fulfill the requirements as effectively as the Lookup relationships.