SF-Data-Arch Data Migration Practice Question
When planning a large data migration, which TWO tasks are essential to perform before the data load? (Choose two)
⚠ Common exam trap
Candidates often forget to deactivate asynchronous automation like triggers and flows, leading to performance bottlenecks, governor limit exceptions, and corrupted legacy data relationships during large data loads.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Deactivate all triggers, workflow rules, and flows that could interfere with the load.
Preparing the environment by deactivating automation and establishing a clean mapping strategy are foundational steps. Deactivating automation prevents unintended side effects and performance bottlenecks during the load. A robust mapping strategy, including data cleansing and validation, ensures the migration follows business requirements. These steps minimize downtime and reduce the risk of data corruption, ensuring the system remains performant and the data remains high quality post-migration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Deactivate all triggers, workflow rules, and flows that could interfere with the load.
Why this is correct
Disabling automation is essential to prevent recursive triggers or unintended updates that degrade performance. When loading large volumes, automated processes can consume CPU and DML limits, causing the load to fail. Clearing the path allows the raw data to be inserted efficiently before re-enabling business logic later.
- ✗
Increase the Salesforce API limit for the specific migration user.
Why it's wrong here
API limits are platform-wide and cannot be increased for a single user. While you can request a temporary increase from Salesforce Support, this is not a standard task performed in every migration plan. Instead, architects should optimize the volume of requests to stay within existing platform limits.
- ✓
Establish a field mapping document that reconciles legacy data to Salesforce objects.
Why this is correct
A mapping document is critical for ensuring that source data aligns with the target schema. It tracks data types, field constraints, and business logic. Without a clear map, data integrity is easily compromised, resulting in mismatched or unusable information that requires significant time and cost to remediate.
- ✗
Delete all existing records in the environment to ensure a fresh start.
Why it's wrong here
Deleting all records is rarely appropriate, especially in environments where existing configuration data or reference objects are required for the new load. Data migration usually occurs in existing systems, requiring careful handling of existing data to avoid accidental loss or violation of business requirements for data retention.
- ✗
Enable the 'Parallelize' setting on all user profiles.
Why it's wrong here
There is no 'Parallelize' setting on Salesforce user profiles. Parallel processing is handled by the Bulk API architecture based on the mode chosen in the job configuration. This option is technically incorrect and reflects a misunderstanding of how Salesforce handles multi-threaded data processing and API request queuing.
About these practice questions
One of 222 original SF-Data-Arch practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Data-Arch practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Data-Arch exam.