Maintenance15% of the exam
Data extracts, file transfers and SQL query activities
When to get data out of Marketing Cloud Engagement with a Data Extract and File Transfer activity, when to segment or report inside it with a SQL Query activity over data views, the limits that break each one (250 queued extracts, 25 GB, 30-minute timeout, 24 failures), and when the job belongs in Data 360 or a warehouse instead.
Given a scenario, describe solutions for data extraction and report generation.
~8 min read · 15 practice questions ·
What the exam expects
- Choose between a Data Extract activity, a SQL Query activity, a Filter activity and Data 360 or a warehouse, given where the data must end up and how big the job is.
- Set up a data extract correctly: provisioned extract types, a File Transfer Location, a separate File Transfer step, a safe file name and a sensible extract range.
- Recognise the limits that stop extracts and queries: 250 queued extracts per MID, the 25 GB guidance, the 30-minute timeout, the 10-minute rule of thumb and suspension after 24 consecutive failures.
- Pick the system data views for engagement and automation-health reports.
- Key terms: Data Extract activity (writes zipped files for use outside the platform); File Transfer activity (moves a file from the Safehouse to an FTP location); SQL Query activity (writes results into a data extension); data view (a queryable system table of tracking and journey data); extract range (a tracking extract's look-back window).
Key facts
Data Extract output
- Detail
- One or more zipped files for use outside the platform
Before the first extract
- Detail
- AE provisions extract types; File Transfer Location in Account Settings
File Transfer placement
- Detail
- A separate step after the Data Extract activity
Extract range end
- Detail
- Always the moment the extract activity starts
Extract queue
- Detail
- 250 or more queued per MID: new requests rejected
Extract size
- Detail
- Keep under 25 GB to avoid performance issues
SQL Query sources
- Detail
- Data extensions and system data views
SQL Query timeout
- Detail
- 30 minutes; consider another tool past 10 minutes
Query suspension
- Detail
- System error or 24 consecutive failures; check the action log
Large multi-source segmentation
- Detail
- Internal data warehouse or Data 360
_Open and _Click retention
- Detail
- Six months
Automation health views
- Detail
- _AutomationInstance and _AutomationActivityInstance
- Why must the File Transfer activity sit in its own step?
- When does Salesforce recommend replacing a SQL Query activity with another tool?
- Why would a SQL Query activity show as suspended?
- Which data views report on automation health?
The questions are free to read. Answers with their sources and self-grading are included with the pack.
Keep reading with the Marketing Cloud Engagement Administrator pack
- Core concepts
- Exam traps
- Worked scenario
The pack includes:
- All 20 lessons of the Marketing Cloud Engagement Administrator 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