Salesforce Certified Data Architect — Question 4

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC’s main Salesforce org will be divided into two orgs: Org A and Org B. UC has delivered these requirements to its data architect:
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from Org A to Org B for compliance reasons.
3. The migration will need occur within the next two months, prior to the spilt.
Which migration strategy should a data architect use to successfully migrate the data?

Answer options

• A. Use an ETL tool to orchestrate the migration.
• B. Write a script to use the Bulk API.
• C. Use the Salesforce CLI to query, export, and import.
• D. Use Data Loader for export and Data Import Wizard for import.

Correct answer: A

Explanation

The correct answer is A because an ETL tool is designed to handle complex migrations, especially when dealing with a large volume of records and differing data models. The other options, while useful for certain types of data transfers, may not adequately manage the scale or complexity of this migration requirement.