SF-Data-Arch Data Migration Practice Test 2 — 15 Questions

Question 1

A data architect is migrating 15 million records from a legacy order management system into a custom object in Salesforce. The legacy system uses a 32-character hexadecimal string as the unique record identifier. This identifier must be preserved in Salesforce for cross-system reconciliation and must support exact-match lookups in SOQL and list views. The architect needs to choose the appropriate custom field type. Which field type should be used?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Text (32) with Unique and External ID attributes enabled. The legacy identifier is a 32-character hexadecimal string requiring exact-match lookups at scale. A Text(32) field with Unique and External ID attributes enabled provides the correct storage size, enforces uniqueness, and creates the index necessary for performant SOQL and list view filtering. External ID also supports upsert, which is essential for reconciling records during migration.

Answer

Number (18, 0)

Answer

External ID (Text, 32)

Answer

Text (80)

Question 2

A data architect is planning to migrate 3 million Case records and their related Case Comments from a legacy system into Salesforce Service Cloud. The legacy system stores comments as a single text blob per Case. The architect needs to preserve the chronological order of comments and ensure they are visible in the Case feed. Which migration approach should be used?

Accepted Answer

Load Cases first, then load Case Comments using the CaseComment object via the Bulk API, setting the ParentId to the Case ID.. The CaseComment object is the standard way to store comments on a Case, and it supports chronological ordering through the CreatedDate field, which can be preserved during migration. Loading Cases first provides the necessary parent IDs for the CaseComment records. This ensures comments are visible in the Case feed and maintain their original sequence.

Answer

Load Cases, then use the FeedItem object to insert comments, setting the ParentId to the Case ID and Type to 'TextPost'.

Answer

Load Cases with a rich text field containing all comments concatenated, and use a formula to display them in the feed.

Answer

Load Cases and then use the Attachment object to store each comment as a separate text file attached to the Case.

Question 3

A healthcare provider is migrating 8 million Patient__c records from a legacy system into Salesforce. The legacy data contains 300,000 records with missing or invalid values in the required field MRN__c (Medical Record Number). The business wants to load all valid records immediately and quarantine the invalid ones for later correction without failing the entire job. The architect will use Bulk API 2.0 with a CSV source. Which approach best meets the requirement?

Accepted Answer

Split the source into two files: one containing only records with valid MRN__c values, and another containing the invalid records. Load the valid file normally; store the invalid file for later correction.. Pre-splitting the source into valid and invalid subsets is the most controlled approach. It ensures valid records are loaded without interruption while invalid records are isolated for remediation. This avoids the overhead of parsing error logs and prevents partial failures from affecting the overall migration timeline.

Answer

Load all records and rely on Salesforce validation rules to reject invalid MRN__c values; then query the error log to reprocess failures.

Answer

Use Data Loader with the 'Allow Field Truncation' option and set MRN__c to a default placeholder value for missing entries.

Answer

Enable AllOrNone and load all records in a single batch so that invalid records cause a full rollback.

Question 4

A Salesforce architect is migrating 10 million Opportunity records from a legacy system. The legacy data contains Opportunities with close dates ranging from 2000 to 2020. The architect needs to ensure that after migration, these historical Opportunities do not trigger any existing workflow rules, process builders, or Apex triggers that could send emails or update related records. Which approach should the architect take during the migration?

Accepted Answer

Temporarily deactivate all workflow rules, process builders, and Apex triggers on the Opportunity object before the migration, then reactivate them afterward.. To prevent automation from firing on historical Opportunities, the architect should temporarily deactivate workflow rules, process builders, and Apex triggers on the Opportunity object before the load. This ensures no emails are sent or unintended updates occur. After the migration, reactivating automation restores normal business processes without affecting the migrated data.

Answer

Load the Opportunities with a future close date and then update them to the historical dates in a second pass, so automation only fires on the update.

Answer

Use the Bulk API with the 'Serial' mode and set the batch size to 1 to process records individually and bypass automation.

Answer

Use the Data Loader's 'Bulk API' option with the 'Allow Field Truncation' setting enabled to skip automation.

Question 5

An architect is planning a data migration for a Salesforce org that has a complex data model with many lookup and master-detail relationships. The migration will be performed using Bulk API 2.0. Which TWO considerations are critical to ensure successful loading of related records? (Choose two.)

Accepted Answer

Load parent records before child records to satisfy referential integrity constraints.. Loading parent records before child records ensures that referential integrity constraints are met. Using external ID fields on parent objects allows child records to reference parents by their external IDs, which Salesforce resolves during load. This eliminates the need for post-load ID mapping and is essential when using Bulk API 2.0, as it does not support complex relationship mapping. Together, these two practices ensure successful loading of related records.

Answer

Set the Bulk API 2.0 job to use parallel processing mode to increase throughput.

Answer

Disable all validation rules and triggers on the objects being loaded to improve performance.

Answer

Ensure that all lookup relationships are optional (not required) to avoid load failures.

Question 6

A data architect is migrating 20 million records into a custom object 'Invoice__c' in Salesforce. The legacy data contains lookup relationships to Account and Contact. The architect needs to ensure the migration is efficient and avoids data skew that could impact performance. Which two actions should the architect take? (Choose two.)

Accepted Answer

Ensure that the Account and Contact records are loaded before the Invoice records to establish parent references.. Loading parent records before children ensures referential integrity, and partitioning child records by parent reduces lock contention during parallel loads. These two actions directly mitigate the risk of data skew and performance degradation when migrating records with lookup relationships. The other options either misidentify the type of skew or could exacerbate locking issues.

Answer

Create a unique index on the Invoice__c external ID field to improve upsert performance.

Answer

Use the Bulk API in parallel mode to maximize throughput for the Invoice records.

Answer

Distribute the records across multiple parent Accounts and Contacts to avoid ownership skew.

Question 7

A data architect is planning to migrate 10 million Contact records into Salesforce. The legacy data contains duplicate Contacts based on email address. The architect must ensure that duplicates are prevented during the migration and that existing Contacts in Salesforce are not duplicated. Which two actions should be taken before the data load? (Choose two.)

Accepted Answer

Enable Duplicate Rules on the Contact object for the Email field and set the action to Block.. To prevent duplicates during a 10 million Contact migration, the architect should enable Duplicate Rules with a Block action on the Email field and also deduplicate the legacy data using an ETL tool. The Duplicate Rules prevent records that match existing Salesforce Contacts, while ETL deduplication reduces intra-batch duplicates and improves performance. Both actions are necessary for a robust migration.

Answer

Disable all Duplicate Rules and rely on the ETL tool to handle deduplication.

Answer

Create a custom unique field on Contact for Email and enforce uniqueness at the database level.

Answer

Set the Contact object's External ID field to Email and use upsert to update existing records.

Question 8

During a large data migration, a developer notices that existing Apex triggers are causing severe performance degradation. What is the most effective way to prevent trigger execution without deleting the code?

Accepted Answer

Use a Custom Setting to control trigger execution.. The most effective method to mitigate trigger-related performance issues during high-volume loads is to implement a 'Bypass' or 'Switch' pattern using Custom Settings or Custom Metadata. By checking this flag at the start of the trigger, logic can be conditionally skipped. This preserves code integrity while allowing the migration to proceed at maximum speed without the overhead of complex validation or automated process logic.

Answer

Comment out the trigger logic and redeploy the code.

Answer

Disable the triggers in the Setup menu under 'Manage Triggers'.

Answer

Remove user permissions for the integration user.

Question 9

Which of the following is the most important factor when choosing between the Bulk API 2.0 and the SOAP API for a large data migration?

Accepted Answer

The total number of records to be migrated.. The primary factor is the volume of data being moved. Bulk API 2.0 is designed specifically for large datasets (hundreds of thousands to millions of records) and operates asynchronously, reducing the likelihood of request timeouts. The SOAP API, while powerful for real-time transactional operations, is synchronous and poorly suited for large-scale data migrations due to its overhead and batch limitations.

Answer

The use of OAuth authentication protocols.

Answer

The requirement to process records synchronously.

Answer

The availability of a command-line interface.

Question 10

Which TWO steps are critical when preparing to migrate sensitive PII (Personally Identifiable Information) into Salesforce?

Accepted Answer

Perform data masking on source datasets for sandboxes.. When migrating PII, Data Architects must prioritize compliance and data protection. Data masking ensures that non-production environments do not contain real sensitive data, while Field-Level Security (FLS) ensures that only authorized users can access the data within production. These steps are essential to maintaining regulatory compliance, such as GDPR or HIPAA, throughout the lifecycle of the data migration project.

Answer

Use the Bulk API for all PII data transfers.

Answer

Delete all audit logs after the migration is complete.

Answer

Export all PII to unencrypted CSV files for mapping.

Question 11

Refer to the exhibit. Why might 'Parallel' concurrency mode cause errors during a large migration?

Accepted Answer

It leads to record locking contention on parent objects.. Refer to the exhibit. The JSON configuration shows a Bulk API 2.0 job using 'Parallel' concurrency mode. The Data Architect must be aware that parallel processing increases the risk of record locking when parent records have many children being processed simultaneously. This configuration requires careful monitoring of record contention to prevent failures, even though it provides the fastest throughput for independent records.

Answer

It causes the API to exceed the daily limit for API calls.

Answer

It prevents the data from being loaded in a specific order.

Answer

It forces the data to be processed in a single thread.

Question 12

Which THREE factors are essential to consider when performing a multi-org data migration consolidation?

Accepted Answer

Handling duplicate record IDs across source orgs.. Consolidating multiple Salesforce orgs requires meticulous planning around unique ID collisions, metadata differences (such as custom field mapping), and security model alignment. Since each org has its own unique record IDs and potentially overlapping data, an intermediary mapping strategy is vital to ensure that relationships are preserved correctly in the new, unified environment without creating duplicate records or data conflicts.

Answer

Enabling the 'Set Audit Fields' for every user.

Answer

Using only the standard Import Wizard for migrations.

Question 13

Which object must be loaded first in a standard Salesforce migration involving Accounts, Contacts, and Opportunities?

Accepted Answer

Accounts, to establish the parent records for children.. Accounts must be loaded first because they are the parent objects for both Contacts and Opportunities in the standard data model. Without the Account records present, the foreign key lookups for Contacts and Opportunities will fail, as they have no valid parent ID to link to. Establishing the hierarchy is the fundamental requirement for data referential integrity.

Answer

Opportunities, because they drive revenue reporting.

Answer

Contacts, to ensure the primary contact is defined.

Answer

It does not matter if you use the Bulk API.

Question 14

A company needs to migrate data into a custom object while maintaining the original CreatedDate from a legacy system. Which of the following is required?

Accepted Answer

Enable 'Set Audit Fields upon Record Creation' permission.. Maintaining the original CreatedDate requires the 'Set Audit Fields upon Record Creation' user permission. Without this, Salesforce ignores the provided CreatedDate and assigns the current server time upon insertion. This permission is a highly sensitive setting and must be enabled specifically for the integration user through the user record or the appropriate permission set, ensuring audit traceability for historical records.

Answer

A custom Apex trigger to overwrite the CreatedDate field.

Answer

Use the Salesforce Import Wizard with mapped headers.

Answer

Create a formula field to store the legacy date.

Question 15

What is the primary benefit of using a staging database for data migration?

Accepted Answer

It allows for complex data transformation and cleansing.. A staging database provides a clean, neutral environment to perform ETL (Extract, Transform, Load) tasks such as data deduplication, value normalization, and relationship mapping. By transforming the data outside of Salesforce, architects ensure that only clean, verified data enters the target environment. This minimizes the risk of system-level errors and validation failures that occur when attempting to manipulate raw, messy data directly inside the Salesforce platform.

Answer

It provides a backup of the source data.

Answer

It eliminates the need for field mapping documentation.

Answer

It speeds up the actual data insertion into Salesforce.