DATA-ARCHITECT practice question 33 of 35

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce. Which solution should a data architect recommend a clean migration?

Full set: 257 questions
Answer options
A: Define external IDs for an object, migrate second database to first database, and load into Salesforce.
B: Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
C: Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce. Correct answer
D: Define external IDs for an object, Insert data from one database, and use upsert for a second database
Correct Answer:
C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
Explanation

The most robust and recommended strategy for migrating, cleaning, and merging data from multiple sources is to use an ETL (Extract, Transform, Load) process with a staging database. This intermediate environment allows data from both legacy systems to be consolidated. Within the staging database, you can perform cleansing, standardization, and deduplication logic before loading the clean, unified dataset into Salesforce. Using external IDs is crucial in this process to maintain a link to the source records and to facilitate the use of upsert operations for the final load.

Why Incorrect

A. This option is incomplete as it omits the critical steps of cleaning and deduplicating the data in a controlled environment before loading.
B. Using Salesforce duplicate rules is a reactive measure that works on data already being loaded, not a proactive cleansing step as required.
D. This approach risks creating duplicates and lacks a dedicated step for data cleansing and applying complex merge logic before the data enters Salesforce.

References

1. Salesforce Architects, Data Migration Strategies. This guide outlines best practices, including the use of a staging environment for data transformation and cleansing. It states, "A staging database... is a common approach for complex data migration projects involving data cleansing, de-duplication, and transformation."

2. Salesforce Trailhead, Large Data Volume Management, "Staging Environment for Data Cleansing". This module recommends using a staging environment to prepare data before loading it into Salesforce to ensure data quality.

Scroll to Top