Salesforce Certified Data Architect – Complete Winter '26 Guide

Data Modeling: Objects, Relationships, and Big Objects

Beyond standard objects, Data Architects design custom objects with appropriate relationship types. External Objects connect to data stored outside Salesforce via OData connectors. Big Objects store billions of records but have limited SOQL support (no GROUP BY, aggregate queries) — used for archival. Platform Events are schema-defined and support publish/subscribe. The exam tests when to use each object type and the implications for querying, sharing, and storage.

Master Data Management and Deduplication

MDM strategies define the golden record — the authoritative version of a data entity. Salesforce Matching Rules define how duplicates are identified (fuzzy vs exact matching on fields). Duplicate Rules control what happens when a match is found — alert, block, allow with warning, or report. External IDs support upsert operations — the system matches on external ID to update existing records or insert new ones. The exam tests MDM patterns and duplicate prevention configuration for large-scale data integrations.

Data Migration: Bulk API and Integration Patterns

Bulk API 2.0 processes up to 100 million records per batch job — preferred for large-scale data loads. Data Loader uses Bulk API for loads over 200 records. For complex migrations, ETL (Extract, Transform, Load) tools (MuleSoft, Informatica) prepare data before loading. Heroku Connect provides bi-directional sync between Heroku Postgres and Salesforce. The exam tests which migration tool matches the data volume, transformation complexity, and latency requirements of each scenario.

Data Quality and Governance

Validation Rules enforce data quality at the point of entry — they run on all DML paths (UI, API, Data Loader). Field History Tracking captures changes to up to 20 fields per object and retains data for 18 months. Setup Audit Trail tracks admin configuration changes for 180 days. Data Quality dashboards using CRM Analytics can surface completeness, accuracy, and consistency metrics. The exam tests which governance mechanism addresses a specific data quality requirement.

Large Data Volumes: Performance and Archiving

Large Data Volume (LDV) considerations: indexed fields in WHERE clauses improve SOQL performance (standard fields are indexed; custom fields can be requested). Avoid non-selective queries. Skinny Tables pre-join frequently queried field combinations for reporting performance. Async SOQL runs long-running queries asynchronously. Data archiving to Big Objects or external systems reduces active data volume. The exam tests LDV performance patterns and when to recommend archiving, skinny tables, or query optimisation.

Advanced Data Modeling

Know when to use lookup, master-detail, hierarchical (self-referential), and external relationships. Understand junction objects, indirect lookup fields, and how relationship type affects roll-up summaries, cascade delete, and record access.

Large Data Volume (LDV) Strategies

Know how to handle LDV: skinny tables, custom indexes, selective queries, division archiving, and big objects. Understand what causes a full table scan and how to prevent query timeouts.

Data Quality & Duplicate Management

Know Duplicate Rules, Matching Rules, and how they interact. Understand how to use Data.com clean rules (legacy knowledge), field validation, and data stewardship processes for ongoing data quality.

Data Migration Architecture

Plan migration using external IDs (upsert strategy), parent-before-child load order, and the appropriate API (Bulk API for volume, REST for real-time). Understand data validation and rollback strategies.

Master Data Management

Know MDM patterns: Registry, Consolidation, and Coexistence. Understand how to implement a golden record strategy, handle conflicting records, and synchronize master data across systems.