Data Layer23% of the exam

Scheduling data sync, recipes and event-based runs

How refreshes are scheduled: per-connection data sync schedules, connection modes and what forces a full sync, time-based and event-based recipe and dataflow schedules, when schedules are removed, and the run and output limits that cap refresh frequency.

Official exam objective
Given business needs and consolidated data, implement refreshes for data syncs and dataflows/recipes while keeping limits and considerations in mind.

~7 min read · 13 practice questions ·

What the exam expects

  • Give objects from one source different sync intervals, and set the scheduler's frequency, stop time and time zone correctly.
  • Pick incremental, periodic full or full sync for an object, and explain why a sync ran in full.
  • Chain recipes and dataflows to syncs with event-based schedules within the dependent-job limit.
  • Predict when a schedule is removed (deactivated owner, sandbox, Developer or trial org).
  • Size refresh frequency against the run limit, sync run times and the Salesforce output cap, and find current usage.

Key terms: connection mode (how one object syncs: incremental, periodic full or full); time-based schedule (runs at a clock time or interval); event-based schedule (runs a recipe or dataflow after a sync, upload or other job finishes); dependent job (a job an event-based schedule waits for); rolling 24-hour period (the moving window that run and output limits count in).

Key facts

Schedule scope
Detail
Per connection; different intervals need separate connections
Time zone
Detail
The user who set the schedule
Sub-hourly
Detail
Every 5, 15, 20 or 30 minutes with Plus; not in sandbox
No stop time
Detail
Schedule stops adding runs at 11:59 PM
Incremental and periodic full
Detail
Need API Type BULKV2
Periodic full sync
Detail
Full sync on the first sync after Friday 11 PM, org time zone
Forced full sync
Detail
First sync; object or field changes
Event-based dependents
Detail
At most 5
Dataflow events
Detail
Remote connection syncs don't trigger them
Schedule removal
Detail
30 days after last save in sandbox and Developer, 10 in trial; owner deactivated
Sync run time
Detail
24 hours local, 12 hours remote
Output to Salesforce
Detail
1 million rows per run and per rolling 24 hours
Usage
Detail
Usage tab or Setup Getting Started page
Sources for this section (7)
  • When does an object in Periodic Full Sync mode get its full sync?
  • Why should an object with formula fields run in Full Sync mode?
  • Why might an event-based dataflow stay idle after a remote org's data sync finishes?
  • Which runs of a preceding recipe can trigger an event-based recipe?

The questions are free to read. Answers with their sources and self-grading are included with the pack.

Keep reading with the CRM Analytics and Einstein Discovery Consultant pack

  • Core concepts
  • Exam traps
  • Worked scenario

The pack includes:

  • All 26 lessons of the CRM Analytics and Einstein Discovery Consultant guide, with reading progress
  • Interactive decision walks and step-by-step sequence steppers
  • Practice exams purchase adds inline bank questions and topic practice (13 questions for this lesson)
  • An official source cited for every claim
  • An AI tutor that answers from the guide
  • Choose guide-only, practice-only, or save $4 with both

Practice for the CRM Analytics and Einstein Discovery Consultant exam