Which two activities and tools should a Solution Architect recommend to address these concerns when planning the data migration activity and assure it is completed in a timely manner?

A telecommunications company is implementing Service Cloud and Experience Cloud with a goal to have a single view of their customers. Current system limitations have resulted in many duplicate and incomplete customer records with inadequate data quality in the millions of records. They want this issue remediated when migrating the data to Service Cloud and Experience Cloud.

Which two activities and tools should a Solution Architect recommend to address these concerns when planning the data migration activity and assure it is completed in a timely manner? Choose 2 answers
A . Q Duplicate Management in Salesforce can be used to identify and manage duplicate records.
B . Use an ETL tool with a staging database in order to run data cleansing tools to obtain a clean data set.
C . Iteratively test smaller loads against a developer or partial copy sandbox and the full load against a full copy sandbox.
D . Iteratively test smaller loads against a developer sandbox and the full load against a partial copy sandbox.

View Answer

Answer: B,C

Explanation:

B. An ETL (Extract, Transform, Load) tool is a software that can help extract data from multiple sources, transform it according to business rules, and load it into a target destination, such as Salesforce. An ETL tool can also help run data cleansing tools, such as deduplication, validation, standardization, and enrichment, to obtain a clean data set before migrating it to Salesforce.

C. Iteratively testing smaller loads against a developer or partial copy sandbox and the full load against a full copy sandbox can help ensure the data migration is successful and error-free. A developer or partial copy sandbox can be used for testing the data quality, mapping, and transformation rules, while a full copy sandbox can be used for testing the performance, scalability, and integrity of the data migration.

References:

https://trailhead.salesforce.com/en/content/learn/modules/data-management-basics/data-management-basics-migrate

https://help.salesforce.com/s/articleView?id=sf.data_sandbox_create.htm&type=5