Section 7 · Data and Analytics Management · 17% of exam
7.2 Matching rules, duplicate rules, and validation rules
Exam objective
Describe the capabilities and implications of data validation tools, including matching rules, duplicate rules, and validation rules.
Matching rules define how Salesforce identifies records that may be duplicates. Duplicate rules use matching results to allow, alert, or block record creation or editing according to configured behavior. Validation rules enforce business conditions by preventing a record from being saved when a formula evaluates to the specified error condition.
A duplicate rule can warn users or block likely duplicates, depending on the business requirement. A validation rule should express a condition that must be true before saving, such as requiring a reason when a status changes. Test imports, integrations, and user edits because automation and bulk tools may encounter rule behavior differently.
Additional concepts
The three tools do different work
Matching rules define how Salesforce identifies potential duplicates. Duplicate rules use matching results to allow, alert, or block a save according to configured behavior. Validation rules evaluate a formula and prevent a record from saving when the stated condition is violated.
Test entry paths and exceptions
Consider whether the rule should warn or block, which users need to correct the data, and how imports or integrations behave. A validation rule can enforce a required business condition, while duplicate management addresses possible repeated records. Test both expected and exception cases.
A company wants to prevent a second contact with the same email while requiring a cancellation reason when an opportunity is closed lost. Use a matching and duplicate rule for duplicate detection and a validation rule for the required reason.
Key takeaways
- Matching rules identify potential duplicates; duplicate rules determine how to respond.
- Validation rules enforce save-time business conditions.
- Test the effect on users, imports, integrations, and existing records.
