ADM-201 · Question #77
Northern Trail Outfitters imported records for their marketing team. The administrator notices that some of the records failed to import with the data loader. What should that administrator do to…
The correct answer is C. Deactivate validation rules before running the import. To successfully import data with the Data Loader when records are failing, the administrator should temporarily deactivate validation rules that may be preventing the data from being saved.
Question
Northern Trail Outfitters imported records for their marketing team. The administrator notices that some of the records failed to import with the data loader. What should that administrator do to import data without failures?
Options
- ARun the import in batch mode.
- BUse the import wizard to import the records.
- CDeactivate validation rules before running the import.
- DRun the import with the deduplication rules off.
How the community answered
(23 responses)- A9% (2)
- B17% (4)
- C70% (16)
- D4% (1)
Why each option
To successfully import data with the Data Loader when records are failing, the administrator should temporarily deactivate validation rules that may be preventing the data from being saved.
Data Loader already processes records in batches; running in batch mode is its standard operation and does not inherently prevent failures caused by data issues or validation rules.
While the Import Wizard has different capabilities, it has a lower record limit and similar validation rules would still apply if the data is faulty, so it doesn't guarantee success for failed Data Loader imports.
Validation rules enforce data integrity and can prevent records from being saved if the data does not meet the defined criteria. Deactivating them temporarily during a bulk import using Data Loader can allow the records to be imported, though this should be done cautiously after verifying data quality.
Salesforce's standard or custom deduplication rules (matching rules) typically identify duplicates but do not necessarily prevent an *initial* import failure unless they are configured to block creation, which is less common for import failures than validation rules.
Concept tested: Troubleshooting Data Loader import failures (validation rules)
Source: https://help.salesforce.com/s/articleView?id=sf.workflow_deactivate_validation_rules.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.