DATA-ARCHITECT practice question 11 of 35

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system. Which solution should a data architect recommend to remediate the duplication issue?

Full set: 257 questions
Answer options
A: Develop an ETL process that utilizers the merge API to merge the duplicate records Correct answer
B: Utilize a data warehouse as the system of truth
C: Extract the data using data loader and use excel to merge the duplicate records
D: Implement duplicate rules
Correct Answer:
A. Develop an ETL process that utilizers the merge API to merge the duplicate records
Explanation

Given the large volume of records (2 million accounts with 500,000 duplicates), a manual or UI-based approach is not feasible. The most scalable and robust solution is to develop an automated process. An ETL (Extract, Transform, Load) tool can be used to extract the data, apply sophisticated matching logic to identify duplicate sets, and then use the Salesforce merge API call to programmatically merge the identified duplicates. This provides a controlled, repeatable, and auditable method for large-scale data remediation, which is essential for a cleanup of this magnitude.

Why Incorrect

B. A data warehouse is an analytical system. While it can help identify duplicates, it cannot perform the merge operation within the source Salesforce system.
C. Using Excel is not a viable solution for 2 million records due to row limits (~1 million) and the sheer impracticality of performing complex matching and merging manually.
D. Duplicate rules are primarily for preventing the creation of new duplicates and identifying existing ones. They do not provide an automated, mass-merge capability to remediate 500,000 records.

References

1. Salesforce SOAP API Developer Guide, merge(). The documentation describes the merge call, which is designed to merge up to three records of the same object type, including the master record and one or two victim records, into one. This is the programmatic tool for remediation.

2. Salesforce Help, Manage Duplicate Records. This documentation explains that duplicate jobs and reports help you find duplicates, but the merging process itself is handled separately, often record by record or via the API for bulk operations.

Scroll to Top