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 questionsThe 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.
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.
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.
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
