Data Import, Quality and Duplicate Management
This topic covers import tools, export options, upsert, external IDs, duplicate rules, matching rules, validation, required fields, data cleanup, and data governance.
How to study for Salesforce Administrator
Treat each Salesforce admin item as a configuration decision: identify the data model, access layer, user workflow, automation timing, and governance constraint.
Core concepts
Concept 1
Data Import, Quality and Duplicate Management questions test whether an administrator can choose the right Salesforce setup, security, data, automation, or app feature for a business requirement.
Exam cue: Identify the Salesforce layer: org setting, user, object, field, record type, page, app, data, report, flow, or AI feature.
Concept 2
The best answer respects the data model, record access, user experience, limits, governance, and maintainability.
Exam cue: Match configuration to business outcome while preserving least privilege, data quality, reporting accuracy, and admin maintainability.
Concept 3
Eliminate answers that overbuild with code, weaken visibility controls, skip testing, or confuse object, field, record, and app configuration layers.
Exam cue: Prefer declarative configuration, tested automation, clear ownership, and secure Agentforce or AI grounding when the requirement allows.
Risk pitfalls and guardrails
Using profile or permission changes when sharing or record ownership is the real issue.
Guardrail: Avoid answers that overbuild, weaken access, skip data quality, ignore automation limits, or trust AI output without grounding and review.
Automating before defining data quality, entry criteria, limits, and user impact.
Guardrail: Avoid answers that overbuild, weaken access, skip data quality, ignore automation limits, or trust AI output without grounding and review.
Treating reports, dashboards, or AI output as reliable when source data, access, and grounding are not controlled.
Guardrail: Avoid answers that overbuild, weaken access, skip data quality, ignore automation limits, or trust AI output without grounding and review.
Memory anchors
Data Import Wizard
Data Import Wizard supports guided imports for selected standard and custom objects with duplicate handling options.
Data Loader
Data Loader supports bulk insert, update, upsert, delete, export, and hard delete operations.
Upsert
Upsert updates existing records or inserts new records based on an ID or external ID.
External ID
External ID fields help match records from outside systems during import or integration.
Duplicate Rule
A duplicate rule defines what happens when Salesforce detects a possible duplicate.
Matching Rule
A matching rule defines criteria used to identify potential duplicate records.
Validation Rule
Validation rules enforce data quality by blocking records that violate defined logic.
Required Field
A required field must be populated before a record can be saved or imported.
Data Export
Data export extracts Salesforce data for backup, analysis, migration, or compliance needs.
Data Quality
Data quality depends on accurate, complete, timely, consistent, and governed data.
Checkpoint rule
Do the check-up only after you can summarize each concept in one sentence and identify one dangerous pitfall from memory.
Knowledge Check (after reading)
Short check-up to confirm understanding of this module.
Check-up Questions
A business user has a prepared CSV containing a modest number of new contacts and needs a guided browser-based import with field mapping and duplicate matching options. Which tool is the best fit?
An administrator must export a large set of custom-object records, update selected rows, and load the corrections while retaining detailed success and error files. Which tool should be used?
Answer all questions to submit.
Next step personalized recommendations
Continue learning
Move forward only after this module is stable.
What is Pass Harbor?
Completely free exam prep for 317 U.S. exams.
- Practice questions
- Flashcards
- Study guides
- Mock exams
- No registration
- No paywall
- Start instantly
“No more expensive exam prep. Quality study tools should be accessible to everyone.”