ADM-201 - Data and Analytics Management - Section 6.1

Manage data quality and data operations, including importing and exporting data, data validation tools, duplicate management, and mass record actions.

Import and export data with the Data Import Wizard and Data Loader, choosing the right tool by record volume and object support, and use external IDs to match records on upsert. Maintain data quality with validation rules, duplicate and matching rules, and mass transfer or mass delete operations.

Data Import WizardData LoaderValidation rulesDuplicate managementExternal IDs

Practice question for this objective

Free sampleData and Analytics Managementmedium

At Gascoyne Freight, an administrator must load roughly 250,000 Opportunity records exported from a retired legacy system into Salesforce in a single migration. Which tool best meets this requirement?

  • AUse Data Loader, which is designed for high-volume loads far beyond the wizard's cap. Correct
  • BUse the Data Import Wizard, since it supports Opportunities and needs no separate install.
  • CSplit the source file into five Data Import Wizard passes of 50,000 records each.
  • DUse the Data Import Wizard after raising its record limit in the object's settings.
Choose Data Loader over the Data Import Wizard when the load volume exceeds the wizard's 50,000-record limit. Tool selection for a bulk load turns on volume and object support: the Data Import Wizard is limited to 50,000 records per import, while Data Loader processes up to five million, so a 250,000-record migration requires Data Loader.

Why A is correct: Data Loader handles up to five million records per operation and supports Opportunity, making it the correct choice for a bulk migration of this size.

Why B is wrong: The wizard is convenient and does support several standard objects, but it caps each import at 50,000 records, so it cannot handle a 250,000-record migration in one pass.

Why C is wrong: Batching is a tempting workaround, but it multiplies manual effort and error risk when a single purpose-built tool already handles the whole volume.

Why D is wrong: This sounds plausible, but there is no setting that lifts the wizard's 50,000-record ceiling, so the approach cannot work.

See more ADM-201 practice questions with worked answers.

More in this domain

Back to all Data and Analytics Management objectives, or the ADM-201 cert hub.

Examworthy is not affiliated with or endorsed by Salesforce. Original, blueprint-aligned practice material only.