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?

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.








 

Suggested Answer: B





This question is in Certified Data Architect Exam
For getting Salesforce Certified Data Architect


















Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Salesforce. 
Trademarks, certification & product names are used for reference only and belong to Salesforce.
The website does not contain actual questions and answers from Salesforce's Certification Exams.