PD1 Data Modeling and Management 5 — Questions and Answers
Question 1: Which of the following actions is NOT possible with a standard Lookup relationship that IS possible with a Master-Detail relationship?
- Filtering related records in a related list
- Creating Roll-Up Summary fields on the parent (Correct answer)
- Displaying related records on the parent's page layout
- Querying child records via SOQL
Correct answer: Creating Roll-Up Summary fields on the parent
Roll-Up Summary fields can only be created on the master object of a Master-Detail relationship, not on Lookup relationship parents.
Question 2: In Salesforce, what does 'reparenting' refer to in the context of Master-Detail relationships?
- Moving a child record to a different parent record (Correct answer)
- Converting a Lookup to a Master-Detail relationship
- Assigning ownership of the master record to another user
- Merging two master records together
Correct answer: Moving a child record to a different parent record
Reparenting is the ability to change a child record's parent in a Master-Detail relationship; it is disabled by default but can be enabled in the relationship settings.
Question 3: A developer needs to track which user last modified a record. Which field automatically provides this information?
- CreatedById
- OwnerId
- LastModifiedById (Correct answer)
- ModifiedByUserId
Correct answer: LastModifiedById
The LastModifiedById standard field is automatically maintained by Salesforce and stores the ID of the user who last modified the record.
Question 4: When converting a Lookup relationship to a Master-Detail relationship, which prerequisite must be met?
- All child records must already have a value in the lookup field (Correct answer)
- The parent object must have fewer than 10,000 records
- The child object must have no triggers
- The lookup field must be unique
Correct answer: All child records must already have a value in the lookup field
Because Master-Detail relationships require a parent value, all existing child records must have a non-null lookup value before the conversion can proceed.
Question 5: What is the correct Salesforce term for the object that sits between two objects in a Many-to-Many relationship?
- Intermediary Object
- Bridge Object
- Junction Object (Correct answer)
- Linking Object
Correct answer: Junction Object
In Salesforce terminology, the object that sits between two related objects in a Many-to-Many relationship is officially called a Junction Object.
Question 6: A developer must ensure a custom field is indexed for faster SOQL query performance. Which field property achieves this?
- Setting the field as Required
- Marking the field as Unique
- Enabling the 'External ID' checkbox (Correct answer)
- Setting field-level security to Visible for all profiles
Correct answer: Enabling the 'External ID' checkbox
Marking a field as External ID automatically creates a database index on that field, improving SOQL query performance when filtering on it.
Question 7: What does the sharing model in a Master-Detail relationship mean for child records?
- Child records inherit the OWD of their own object type
- Child records inherit the sharing access level of the parent record (Correct answer)
- Child records always have private sharing regardless of the parent
- Child records must have the same owner as the parent
Correct answer: Child records inherit the sharing access level of the parent record
In a Master-Detail relationship, the child record's sharing access is controlled by the parent record's sharing settings — the child inherits the parent's access level.
PD1 Data Modeling and Management 5
Which of the following actions is NOT possible with a standard Lookup relationship that IS possible with a Master-Detail relationship?