SF-Data-Arch Data Migration — All Questions With Answers

Question 1hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. A data migration is failing on Account upserts using an external ID field. What is the most likely cause of this error?

Exhibit

Error: 'DUPLICATE_VALUE: duplicate value found: Name duplicates value on record with id: 001xx000003YyZz'

Question 2mediummultiple choice

Read the full Data Migration explanation →

A company is migrating data from a legacy SQL database to Salesforce. They need to map complex relationships between Accounts, Contacts, and custom 'Projects'. What is the recommended strategy for handling foreign keys during migration?

Question 3hardmulti select

Read the full Data Migration explanation →

Which THREE activities are standard for the 'Post-Migration' phase of a project?

Question 4mediummultiple choice

Read the full Data Migration explanation →

A company is migrating 50 million records into Salesforce. To maintain data integrity, they must ensure that external IDs are utilized correctly. What is the primary advantage of using External IDs during the data migration process?

Question 5hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. A data architect is performing a bulk migration of Accounts and related Contacts. During the migration, the team encounters the specified error. What should the architect do to resolve this issue?

Exhibit

Error: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: 001D000000XXXXX

Question 6mediummultiple choice

Read the full Data Migration explanation →

An organization is planning a migration from a legacy CRM to Salesforce. The data volume is 10 million records. Which strategy should be used to minimize the risk of hitting Salesforce governor limits?

Question 7hardmulti select

Read the full Data Migration explanation →

A data architect is preparing to migrate millions of records into a new Salesforce Org. Which THREE actions should be taken prior to the migration to ensure success?

Question 8hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. The architect is configuring a bulk load operation. Given the JSON configuration shown, what is the risk of using 'Parallel' serial mode?

Exhibit

JSON config: {"operation": "upsert", "externalId": "Legacy_ID__c", "serialMode": "Parallel"}

Question 9hardmultiple choice

Read the full Data Migration explanation →

A company is migrating attachments from a legacy system into Salesforce. Due to the high volume, what is the recommended architecture?

Question 10mediummultiple choice

Read the full Data Migration explanation →

During a data migration project, a requirement emerges to map legacy IDs to a new Salesforce field for audit purposes. Which field type should be selected for the 'Legacy_ID__c' field?

Question 11mediummulti select

Read the full Data Migration explanation →

When migrating user data, which TWO items must be handled differently compared to standard object migration?

Question 12mediummultiple choice

Read the full Data Migration explanation →

An architect is planning a data migration and needs to ensure that historical data does not trigger automated workflow rules or email alerts. How can this be achieved?

Question 13mediummultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is migrating 2 million Account records from a legacy CRM. The legacy system uses a 15-character alphanumeric Account Number as the unique identifier. The architect needs to preserve this identifier in Salesforce for integration with an external ERP system. Which field type should be used for the Account Number field in Salesforce?

Question 14mediummultiple choice

Read the full Data Migration explanation →

A financial services company is migrating 12 million legacy transaction records into a custom object Transaction__c. The records must be loaded during a weekend maintenance window, and the business requires that if any record fails validation, the entire batch of 200 records should be rolled back so that partial data is never committed. The architect plans to use the Bulk API 2.0. Which setting should be configured to meet the all-or-nothing requirement per batch?

Question 15hardmulti select

Read the full Data Migration explanation →

A data architect is planning to migrate 5 million Contact records from a legacy system into Salesforce Sales Cloud. The legacy data contains duplicate Contacts based on Email address, and the business wants to prevent duplicates in Salesforce. The architect must also ensure that the migration does not trigger existing Apex triggers and validation rules. Which two actions should the architect take before loading the data? (Choose two.)

Question 16mediummultiple choice

Read the full Data Migration explanation →

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?

Question 17mediummultiple choice

Read the full Data Migration explanation →

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?

Question 18hardmultiple choice

Read the full Data Migration explanation →

A healthcare provider is migrating 8 million Patientc records from a legacy system into Salesforce. The legacy data contains 300,000 records with missing or invalid values in the required field MRNc (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?

Question 19hardmultiple choice

Read the full Data Migration explanation →

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?

Question 20hardmulti select

Read the full Data Migration explanation →

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.)

Question 21hardmulti select

Read the full Data Migration explanation →

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.)

Question 22mediummulti select

Read the full Data Migration explanation →

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.)

Question 23hardmultiple choice

Read the full Data Migration explanation →

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?

Question 24mediummultiple choice

Read the full Data Migration explanation →

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?

Question 25mediummulti select

Read the full Data Migration explanation →

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

Question 26hardmultiple choice

Read the full Data Migration explanation →

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

Exhibit

{
  "operation": "insert",
  "object": "Account",
  "concurrencyMode": "Parallel",
  "contentType": "CSV"
}

Question 27hardmulti select

Read the full Data Migration explanation →

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

Question 28mediummultiple choice

Read the full Data Migration explanation →

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

Question 29hardmultiple choice

Read the full Data Migration explanation →

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?

Question 30mediummultiple choice

Read the full Data Migration explanation →

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

Question 31mediummultiple choice

Read the full Data Migration explanation →

What is the main advantage of using an ETL tool rather than the standard Salesforce Data Loader for a large-scale enterprise migration?

Question 32mediummultiple choice

Read the full Data Migration explanation →

During a migration, you discover that the source system has a different date format than the required ISO 8601 format for Salesforce. What is the most efficient way to handle this?

Question 33mediummulti select

Read the full Data Migration explanation →

When migrating data to Salesforce, which TWO strategies help ensure successful relationship mapping between parent and child objects?

Question 34mediummultiple choice

Read the full Data Migration explanation →

You are migrating records that contain multi-select picklist values. What is the key consideration for mapping this data from a legacy system?

Question 35easymultiple choice

Read the full Data Migration explanation →

What is the primary benefit of performing a data cleansing exercise before initiating a migration to Salesforce?

Question 36hardmultiple choice

Read the full Data Migration explanation →

During a migration, you encounter an error stating that the record exceeds the maximum character limit for a field. What is the most robust way to handle this?

Question 37mediummultiple choice

Read the full Data Migration explanation →

A data architect is migrating 50 million records into a custom object. To ensure optimal performance and avoid hitting governor limits, which strategy should be implemented during the initial data load?

Question 38mediummultiple choice

Read the full Data Migration explanation →

A company is migrating legacy account data into Salesforce. They need to map legacy system primary keys to a new custom field to support future integrations. What is the recommended approach to ensure this field supports efficient data retrieval?

Question 39hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. During a high-volume migration, the team encounters the provided error frequently. What is the most likely cause?

Exhibit

Error: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: [001xx000003GYaA, ...]

Question 40mediummulti select

Read the full Data Migration explanation →

When planning a large data migration, which TWO tasks are essential to perform before the data load? (Choose two)

Question 41hardmultiple choice

Read the full Data Migration explanation →

A healthcare provider is migrating 8 million legacy Patient_Visitc records into Salesforce. Each visit references a legacy numeric provider code, and the legacy system does not expose a stable unique identifier for each provider. The Salesforce Providerc object already has a custom external ID field named Legacy_Provider_Code__c that is populated. The architect wants to load visits without first exporting provider Salesforce IDs. Which approach should be used?

Question 42easymultiple choice

Read the full Data Migration explanation →

A data architect is migrating 4 million legacy Customer__c records into Salesforce using the Bulk API. The source system exports a CSV with a column 'Legacy_Idc' that must remain unique and searchable for downstream integrations. After the initial load, the architect notices duplicate Customerc records were created because the External ID field was not marked as unique. Which Salesforce field configuration should have been applied to Legacy_Id__c to prevent duplicates during upsert?

Question 43mediummultiple choice

Read the full Data Migration explanation →

A data architect is migrating 8 million Contact records from a legacy CRM into Salesforce Sales Cloud. The legacy system stores phone numbers as free-text strings in multiple formats (e.g., '(415) 555-1212', '415.555.1212', '4155551212'). After migration, users must be able to search for Contacts by phone number and have the numbers display consistently. Which approach should the architect use to ensure phone numbers are searchable and standardized?

Question 44hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 12 million Opportunity records into a new Salesforce org. The legacy system uses a custom 'Opportunity_Key__c' that must be populated for integration purposes. During a test load using the Bulk API in parallel mode, the team observes that some records fail with 'UNABLE_TO_LOCK_ROW' errors. What is the most likely cause of these errors?

Question 45mediummultiple choice

Read the full Data Migration explanation →

A Salesforce architect is migrating 2 million legacy Contact records into a new Salesforce org. The legacy system does not have email addresses for 40% of the contacts, but Salesforce's standard Email field is not required. During a test load of 10,000 records using the Bulk API in serial mode, the load succeeds but the architect notices that duplicate contacts are being created because the legacy system reused a 'legacy_id__c' external ID field for different contacts across regions. What should the architect do to prevent duplicate creation during the full migration?

Question 46mediummultiple choice

Read the full Data Migration explanation →

A healthcare company is migrating 4 million Patient__c records from a legacy system into Salesforce. The legacy extract includes a field named 'last_modified' that is populated for 99.8% of records, but the remaining 0.2% have a null value. The target external ID field requires a unique, non-null value. What should the data architect do to ensure a successful migration?

Question 47hardmultiple choice

Read the full Data Migration explanation →

A financial services company is migrating 5 million Account records from a legacy CRM to Salesforce. The legacy system has a field 'AnnualRevenue' stored as a string with currency symbols and commas (e.g., '$1,234,567.89'). The target Salesforce field is a Currency field with 2 decimal places. During a test load of 100,000 records using the Bulk API, the architect receives errors indicating 'Invalid currency format'. What is the most efficient way to resolve this before the full migration?

Question 48hardmultiple choice

Read the full Data Migration explanation →

A financial services firm is migrating 10 million transaction records into a custom object Transaction__c. The legacy system uses a composite key of AccountNumber and TransactionDate to uniquely identify transactions. The target Salesforce org has a unique external ID field Transaction_Key__c. The architect needs to ensure that re-running the migration does not create duplicate records and that updates to existing transactions are applied. Which approach should be used?

Question 49mediummultiple choice

Read the full Data Migration explanation →

A Salesforce architect is migrating 1 million Case records with related Case Comments from a legacy system. The legacy system stores comments in a separate table linked by a legacy Case ID. The architect plans to use the Bulk API to load Cases first, then load Case Comments in a second pass. During the test, the architect realizes that the legacy Case ID is not stored in Salesforce after the first load, making it impossible to link comments to the correct Cases. What should the architect have done to enable this relationship?

Question 50mediummultiple choice

Read the full Data Migration explanation →

A multinational corporation is migrating 2 million Account records and 5 million Contact records from a legacy CRM into Salesforce. The legacy system stores the Account's legacy ID on the Contact record as a foreign key. The target Salesforce org uses an external ID field on Account called Legacy_ID__c. What is the most efficient way to associate Contacts with their Accounts during the migration?

Question 51easymultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is migrating 100,000 Opportunity records from a legacy system. The legacy data includes a custom field 'Legacy_Regionc' that must be mapped to a new picklist field 'Regionc' in Salesforce. The picklist values in Salesforce are: 'North America', 'Europe', 'Asia', 'Latin America'. The legacy data uses values like 'NA', 'EU', 'APAC', 'LATAM'. What is the most efficient way to transform the data during migration?

Question 52easymultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is preparing to migrate 5 million Account records from a legacy CRM. The legacy system has a field 'Legacy_Owner__c' that contains the email address of the account owner. During migration, the architect must ensure that the ownership is assigned to the correct active Salesforce User. Which approach should be used to map the legacy owner email to the Salesforce User ID?

Question 53easymultiple choice

Read the full Data Migration explanation →

A data architect needs to migrate 500,000 Account records from a legacy system into Salesforce. The legacy system uses a 15-digit alphanumeric string as the unique identifier. The architect must ensure that future updates can match existing Accounts without creating duplicates. Which field configuration should be used on the Account object to support this requirement?

Question 54hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 10 million Case records and their related Case Comments from a legacy system to Salesforce Service Cloud. The legacy system stores Case Comments in a separate table with a foreign key to the Case. The architect plans to use Bulk API 2.0 for the migration. What is the most critical consideration for maintaining referential integrity between Cases and Case Comments during the load?

Question 55hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 20 million Case records from a legacy system into Salesforce. The legacy system has a 'Case_Status__c' field that must map to the standard Case Status picklist. The legacy values include 'Open', 'Closed', 'Escalated', 'Pending', and 'Resolved'. The Salesforce Case Status picklist contains 'New', 'Working', 'Escalated', 'Closed', and 'Pending'. The architect needs to ensure that the migration does not fail due to picklist value mismatches. Which approach should be taken?

Question 56mediummulti select

Read the full Data Migration explanation →

A data architect is preparing to migrate 20 million Opportunity records from a legacy CRM into Salesforce. The source data includes Opportunities with related OpportunityLineItem records and historical StageName values. The architect must ensure that the migration preserves data integrity and avoids common Bulk API pitfalls. Which TWO actions should the architect take before initiating the load? (Choose two.)

Question 57mediummulti select

Read the full Data Migration explanation →

A Salesforce architect is planning a migration of 2 million custom object records from a legacy Oracle database. The legacy system has a field 'Status' with values like 'Active', 'Inactive', 'Pending', and 'Archived'. In Salesforce, the Status field is a picklist with values 'Active', 'Inactive', and 'Pending' only. The architect needs to migrate the data while preserving as much information as possible and ensuring data quality. Which two actions should the architect take? (Choose two.)

Question 58mediummultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is migrating 500,000 Lead records from a legacy system. The legacy data contains a field 'Lead_Status' with values such as 'New', 'Working', 'Qualified', 'Unqualified'. Salesforce's Lead Status picklist has values: 'Open - Not Contacted', 'Working - Contacted', 'Closed - Converted', 'Closed - Not Converted'. The architect needs to map the legacy values to the Salesforce picklist values. Which approach should be used to ensure a successful migration?

Question 59easymultiple choice

Read the full Data Migration explanation →

A data architect is migrating 500,000 records into a custom object that has a validation rule requiring the 'Statusc' field to be either 'Active' or 'Inactive'. The legacy data contains some records with a blank Statusc. The architect needs to ensure the migration succeeds without modifying the validation rule. What should be done?

Question 60hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 30 million Opportunity records into Salesforce. The legacy system has a 'Close_Date__c' field that is a date, but some records have invalid dates such as '0000-00-00' or future dates beyond 2099. The Salesforce Opportunity Close Date field is a standard Date field. The architect must ensure the migration does not fail due to these invalid dates. Which approach should be used?

Question 1hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. A data migration is failing on Account upserts using an external ID field. What is the most likely cause of this error?

Exhibit

Error: 'DUPLICATE_VALUE: duplicate value found: Name duplicates value on record with id: 001xx000003YyZz'

Question 2mediummultiple choice

Read the full Data Migration explanation →

A company is migrating data from a legacy SQL database to Salesforce. They need to map complex relationships between Accounts, Contacts, and custom 'Projects'. What is the recommended strategy for handling foreign keys during migration?

Question 3hardmulti select

Read the full Data Migration explanation →

Which THREE activities are standard for the 'Post-Migration' phase of a project?

Question 4mediummultiple choice

Read the full Data Migration explanation →

A company is migrating 50 million records into Salesforce. To maintain data integrity, they must ensure that external IDs are utilized correctly. What is the primary advantage of using External IDs during the data migration process?

Question 5hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. A data architect is performing a bulk migration of Accounts and related Contacts. During the migration, the team encounters the specified error. What should the architect do to resolve this issue?

Exhibit

Error: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: 001D000000XXXXX

Question 6mediummultiple choice

Read the full Data Migration explanation →

An organization is planning a migration from a legacy CRM to Salesforce. The data volume is 10 million records. Which strategy should be used to minimize the risk of hitting Salesforce governor limits?

Question 7hardmulti select

Read the full Data Migration explanation →

A data architect is preparing to migrate millions of records into a new Salesforce Org. Which THREE actions should be taken prior to the migration to ensure success?

Question 8hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. The architect is configuring a bulk load operation. Given the JSON configuration shown, what is the risk of using 'Parallel' serial mode?

Exhibit

JSON config: {"operation": "upsert", "externalId": "Legacy_ID__c", "serialMode": "Parallel"}

Question 9hardmultiple choice

Read the full Data Migration explanation →

A company is migrating attachments from a legacy system into Salesforce. Due to the high volume, what is the recommended architecture?

Question 10mediummultiple choice

Read the full Data Migration explanation →

During a data migration project, a requirement emerges to map legacy IDs to a new Salesforce field for audit purposes. Which field type should be selected for the 'Legacy_ID__c' field?

Question 11mediummulti select

Read the full Data Migration explanation →

When migrating user data, which TWO items must be handled differently compared to standard object migration?

Question 12mediummultiple choice

Read the full Data Migration explanation →

An architect is planning a data migration and needs to ensure that historical data does not trigger automated workflow rules or email alerts. How can this be achieved?

Question 13mediummultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is migrating 2 million Account records from a legacy CRM. The legacy system uses a 15-character alphanumeric Account Number as the unique identifier. The architect needs to preserve this identifier in Salesforce for integration with an external ERP system. Which field type should be used for the Account Number field in Salesforce?

Question 14mediummultiple choice

Read the full Data Migration explanation →

A financial services company is migrating 12 million legacy transaction records into a custom object Transaction__c. The records must be loaded during a weekend maintenance window, and the business requires that if any record fails validation, the entire batch of 200 records should be rolled back so that partial data is never committed. The architect plans to use the Bulk API 2.0. Which setting should be configured to meet the all-or-nothing requirement per batch?

Question 15hardmulti select

Read the full Data Migration explanation →

A data architect is planning to migrate 5 million Contact records from a legacy system into Salesforce Sales Cloud. The legacy data contains duplicate Contacts based on Email address, and the business wants to prevent duplicates in Salesforce. The architect must also ensure that the migration does not trigger existing Apex triggers and validation rules. Which two actions should the architect take before loading the data? (Choose two.)

Question 16mediummultiple choice

Read the full Data Migration explanation →

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?

Question 17mediummultiple choice

Read the full Data Migration explanation →

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?

Question 18hardmultiple choice

Read the full Data Migration explanation →

A healthcare provider is migrating 8 million Patientc records from a legacy system into Salesforce. The legacy data contains 300,000 records with missing or invalid values in the required field MRNc (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?

Question 19hardmultiple choice

Read the full Data Migration explanation →

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?

Question 20hardmulti select

Read the full Data Migration explanation →

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.)

Question 21hardmulti select

Read the full Data Migration explanation →

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.)

Question 22mediummulti select

Read the full Data Migration explanation →

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.)

Question 23hardmultiple choice

Read the full Data Migration explanation →

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?

Question 24mediummultiple choice

Read the full Data Migration explanation →

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?

Question 25mediummulti select

Read the full Data Migration explanation →

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

Question 26hardmultiple choice

Read the full Data Migration explanation →

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

Exhibit

{
  "operation": "insert",
  "object": "Account",
  "concurrencyMode": "Parallel",
  "contentType": "CSV"
}

Question 27hardmulti select

Read the full Data Migration explanation →

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

Question 28mediummultiple choice

Read the full Data Migration explanation →

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

Question 29hardmultiple choice

Read the full Data Migration explanation →

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?

Question 30mediummultiple choice

Read the full Data Migration explanation →

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

Question 31mediummultiple choice

Read the full Data Migration explanation →

What is the main advantage of using an ETL tool rather than the standard Salesforce Data Loader for a large-scale enterprise migration?

Question 32mediummultiple choice

Read the full Data Migration explanation →

During a migration, you discover that the source system has a different date format than the required ISO 8601 format for Salesforce. What is the most efficient way to handle this?

Question 33mediummulti select

Read the full Data Migration explanation →

When migrating data to Salesforce, which TWO strategies help ensure successful relationship mapping between parent and child objects?

Question 34mediummultiple choice

Read the full Data Migration explanation →

You are migrating records that contain multi-select picklist values. What is the key consideration for mapping this data from a legacy system?

Question 35easymultiple choice

Read the full Data Migration explanation →

What is the primary benefit of performing a data cleansing exercise before initiating a migration to Salesforce?

Question 36hardmultiple choice

Read the full Data Migration explanation →

During a migration, you encounter an error stating that the record exceeds the maximum character limit for a field. What is the most robust way to handle this?

Question 37mediummultiple choice

Read the full Data Migration explanation →

A data architect is migrating 50 million records into a custom object. To ensure optimal performance and avoid hitting governor limits, which strategy should be implemented during the initial data load?

Question 38mediummultiple choice

Read the full Data Migration explanation →

A company is migrating legacy account data into Salesforce. They need to map legacy system primary keys to a new custom field to support future integrations. What is the recommended approach to ensure this field supports efficient data retrieval?

Question 39hardmultiple choice

Read the full Data Migration explanation →

Refer to the exhibit. During a high-volume migration, the team encounters the provided error frequently. What is the most likely cause?

Exhibit

Error: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record or 1 records: [001xx000003GYaA, ...]

Question 40mediummulti select

Read the full Data Migration explanation →

When planning a large data migration, which TWO tasks are essential to perform before the data load? (Choose two)

Question 41hardmultiple choice

Read the full Data Migration explanation →

A healthcare provider is migrating 8 million legacy Patient_Visitc records into Salesforce. Each visit references a legacy numeric provider code, and the legacy system does not expose a stable unique identifier for each provider. The Salesforce Providerc object already has a custom external ID field named Legacy_Provider_Code__c that is populated. The architect wants to load visits without first exporting provider Salesforce IDs. Which approach should be used?

Question 42easymultiple choice

Read the full Data Migration explanation →

A data architect is migrating 4 million legacy Customer__c records into Salesforce using the Bulk API. The source system exports a CSV with a column 'Legacy_Idc' that must remain unique and searchable for downstream integrations. After the initial load, the architect notices duplicate Customerc records were created because the External ID field was not marked as unique. Which Salesforce field configuration should have been applied to Legacy_Id__c to prevent duplicates during upsert?

Question 43mediummultiple choice

Read the full Data Migration explanation →

A data architect is migrating 8 million Contact records from a legacy CRM into Salesforce Sales Cloud. The legacy system stores phone numbers as free-text strings in multiple formats (e.g., '(415) 555-1212', '415.555.1212', '4155551212'). After migration, users must be able to search for Contacts by phone number and have the numbers display consistently. Which approach should the architect use to ensure phone numbers are searchable and standardized?

Question 44hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 12 million Opportunity records into a new Salesforce org. The legacy system uses a custom 'Opportunity_Key__c' that must be populated for integration purposes. During a test load using the Bulk API in parallel mode, the team observes that some records fail with 'UNABLE_TO_LOCK_ROW' errors. What is the most likely cause of these errors?

Question 45mediummultiple choice

Read the full Data Migration explanation →

A Salesforce architect is migrating 2 million legacy Contact records into a new Salesforce org. The legacy system does not have email addresses for 40% of the contacts, but Salesforce's standard Email field is not required. During a test load of 10,000 records using the Bulk API in serial mode, the load succeeds but the architect notices that duplicate contacts are being created because the legacy system reused a 'legacy_id__c' external ID field for different contacts across regions. What should the architect do to prevent duplicate creation during the full migration?

Question 46mediummultiple choice

Read the full Data Migration explanation →

A healthcare company is migrating 4 million Patient__c records from a legacy system into Salesforce. The legacy extract includes a field named 'last_modified' that is populated for 99.8% of records, but the remaining 0.2% have a null value. The target external ID field requires a unique, non-null value. What should the data architect do to ensure a successful migration?

Question 47hardmultiple choice

Read the full Data Migration explanation →

A financial services company is migrating 5 million Account records from a legacy CRM to Salesforce. The legacy system has a field 'AnnualRevenue' stored as a string with currency symbols and commas (e.g., '$1,234,567.89'). The target Salesforce field is a Currency field with 2 decimal places. During a test load of 100,000 records using the Bulk API, the architect receives errors indicating 'Invalid currency format'. What is the most efficient way to resolve this before the full migration?

Question 48hardmultiple choice

Read the full Data Migration explanation →

A financial services firm is migrating 10 million transaction records into a custom object Transaction__c. The legacy system uses a composite key of AccountNumber and TransactionDate to uniquely identify transactions. The target Salesforce org has a unique external ID field Transaction_Key__c. The architect needs to ensure that re-running the migration does not create duplicate records and that updates to existing transactions are applied. Which approach should be used?

Question 49mediummultiple choice

Read the full Data Migration explanation →

A Salesforce architect is migrating 1 million Case records with related Case Comments from a legacy system. The legacy system stores comments in a separate table linked by a legacy Case ID. The architect plans to use the Bulk API to load Cases first, then load Case Comments in a second pass. During the test, the architect realizes that the legacy Case ID is not stored in Salesforce after the first load, making it impossible to link comments to the correct Cases. What should the architect have done to enable this relationship?

Question 50mediummultiple choice

Read the full Data Migration explanation →

A multinational corporation is migrating 2 million Account records and 5 million Contact records from a legacy CRM into Salesforce. The legacy system stores the Account's legacy ID on the Contact record as a foreign key. The target Salesforce org uses an external ID field on Account called Legacy_ID__c. What is the most efficient way to associate Contacts with their Accounts during the migration?

Question 51easymultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is migrating 100,000 Opportunity records from a legacy system. The legacy data includes a custom field 'Legacy_Regionc' that must be mapped to a new picklist field 'Regionc' in Salesforce. The picklist values in Salesforce are: 'North America', 'Europe', 'Asia', 'Latin America'. The legacy data uses values like 'NA', 'EU', 'APAC', 'LATAM'. What is the most efficient way to transform the data during migration?

Question 52easymultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is preparing to migrate 5 million Account records from a legacy CRM. The legacy system has a field 'Legacy_Owner__c' that contains the email address of the account owner. During migration, the architect must ensure that the ownership is assigned to the correct active Salesforce User. Which approach should be used to map the legacy owner email to the Salesforce User ID?

Question 53easymultiple choice

Read the full Data Migration explanation →

A data architect needs to migrate 500,000 Account records from a legacy system into Salesforce. The legacy system uses a 15-digit alphanumeric string as the unique identifier. The architect must ensure that future updates can match existing Accounts without creating duplicates. Which field configuration should be used on the Account object to support this requirement?

Question 54hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 10 million Case records and their related Case Comments from a legacy system to Salesforce Service Cloud. The legacy system stores Case Comments in a separate table with a foreign key to the Case. The architect plans to use Bulk API 2.0 for the migration. What is the most critical consideration for maintaining referential integrity between Cases and Case Comments during the load?

Question 55hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 20 million Case records from a legacy system into Salesforce. The legacy system has a 'Case_Status__c' field that must map to the standard Case Status picklist. The legacy values include 'Open', 'Closed', 'Escalated', 'Pending', and 'Resolved'. The Salesforce Case Status picklist contains 'New', 'Working', 'Escalated', 'Closed', and 'Pending'. The architect needs to ensure that the migration does not fail due to picklist value mismatches. Which approach should be taken?

Question 56mediummulti select

Read the full Data Migration explanation →

A data architect is preparing to migrate 20 million Opportunity records from a legacy CRM into Salesforce. The source data includes Opportunities with related OpportunityLineItem records and historical StageName values. The architect must ensure that the migration preserves data integrity and avoids common Bulk API pitfalls. Which TWO actions should the architect take before initiating the load? (Choose two.)

Question 57mediummulti select

Read the full Data Migration explanation →

A Salesforce architect is planning a migration of 2 million custom object records from a legacy Oracle database. The legacy system has a field 'Status' with values like 'Active', 'Inactive', 'Pending', and 'Archived'. In Salesforce, the Status field is a picklist with values 'Active', 'Inactive', and 'Pending' only. The architect needs to migrate the data while preserving as much information as possible and ensuring data quality. Which two actions should the architect take? (Choose two.)

Question 58mediummultiple choice

Read the full Data Migration explanation →

A Salesforce data architect is migrating 500,000 Lead records from a legacy system. The legacy data contains a field 'Lead_Status' with values such as 'New', 'Working', 'Qualified', 'Unqualified'. Salesforce's Lead Status picklist has values: 'Open - Not Contacted', 'Working - Contacted', 'Closed - Converted', 'Closed - Not Converted'. The architect needs to map the legacy values to the Salesforce picklist values. Which approach should be used to ensure a successful migration?

Question 59easymultiple choice

Read the full Data Migration explanation →

A data architect is migrating 500,000 records into a custom object that has a validation rule requiring the 'Statusc' field to be either 'Active' or 'Inactive'. The legacy data contains some records with a blank Statusc. The architect needs to ensure the migration succeeds without modifying the validation rule. What should be done?

Question 60hardmultiple choice

Read the full Data Migration explanation →

A data architect is migrating 30 million Opportunity records into Salesforce. The legacy system has a 'Close_Date__c' field that is a date, but some records have invalid dates such as '0000-00-00' or future dates beyond 2099. The Salesforce Opportunity Close Date field is a standard Date field. The architect must ensure the migration does not fail due to these invalid dates. Which approach should be used?