Exporting data: Data Export Service and bulk queries
Choose and tune the right export: Data Export Service backups (edition frequency, active-user schedules, 512 MB zips, 48-hour downloads, excluded fields), Bulk API 2.0 query jobs versus Bulk API PK chunking, Data Loader Export and Export All, report export views, and the sharing that limits what an export user sees.
Compare and contrast various techniques and considerations for exporting data from Salesforce.
~7 min read · 15 practice questions ·
What the exam expects
- Plan Data Export Service backups: frequency by edition, who can schedule and view them, file sizes, download window and what the files leave out.
- Choose Bulk API 2.0 query jobs or Bulk API with PK chunking for a large extract, and fix queries the job rejects or that time out.
- Pick Data Loader Export or Export All, and a report's Formatted Report or Details Only view.
- Explain why an export returns fewer records than exist and grant the narrowest fix.
Key terms: Data Export Service (Setup's scheduled or on-demand CSV backup of org data); PK chunking (splitting a bulk query into record-ID ranges); query job (a Bulk API 2.0 asynchronous SOQL extract); locator (the token that fetches the next set of query results); Export All (Data Loader's export that also returns archived activity records and soft-deleted records).
Key facts
- Detail
- Enterprise, Performance, Unlimited; Professional and Developer every 29 days
- Detail
- Error emails; export doesn't run
- Detail
- About 512 MB each; deleted 48 hours after the email
- Detail
- GROUP BY, OFFSET, TYPEOF, aggregates, compound fields, parent-to-child
- Detail
- ORDER BY, LIMIT (and ID-field filters for Bulk API)
- Detail
- Must match the create call, else 409
- Detail
- Default 100,000; maximum 250,000
- Detail
- Adds archived activities and soft-deleted records
Sources for this section (5)
- Export Backup Datahelp.salesforce.com (opens in a new tab)
- Understanding Bulk API 2.0 Querydeveloper.salesforce.com (opens in a new tab)
- PK Chunkingdeveloper.salesforce.com (opens in a new tab)
- Get Results for a Query Jobdeveloper.salesforce.com (opens in a new tab)
- Data Loader Exportdeveloper.salesforce.com (opens in a new tab)
- Why does an unfiltered Data Loader export under a private sharing model omit records?
- When do you set
startRowin the PK chunking header? - Why should a downstream load map export columns by header?
- Which report export view suits pivot tables and formulas?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Platform Data Architect pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 21 lessons of the Platform Data Architect guide, with reading progress
- Interactive decision walks and step-by-step sequence steppers
- Inline practice questions and one-click topic practice (15 questions for this lesson)
- An official source cited for every claim
- An AI tutor that answers from the guide
- Unlimited timed practice exams