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?
- 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