Section 7 · Data and Analytics Management · 17% of exam
7.1 Importing, updating, transferring, deleting, exporting, and backing up data
Exam objective
Describe data import, update, transfer, mass deletion, export, backup, and archival considerations, including Data Import Wizard and Data Loader. Data Import Wizard supports common imports for selected standard and custom objects through a guided interface. Data Loader supports broader bulk insert, update, upsert, delete, and export operations. Choose based on object support, record volume, required operation, automation needs, and user skill.
For updates and transfers, use stable record IDs or external IDs to match records correctly. Prepare parent records before children when relationships depend on them. Test a representative sample, review field mappings, preserve a backup, and monitor errors before running a large load.
Exports and backups support recovery and retention, but they are not the same as a complete archival strategy. Consider retention requirements, attachments or files, relationships, access controls, and restore procedures. Mass deletion is difficult to reverse, so confirm criteria and retain a recoverable copy before execution.
Additional concepts
Import Wizard and Data Loader
Use the Data Import Wizard for supported common imports through a guided interface. Data Loader supports broader bulk operations and objects. Tool choice depends on the object, operation, record volume, and whether the operation must insert, update, upsert, delete, or export.
| Data need | Tool consideration |
|---|---|
| Guided import for a supported object | Data Import Wizard |
| Bulk insert, update, upsert, delete, or export | Data Loader |
| Match updates to existing records | Record ID or external ID |
Plan recovery before bulk changes
Back up the data and validate a small sample before a large job. Preserve IDs or external IDs to maintain relationships, review rejected rows and error files, and confirm how records can be restored. Archiving is a retention decision that should include related files, relationships, access, and retrieval needs.
An administrator must update thousands of contacts and preserve their account relationships. Use a supported bulk tool, match contacts with IDs or external IDs, test a small file, review errors, then run the validated load.
Never run a mass update or deletion without validating the selection criteria and recovery plan.
Key takeaways
- Match the tool to operation, volume, supported object, and required control.
- Use IDs or external IDs to update or upsert records reliably.
- Validate, back up, and inspect errors before and after bulk operations.
