What is the Data Cloud Consultant exam format?

The Data Cloud Consultant exam has 60 multiple-choice questions, a 105-minute time limit, a 62% passing score, and a $200 fee ($100 retake). Despite the lower passing score, the exam is considered harder than most Salesforce certifications because it tests a complex technical domain: data ingestion, data modelling, identity resolution, SQL-based calculated insights, and activation configuration.

What are the highest-weight Data Cloud Consultant exam sections?

Data Ingestion and Modeling (28%) is the largest section — understanding data streams, data lake objects (DLOs), data model objects (DMOs), and how data maps from source to unified profile is the foundation of everything else. Identity Resolution, Segmentation, and Insights (25%) is second. Together they account for 53% of the exam.

What SQL knowledge is needed for Data Cloud Consultant?

Calculated Insights in Data Cloud are created using SQL — specifically ANSI SQL with some Data Cloud-specific syntax. You need to write SELECT queries that aggregate data from Data Model Objects (DMOs). Common patterns tested: COUNT(), SUM(), AVG() with GROUP BY for building audience metrics, and DATE functions for recency calculations. The SQL is not as complex as a database developer role, but you must be comfortable writing and reading basic aggregation queries.

What is identity resolution in Data Cloud?

Identity resolution is the process of linking records from multiple data sources that belong to the same real-world customer into a single unified profile. Data Cloud uses Rulesets — configured matching rules (by email, phone, name + address, or custom criteria) — to determine when two records represent the same person. The result is a Contact Point object (for each contact method like email, phone) and a unified Individual object (the merged profile). Understanding ruleset configuration and when to use fuzzy vs exact matching is heavily tested.

Updated for Winter '26

Salesforce Data Cloud Consultant Study Guide (Winter '26): Complete Exam Prep

The Data Cloud Consultant certification validates your ability to implement Salesforce's customer data platform (CDP) — ingesting data from multiple sources, resolving customer identities, building audience segments, and activating unified profiles to marketing and service channels. This guide covers every exam section at the depth needed to pass one of Salesforce's most technically demanding certifications.

Written and reviewed by Krishna Mohan — ADM-201, PD1, PD2, App Builder & Consultant certified. Updated for Winter '26. Methodology · Contact

Data Cloud Consultant Exam at a Glance

Questions

105 min

Time Limit

62%

Passing Score

$200

Exam Fee

62% passing score — lower than most Salesforce exams, reflecting the exam's technical depth. Retake fee: $100. SQL and data modelling experience strongly recommended.

Data Cloud Consultant Exam Sections and Weightage

Data Ingestion (28%) + Identity Resolution & Segmentation (25%) = 53% of the exam. Mastering the data model and identity resolution is the foundation for everything else.

Data Ingestion and Modeling28%

Data streams (batch, streaming), Data Lake Objects (DLOs), Data Model Objects (DMOs), field mapping, schema design

Identity Resolution, Segmentation & Insights25%

Rulesets, matching rules, unified profiles, segment criteria, calculated insights with SQL, activation audiences

Configure and Manage Data Cloud20%

Org configuration, permission sets, data spaces, consent management, data retention policies, error monitoring

Act on Data with Salesforce Ecosystem17%

Activating segments to Marketing Cloud, Advertising, Service Cloud; Data Cloud for Agentforce grounding

Administer Data Cloud10%

User administration, ingestion job monitoring, troubleshooting data gaps, managing data stream health

What Each Section Actually Tests

Data Ingestion and Modeling (28%)

This section is the foundation of all Data Cloud work. Know the two ingestion object types: Data Lake Objects (DLOs) — the raw landing zone for ingested data (one DLO per data stream), and Data Model Objects (DMOs) — the normalised, unified schema objects that DLO data is mapped into (Individual, Contact Point Email, Contact Point Phone, Unified Individual, etc.). The Data Cloud canonical data model is based on a standard entity schema — understand the hierarchy: Individual → Contact Point → Unified Individual. Field mapping (from DLO fields to DMO fields) is the critical operational skill tested. Also know data stream types: batch (file-based via SFTP or cloud storage), streaming (real-time via API), and Salesforce CRM connector (syncing CRM objects directly).

Identity Resolution, Segmentation & Insights (25%)

Identity Resolution: Rulesets define how records from different DLOs are matched and merged into a unified profile. Matching rule types: exact match (email address, phone number — high confidence), fuzzy match (name + address — lower confidence, higher recall). Know that when two records match, they link to the same Unified Individual. Calculated Insights: SQL-based metrics computed over DMO data (e.g., total spend per customer, days since last purchase). Written as SELECT queries with GROUP BY against DMO tables. Segmentation: Segment criteria filters Unified Individuals based on attributes or calculated insights. Segments can be time-based (related to when attributes change) or static.

Configure and Manage Data Cloud (20%)

Data Cloud org setup: enabling Data Cloud in a Salesforce org, configuring permission sets (Data Cloud Admin, Data Cloud Marketing Admin, Data Cloud Marketing Viewer), and understanding data spaces (organisational containers for data isolation — e.g., separating business unit data). Consent management: how Data Cloud tracks consent (opt-in/opt-out) and how consent propagates to activation. Data retention: setting retention periods on DLOs and DMOs. Error monitoring: reviewing ingestion job logs, identifying field mapping errors, and correcting data stream configuration issues.

Act on Data with Salesforce Ecosystem (17%)

Activating Data Cloud segments to downstream channels. Marketing Cloud activation: publishing a segment to Marketing Cloud creates a data extension in SFMC that updates on the activation schedule. Know that the data extension contains the Unified Individual attributes selected during activation setup. Advertising activation: pushing segments to Google, Facebook, LinkedIn for paid media targeting. Service Cloud activation: surfacing unified profile data in Service Cloud agent console for real-time context. Agentforce grounding: Data Cloud as the data layer for grounding AI agents with real-time customer context.

6-Week Data Cloud Consultant Study Plan

Week 1 — Data Cloud Architecture & Setup (20%): Study the overall Data Cloud architecture, enable Data Cloud in a Developer Edition org, configure permission sets, and explore the Data Cloud setup wizard. Understand data spaces and how they isolate data. Complete Trailhead's “Salesforce Data Cloud Basics” trail.

Week 2 — Data Ingestion & Modeling (28%): Create data streams (start with a Salesforce CRM connector stream, then add a batch file stream). Understand the DLO → DMO mapping workflow. Map DLO fields to standard DMO fields (especially to Individual and Contact Point DMOs). This week is the most important — data modelling is the foundation of everything else.

Week 3 — Identity Resolution (part of 25%): Configure a Ruleset with exact-match rules (email) and fuzzy-match rules (name + address). Run the identity resolution process and inspect the resulting Unified Individual records. Understand how to diagnose over-merging (too aggressive fuzzy matching) vs under-merging (too restrictive rules).

Week 4 — Calculated Insights & Segmentation (part of 25%): Write Calculated Insight SQL queries — start with simple COUNT and SUM aggregations, then practice date-based calculations (DATEDIFF, DATEADD). Build segments using Calculated Insights as criteria. Practice publishing a segment and inspecting the activation output.

Week 5 — Activation & Ecosystem Integration (17% + 10%): Configure an activation to Marketing Cloud (create the activation, select attributes, set refresh schedule). Study Advertising activations conceptually. Review administration tasks: job monitoring, error log interpretation, ingestion troubleshooting.

Week 6: Full timed mock exams. Target 70%+ before booking (above the 62% threshold to account for exam difficulty variance).

How to Approach Data Cloud Consultant Scenario Questions

DLO vs DMO questions: DLOs are raw landing zones — one per data stream, named after the source. DMOs are the normalised output — they follow the Data Cloud canonical model. When a question asks “where is data stored after ingestion?”, the answer is the DLO. When it asks “where do you query unified customer data?”, the answer is the DMO (specifically the Unified Individual DMO for merged profiles).
Identity resolution questions: If the scenario says records from two systems need to be merged into one profile, the answer is identity resolution with a Ruleset. If it asks which match type to use: email match is exact (very high confidence, low risk of false matches); name + address is fuzzy (higher recall, risk of merging different people with similar names). When in doubt, exact match on email is the safest default.
Activation questions: When data needs to flow from Data Cloud to Marketing Cloud for sending, the answer is an Activation publishing a segment to a Marketing Cloud data extension. The activation schedule (hourly, daily, real-time) depends on how fresh the audience needs to be. Real-time activation is only available for streaming data streams — batch data updates on the ingestion schedule.

Mock-Test Benchmark Before Booking

70%+ on 3 timed full mocks before booking

Set the mock benchmark higher than the 62% passing score because the real exam's scenario questions are harder than most practice banks. Candidates who pass mocks at exactly 62% frequently fail the real exam. The most common failure point is data modelling — candidates who have not configured DLO-to-DMO mappings hands-on consistently misidentify the correct mapping approach under exam conditions.

Practice With Real Exam-Style Questions

Apply this study guide with free Data Cloud Consultant practice questions:

Data Cloud Practice Questions Data Cloud Exam Tips Data Cloud vs Marketing Cloud

What Comes After This Certification?

After this certification, consider: Sales Cloud Consultant, Service Cloud Consultant, or Experience Cloud Consultant.

Exam Section Difficulty Heatmap

Which sections are a gimme vs which ones trap confident candidates. Use this to prioritise your final-week revision.

Exam Section	Difficulty	Study Tip
Data Cloud Architecture	Hard	Data model objects (Data Lake, Data Model Object) and when to use Data Cloud vs CRM analytics.
Data Model and Identity	Trap ⚠	Identity resolution and graph — many candidates confuse identity types and resolution rules.
Activation and Insights	Moderate	Activation targets and insight types — know which channel or object each applies to.
Governance and Best Practices	Moderate	Data quality and governance in Data Cloud — retention and consent appear in scenarios.

Difficulty based on analysis of common candidate errors across each exam section.

Ready to Test Your Knowledge?

Try the Data Cloud Consultant free practice exam — scored with full explanations.

Data Cloud Consultant Free Practice Exam →