ADM-201 · Question #236
The administrator at Ursa Major Solar has been asked to change the Work Item and Project custom object relationship from a master-detail to a lookup. Which scenario could prevent the administrator…
The correct answer is B. Roll-up summary fields exist on the master object. Changing a master-detail relationship to a lookup can be prevented if roll-up summary fields are defined on the master object, as these fields rely on the master-detail relationship to aggregate data from child records.
Question
The administrator at Ursa Major Solar has been asked to change the Work Item and Project custom object relationship from a master-detail to a lookup. Which scenario could prevent the administrator from fulfilling this requirement?
Options
- AA junction object is required to support the lookup.
- BRoll-up summary fields exist on the master object.
- CThe lookup field in all the records contains a value.
- DThe lookup field is required for saving records.
How the community answered
(41 responses)- A2% (1)
- B90% (37)
- C5% (2)
- D2% (1)
Why each option
Changing a master-detail relationship to a lookup can be prevented if roll-up summary fields are defined on the master object, as these fields rely on the master-detail relationship to aggregate data from child records.
A junction object is used for many-to-many relationships and is not a direct impediment to changing a master-detail to a lookup; rather, a lookup is part of how a junction object is formed.
Roll-up summary fields aggregate data from child (detail) records and display it on the parent (master) record, a feature exclusively supported by master-detail relationships. Converting the relationship to a lookup would break the functionality of these fields, thus Salesforce prevents the conversion.
Whether the lookup field contains values in all records is not a barrier to changing the relationship type, although it might affect data integrity or require data cleanup.
A lookup field being required for saving records is a configuration on the field itself and does not prevent the conversion from a master-detail to a lookup.
Concept tested: Master-detail to lookup conversion restrictions
Source: https://help.salesforce.com/s/articleView?id=sf.fields_about_master_detail.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.