Salesforce Certified Data Architect — Question 2

Universal Containers (UC) is in the process of migrating legacy inventory data from an enterprise resource planning (ERP) system into Sales Cloud with the following requirements:
1. Legacy inventory data will be stored in a custom child object called Inventory__c.
2. Inventory data should be related to the standard Account object.
3. The Inventory__c object should inherit the same sharing rules as the Account object.
4. Anytime an Account record is deleted in Salesforce. the related Inventory__c record(s) should be deleted as well.
What type of relationship field should a data architect recommend in this scenario?

Answer options

• A. Lookup relationship field on Inventory__c, related to Account
• B. Indirect lookup relationship field on Account, related to Inventory__c
• C. Master-detail relationship field on Inventory__c, related to Account
• D. Master-detail relationship field on Account, related to Inventory__c

Correct answer: C

Explanation

The correct answer is C, as a Master-detail relationship between Inventory__c and Account ensures that the Inventory__c records inherit the sharing rules of Account and are deleted when the Account is deleted. Options A and B do not provide the same level of dependency and do not automatically enforce the deletion behavior. Option D incorrectly suggests a master-detail relationship in the opposite direction, which does not meet the requirements.