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 questionsGiven 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.
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.
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.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
