ADM-201 - Data and Analytics Management (17% of the exam) - 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, answers explained.

Exam traps in Data and Analytics Management

Answers that look right on this material and are not. Each one is a distractor from a different question in the ADM-201 bank for this domain.

Data Import Wizard, because it walks the administrator through field mapping and supports every standard and custom object.
Why it is wrong: The wizard is tempting because of its guided mapping, but it is capped at 50,000 records per import and cannot handle a 240,000-record load, so it is the wrong choice here.
Open each Account and change the Owner field by hand to the new executive.
Why it is wrong: Editing records one by one would technically work but is impractical for 3,000 Accounts and ignores the purpose-built bulk tool.
It always inserts every row as a new record and relies on duplicate rules configured separately to block any duplicates.
Why it is wrong: The wizard itself provides matching to update rather than always inserting, so this understates its capability, though duplicate rules can indeed add a second layer of protection.

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