Salesforce Certified Data Architect — Question 77

Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)

Answer options

• A. Redefine the master-detail relationship fields to lookup relationship fields in the target org.
• B. Use Data Loader to export the data from the source org and then import/upsert into the target org in sequential order.
• C. Keep the relationship fields populated with the source record IDs in the import file.
• D. Replace source record IDs with new record IDs from the target org in the import file.
• E. Create an external ID field for each object in the target org and map source record IDs to this field.

Correct answer: B, D, E

Explanation

The correct answer includes using Data Loader to ensure data is imported in the necessary order (B), replacing source record IDs with the new ones from the target org to maintain relationships (D), and creating external ID fields for mapping (E). Redefining master-detail relationships as lookup relationships (A) would break the existing hierarchy, and keeping source record IDs (C) would lead to incorrect associations in the new org.