Salesforce Certified Data Architect — Question 46

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?

Answer options

• A. Extract the data using data loader and use excel to merge the duplicate records
• B. Utilize a data warehouse as the system of truth
• C. Develop an ETL process that utilizes the merge API to merge the duplicate records
• D. Implement duplicate rules

Correct answer: D

Explanation

Implementing duplicate rules is the most effective way to manage and prevent duplicates in Salesforce. While the other options may address some aspects of the duplication issue, they do not provide a systematic approach for ongoing management and prevention of duplicates like duplicate rules do.