100+ Free Salesforce Data Architect Practice Questions

Pass your Salesforce Certified Data Architect exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately

Not publicly published Pass Rate

100+ Questions

100% Free

1 / 100

Question 1

Score: 0/0

An architect needs a relationship where the child record is owned by, and inherits sharing from, the parent record, and where the parent is required at all times. Which relationship type should be used?

Lookup

Master-Detail

Hierarchical

External Lookup

to track

2026 Statistics

Key Facts: Salesforce Data Architect Exam

Scored Questions

Salesforce exam guide

105 min

Time Limit

Salesforce exam guide

58%

Passing Score

Salesforce exam guide

$400

Exam Fee

Architect-tier registration

25%

Largest Domain

Data Modeling / Salesforce Data Management

Smallest Domain

Master Data Management

Salesforce's Data Architect exam has 60 questions, a 105-minute time limit, a 58% pass score, and a US$400 fee at the architect tier. The exam covers six domains, with Data Modeling and Database Design and Salesforce Data Management each at 25%, Large Data Volume Considerations at 20%, Data Migration at 15%, Data Governance at 10%, and Master Data Management at 5%. There is no formal prerequisite, but Salesforce recommends 2-5 years of experience designing scalable data solutions on the platform, including LDV strategies, sharing model trade-offs, MDM patterns, and Salesforce Connect / Data Cloud familiarity.

Sample Salesforce Data Architect Practice Questions

Try these sample questions to test your Salesforce Data Architect exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1An architect needs a relationship where the child record is owned by, and inherits sharing from, the parent record, and where the parent is required at all times. Which relationship type should be used?

A.Lookup

B.Master-Detail

C.Hierarchical

D.External Lookup

Explanation: Master-Detail relationships make the child record's owner and sharing inherit from the parent. Deleting the parent cascade-deletes children, and the parent field on the child is required.

2Which relationship type can ONLY be created on the User object?

A.Master-Detail

B.Many-to-Many

C.Hierarchical

D.Indirect Lookup

Explanation: The Hierarchical relationship is a special Lookup field available only on User. It is commonly used to model manager-employee chains.

3A junction object is used to implement which kind of relationship?

A.One-to-One

B.Self-Referential

C.Many-to-Many

D.Hierarchical

Explanation: A junction object is a custom object with two Master-Detail relationships, used to model many-to-many relationships between two parent objects.

4What is the maximum number of Master-Detail relationships that a single custom object can have?

A.1

B.2

C.3

D.5

Explanation: A custom object can have at most two Master-Detail relationships, which is exactly what enables a junction object pattern for many-to-many modeling.

5Which object type stores data that physically resides outside Salesforce and is accessed in real time via Salesforce Connect?

A.Custom Object

B.Big Object

C.External Object

D.Standard Object

Explanation: External Objects are defined in Salesforce but their data lives in an external system (typically OData-compatible) and is fetched on demand via Salesforce Connect.

6Which object type is designed to store and manage massive volumes of historical or archival data within Salesforce, supporting billions of records?

A.Big Object

B.Custom Object

C.External Object

D.Person Account

Explanation: Big Objects are built for very large data volumes (billions of records). They are queried with SOQL or asynchronous SOQL and are useful for archival, audit, and event data.

7Which feature allows efficient querying of millions of records in Big Objects through asynchronous SOQL processing?

A.Bulk API 2.0

B.Async SOQL

C.REST Composite

D.Streaming API

Explanation: Async SOQL is the asynchronous query engine designed to scan and aggregate Big Object data without blocking interactive operations.

8A B2C company plans to manage individual consumers (not organizations) in Salesforce. Which feature should the architect enable to model individuals as accounts and contacts together?

A.Person Accounts

B.Standard Account with related Contacts

C.External ID on Contact

D.Big Object Customer

Explanation: Person Accounts merge the Account and Contact into a single record optimized for B2C scenarios where the customer is an individual consumer.

9Once enabled, can Person Accounts be turned OFF in a Salesforce org?

A.Yes, anytime in Setup

B.No, the change is irreversible

C.Only by Salesforce Support during a release window

D.Yes, but only in Sandbox refreshes

Explanation: Enabling Person Accounts is an irreversible org-wide change. Architects must be certain the B2C model is required before turning the feature on.

10Which feature lets a Salesforce object query data stored in an external system on demand via OData without copying records into Salesforce?

A.Salesforce Connect

B.Bulk API

C.Change Data Capture

D.Outbound Messaging

Explanation: Salesforce Connect surfaces external data as External Objects via OData (or a custom adapter), so records are read live from the source rather than copied.

About the Salesforce Data Architect Exam

The Salesforce Certified Data Architect exam validates expertise in designing, governing, and migrating data on the Salesforce platform. Candidates are expected to design large-scale data models, choose the right relationships and object types, manage large data volumes (LDV), apply Salesforce sharing and encryption correctly, plan complex data migrations, and select appropriate MDM, integration, and Data Cloud strategies for enterprise customer data.

Assessment

60 multiple choice / multi-select questions plus up to 5 unscored items

Time Limit

105 minutes

Passing Score

58%

Exam Fee

US$400 (architect-tier) (Salesforce)

Salesforce Data Architect Exam Content Outline

25%

Data Modeling and Database Design

Standard, custom, external, and big objects; Lookup vs Master-Detail vs Hierarchical vs Many-to-Many; Person Accounts; cross-object formula and platform limits; multi-org strategy.

25%

Salesforce Data Management

Sharing model (OWD, role hierarchy, sharing rules, manual, criteria-based, Apex managed sharing), Salesforce Connect, integration patterns, MuleSoft, Bulk API 2.0, governor limits.

20%

Large Data Volume Considerations

Skinny tables, indexed fields, query selectivity, defer sharing calculation, PK chunking, data archiving, Big Objects with Async SOQL, sharing recalculation cost.

15%

Data Migration

Data Loader, Workbench, Salesforce Inspector, sandbox rehearsal, External ID upsert, audit field preservation, hard delete, ContentVersion / Files migration.

10%

Data Governance

Duplicate management, Field-Level Security, Shield Platform Encryption (deterministic vs probabilistic, BYOK), Field History Tracking + Field Audit Trail, GDPR/CCPA Right to be Forgotten, Data Mask, Privacy Center.

Master Data Management

MDM styles (Registry, Consolidation, Coexistence, Transactional), golden records, Salesforce Data Cloud as the unified profile and identity-resolution layer, MuleSoft for orchestration.

How to Pass the Salesforce Data Architect Exam

What You Need to Know

Passing score: 58%
Assessment: 60 multiple choice / multi-select questions plus up to 5 unscored items
Time limit: 105 minutes
Exam fee: US$400 (architect-tier)

Keys to Passing

Complete 500+ practice questions
Score 80%+ consistently before scheduling
Focus on highest-weighted sections
Use our AI tutor for tough concepts

Salesforce Data Architect Study Tips from Top Performers

1Memorize the relationship matrix: Lookup vs Master-Detail vs Hierarchical vs Many-to-Many vs External Lookup vs Indirect Lookup, including their limits, cascade behaviors, and where they're allowed.

2Master the sharing model end-to-end (OWD, role hierarchy, sharing rules, manual, criteria-based, Apex managed sharing) and know when each is required.

3Know the LDV toolbox cold: skinny tables, indexed fields, query selectivity (~10% rule), Defer Sharing Calculation, PK Chunking, Bulk API 2.0, and Big Objects with Async SOQL.

4Understand the four MDM styles (Registry, Consolidation, Coexistence, Transactional) and which Salesforce/MuleSoft pieces support each.

5Practice picking Salesforce Connect vs replicate-into-Custom-Object based on latency, callout volume, residency, and reporting needs.

6Be precise on Shield: deterministic vs probabilistic encryption, BYOK, and the impact of encryption on indexes and filtering.

7Plan migration order (parents first), use External IDs for upsert, preserve audit fields with Set Audit Fields, and rehearse in a Full Sandbox.

Frequently Asked Questions

How many questions are on the Salesforce Data Architect exam?

Salesforce's exam guide lists 60 multiple-choice / multi-select questions, with up to 5 unscored items. The time limit is 105 minutes.

What is the passing score?

The passing score is 58%. Salesforce does not publish a public first-attempt pass rate, but the exam is widely regarded as challenging and assumes 2-5 years of hands-on data architecture experience on the platform.

How much does the exam cost?

The exam fee is US$400 at the architect tier. A retake costs US$200. There is no formal prerequisite certification, but Application Architect candidates often hold this credential.

Which domains weigh the most?

Data Modeling and Database Design and Salesforce Data Management both weigh 25%. Large Data Volume Considerations is 20%, Data Migration 15%, Data Governance 10%, and Master Data Management 5%. Together, modeling and data management are half the exam.

Are there prerequisites?

There is no formal prerequisite exam. Salesforce recommends 2-5 years of experience designing scalable data solutions, plus deep familiarity with the sharing model, LDV best practices, integration patterns, and Salesforce Connect / Data Cloud.

How does this credential fit the Application Architect path?

Salesforce Certified Data Architect is one of the four exams that compose the Application Architect designation, along with Sharing and Visibility Designer, Platform App Builder, and Platform Developer I.