Question 250
An admin receives this request: An organization has a custom audit log object that must remain even if its related business record is deleted. Which resolution is most appropriate?
Explanation
Correct Answer
Use a lookup with carefully selected delete behavior instead of a cascading master-detail. It works because independent audit retention can conflict with master-detail cascading deletion. A successful test shows that an approved parent deletion leaves a legally required audit entry accessible.
Incorrect Answers
A cross-object formula exposes derived parent data without duplicating its stored value. The effective response here depends on: Independent audit retention can conflict with master-detail cascading deletion.
Inspect Deleted Fields in Object Manager and restore within supported retention conditions. Independent audit retention can conflict with master-detail cascading deletion.
Review the data model in Schema Builder and confirm relationship constraints. It does not resolve the critical issue: Independent audit retention can conflict with master-detail cascading deletion.