Exam Certified Data Architect topic 1 question 23 discussion

The script will facilitate extract and load. But transformation is also required here.

A is correct

a correct

Options provided for Data Migration study guide are: serial load, parallel mode, defer sharing calculation, record locks, hierarchical relationship, and bulk API limits. Given this is a test on data migration, would opt for solution that is mentioned.

Not B - Bulk API is efficient for bulk data transfer, but it requires significant scripting effort, especially for data mapping and transformation in this complex scenario. A - ETL tool handles complexity, mapping, and orchestration.

Big changes to the data model means I would select A

The most accurate answer is A. Use an ETL tool to orchestrate the migration. Given the complexity of the migration (drastic changes in the data model, large volume of records, and tight timeline), an ETL (Extract, Transform, Load) tool would be the most suitable option. ETL tools are designed to handle complex data migrations, including changes in data models and large volumes of data. They also provide robust error handling and logging capabilities, which are crucial for a successful migration. B. Write a script to use the Bulk API: Writing a script to use the Bulk API could be a viable option, but it would require significant development effort and may not be feasible given the two-month timeline. Additionally, this approach would require extensive testing to ensure the accuracy of the data migration.

ETL or Batch both would require investment in development resources. However, batch would be a 'from scratch' development effort and there's only two months to complete. Using an ETL tool would greatly shorten the development time to transform and migrate the data and can be easily updated during testing.

Drastical changes in the data model let me choose A.

On reflection, B is probably more appropriate since it will requirer a one-off operation (maybe in batches), therefore, the investment in an ETL tool seems illogical unless one is already in use and, in this scenario, we cannot assume that. Therefore Batch Scripting is appropriate and will yield the required results with accuracy and reliability.

Answer A. An ETL tool provides a robust and scalable solution for data migration between Salesforce orgs, especially when dealing with large volumes of data and complex transformations. Here's why it is the recommended approach: Scalability: An ETL tool can handle large data volumes efficiently by leveraging parallel processing capabilities. With three million records to migrate, using an ETL tool can ensure optimal performance and faster data transfer.

In this scenario, considering the complexity of the data model changes, the volume of records, and the timeframe for migration, the most suitable migration strategy would be: A. Use an ETL tool to orchestrate the migration.

I think A is correct option. A Batch Script is also some kind of ETL tool. But it is developed by user/developer and therefore prone to have errors.