Salesforce Certified Data Architect — Question 54

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.

Which solution should a data architect use to ensure successful data migrations?

Answer options

• A. Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
• B. Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
• C. Export legacy data into CSV files and leverage data loader to load data into Salesforce.
• D. Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.

Correct answer: B

Explanation

Option B is correct because using an ETL tool allows for the transformation of data types during the migration process, ensuring compatibility with Salesforce. Option A delays the process by requiring an additional staging step. Option C lacks the necessary transformation of data types, which could lead to errors. Option D also introduces unnecessary complexity with stored procedures when an ETL tool is more efficient.