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?
Implementing duplicate rules (option D) is the best solution to remediate the duplication issue, as it allows the data architect to identify and merge duplicate accounts in Salesforce using native features and tools. Developing an ETL process that utilizes the merge API to merge the duplicate records (option A) is not a good solution, as it may require more coding and testing effort, and it does not prevent duplicates from being created in Salesforce. Utilizing a data warehouse as the system of truth (option B) is also not a good solution, as it may introduce additional complexity and cost, and it does not address the duplication issue in Salesforce. Extracting the data using data loader and using excel to merge the duplicate records (option C) is also not a good solution, as it may be time-consuming and error-prone, and it does not prevent duplicates from being created in Salesforce.
Gladys
1 months agoAlona
2 months agoSophia
11 days agoLorrine
27 days agoEvangelina
1 months agoCatarina
1 months agoCathern
2 months agoCaprice
21 days agoBelen
1 months agoAlline
1 months agoTy
2 months agoKerrie
2 months agoBambi
2 months agoLavelle
25 days agoAfton
1 months agoChristoper
1 months agoHoa
2 months agoLeila
2 months agoTy
2 months ago