Certified Data Architect Exam QuestionsBrowse all questions from this exam
Go to Exam

Certified Data Architect Exam - Question 8

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?

Show Answer
Correct Answer: CD

The requirements indicate that legacy inventory data will be stored in a custom child object (Inventory__c) and needs to inherit the same sharing rules as the standard Account object. Additionally, related Inventory__c records should be deleted when an Account record is deleted. The proper relationship for these requirements is a Master-Detail relationship on Inventory__c related to Account. This ensures that Inventory__c records follow the sharing rules of the Account and are automatically deleted when the related Account is deleted.

Discussion

8 comments
Sign in to comment
bssrilakshmiOption: C
May 1, 2023

Correct answer: C

BorisBorisOption: C
Jun 23, 2023

C is correct. On the Inventory__c Object, we create a field called Account and for field type, we designate M/D. Then we are prompted to select an Object to which we want this to look-up to and we choose Account. In doing so, we cxreate an M/D relationship i.e Many-to-one

AlokvOption: C
May 28, 2023

Correct answer is C. Account can't be a child object in master detail realtionship.

thneebOption: C
Jun 28, 2023

Definitly C

kshoOption: C
Sep 14, 2023

C - master detail fields are created on the child object and related to the parent object

DavidHollandOption: C
Nov 22, 2023

Definitely C, s account cannot be a child in a master detail

lizbetteOption: C
Apr 20, 2024

C. Remember the syntax on Master-Detail relationships. They are created on the child object, and used to add a relationship that links the child object to the parent. In this case, the child object is the Custom Inventory Object, and the parent is the Account object. Therefore, the syntax is that we create the Master-Detail relationship ON the inventory object, to link it to the Account parent.

Nilesh_NandaOption: C
May 7, 2024

C is correct answer