Question 61
Choose 1
Cloud Kicks is changing its case management system to Salesforce. All active accounts,
contacts, and closed cases for the past 5 years need to be migrated to Salesforce for golive.
Which approach should a consultant use for data migration?
Which approach should a consultant use for data migration?
Correct answer:
C. Plan, Prepare, Test, Execute, Validate
Explanation:
When migrating data — especially mission-critical data like accounts, contacts, and closed cases — it’s essential to follow a structured data migration approach. Salesforce follows a best-practice methodology that ensures accuracy, data integrity, and minimal disruption.
🔍 Correct Approach Breakdown:
1. Plan
Define what data will be migrated (e.g., active accounts, closed cases from last 5 years).
Identify data sources, owners, and migration scope.
Align on tools, timeline, and success criteria.
2. Prepare
Clean and transform data (e.g., remove duplicates, standardize formats).
Map source fields to Salesforce fields.
Set up data load templates and sandbox environment.
3. Test
Perform test migrations in a sandbox or partial sandbox.
Validate data integrity, relationships, and record ownership.
Ensure that users and stakeholders sign off on test loads.
4. Execute
Perform the actual migration (production load).
Usually done during a go-live window with a rollback plan in place.
5. Validate
Post-load verification:
Data completeness
Record linking
User accessibility
Final sign-off from stakeholders.
✅ This is the Salesforce-recommended data migration flow used in real-world enterprise projects.
🔴 Why Not the Other Options?
A. Prepare, Plan, Test, Validate, Execute
Steps are out of logical sequence
Planning must come before preparation and execution
B. Plan, Prepare, Execute, Test, Validate
Testing happens after execution, which is risky
Best practice is to test before production execution to catch issues early
📚 Reference:
Salesforce Trailhead: Data Migration Strategies
Salesforce Architects Guide: Data Migration Best Practices
✅ Final Answer: C. Plan, Prepare, Test, Execute, Validate
This approach ensures that data is accurate, secure, and usable when Salesforce goes live for Cloud Kicks.
When migrating data — especially mission-critical data like accounts, contacts, and closed cases — it’s essential to follow a structured data migration approach. Salesforce follows a best-practice methodology that ensures accuracy, data integrity, and minimal disruption.
🔍 Correct Approach Breakdown:
1. Plan
Define what data will be migrated (e.g., active accounts, closed cases from last 5 years).
Identify data sources, owners, and migration scope.
Align on tools, timeline, and success criteria.
2. Prepare
Clean and transform data (e.g., remove duplicates, standardize formats).
Map source fields to Salesforce fields.
Set up data load templates and sandbox environment.
3. Test
Perform test migrations in a sandbox or partial sandbox.
Validate data integrity, relationships, and record ownership.
Ensure that users and stakeholders sign off on test loads.
4. Execute
Perform the actual migration (production load).
Usually done during a go-live window with a rollback plan in place.
5. Validate
Post-load verification:
Data completeness
Record linking
User accessibility
Final sign-off from stakeholders.
✅ This is the Salesforce-recommended data migration flow used in real-world enterprise projects.
🔴 Why Not the Other Options?
A. Prepare, Plan, Test, Validate, Execute
Steps are out of logical sequence
Planning must come before preparation and execution
B. Plan, Prepare, Execute, Test, Validate
Testing happens after execution, which is risky
Best practice is to test before production execution to catch issues early
📚 Reference:
Salesforce Trailhead: Data Migration Strategies
Salesforce Architects Guide: Data Migration Best Practices
✅ Final Answer: C. Plan, Prepare, Test, Execute, Validate
This approach ensures that data is accurate, secure, and usable when Salesforce goes live for Cloud Kicks.
