nerdexam
Salesforce

ADM-201 · Question #261

Cloud Kicks has a custom object named Shoe. The administrator has been asked to ensure that when a relationship is created between Account and Shoe to prevent orphaned shoe records. What should the…

The correct answer is D. Create a master-detail lookup. To ensure that child 'Shoe' records are automatically deleted when their parent 'Account' record is deleted, preventing orphaned records, a master-detail relationship should be created.

Submitted by klara.se· Apr 18, 2026Object Manager and Lightning App Builder

Question

Cloud Kicks has a custom object named Shoe. The administrator has been asked to ensure that when a relationship is created between Account and Shoe to prevent orphaned shoe records. What should the administrator do to complete this requirement?

Options

  • ACreate an indirect lookup
  • BCreate an encrypted lookup
  • CCreate a hierarchical lookup
  • DCreate a master-detail lookup

How the community answered

(51 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    2% (1)
  • D
    92% (47)

Why each option

To ensure that child 'Shoe' records are automatically deleted when their parent 'Account' record is deleted, preventing orphaned records, a master-detail relationship should be created.

ACreate an indirect lookup

An indirect lookup is used to link a child external object to a parent standard or custom object in Salesforce, not for preventing orphaned internal records.

BCreate an encrypted lookup

An encrypted lookup is not a standard relationship type; encryption is a field property for data security, not a mechanism to prevent orphaned records.

CCreate a hierarchical lookup

A hierarchical lookup is a special lookup relationship exclusively for the User object, allowing users to link to other users within a hierarchy.

DCreate a master-detail lookupCorrect

A master-detail relationship establishes a strong bond where the detail (child) record is deleted automatically when its master (parent) record is deleted, thereby preventing orphaned records and maintaining data integrity.

Concept tested: Master-Detail Relationship Behavior

Source: https://help.salesforce.com/s/articleView?id=sf.relationships_considerations.htm&type=5

Topics

#Master-Detail Relationship#Custom Objects#Data Modeling#Relationship Types

Community Discussion

No community discussion yet for this question.

Full ADM-201 Practice