SDA

Salesforce Data Architect (SDA) practice exams

290 questions in 5 timed practice tests. Each test has about 60 questions and a 105-minute limit. The pass mark is 58%. Results are split across the 6 exam domains.

Exam at a glance

SDA practice exam settings
Practice tests 5
Questions in total 290
Questions per test About 60
Time limit per test 105 minutes
Pass mark 58%
Question types Single answer and multiple answer (32 multiple-answer questions)
Level Professional
Category Business Platforms

These are the settings of our practice tests. Check the official Salesforce exam page for the current exam format before you book.

Domains and weights

SDA exam domains, weights and question counts
Domain Weight Weight bar Questions in our bank
Data Modeling and Database Design 25% 72
Master Data Management 5% 14
Salesforce Data Management 25% 73
Data Governance 10% 29
Large Data Volume Considerations 20% 58
Data Migration 15% 44

Sample questions

Question 1 of 3

A data architect is designing a custom Invoice Line object that will receive about 30 million records per year. Lines must always belong to an Invoice, but a few sales users who cannot see an invoice must still be able to own and edit specific lines assigned to them. Which relationship should the architect choose?

  1. A A lookup relationship from Invoice Line to Invoice with the field marked required and deletion of a referenced invoice prevented (correct answer)
  2. B A master-detail relationship from Invoice Line to Invoice with the sharing setting that allows Read access on the master to edit details
  3. C A junction object between Invoice and User so that each assigned sales user receives access to the lines through the junction record
  4. D A master-detail relationship with reparenting allowed so that lines can be moved under an invoice the sales user is able to access
Why: Detail records in a master-detail relationship have no owner and inherit access from the master, so a user who cannot see the invoice could never own or edit a line. A required lookup that prevents deleting the parent keeps lines tied to an invoice while letting each line have its own owner and sharing. Reparenting or relaxing the master's access level still keeps access tied to the invoice, and a junction object does not give line-level ownership.

Question 2 of 3

A university needs to record which Students attend which Courses, along with the grade earned in each enrolment. Each student takes many courses and each course has many students. Enrolments should be removed when either the student or the course is deleted. What is the recommended data model?

  1. A A custom Enrolment junction object with two master-detail relationships, one to Student and one to Course, holding the grade (correct answer)
  2. B Two lookup relationships on a custom Enrolment object, with a nightly scheduled flow that deletes enrolments whose student or course is gone
  3. C A multi-select picklist of course codes on Student, with a long text area field that stores the grade for each code entered
  4. D A lookup from Student to Course and a second lookup from Course to Student, with the grade kept on whichever record was updated last
Why: A junction object with two master-detail relationships is the standard pattern for many-to-many with attributes: the grade lives on the junction record and deleting either master cascades to it. Multi-select picklists cannot carry per-enrolment attributes or be reported reliably. Lookups plus a scheduled cleanup flow work but add needless automation and leave orphans between runs, and reciprocal lookups can only hold one related record each.

Question 3 of 3

Universal Containers keeps 400 million shipment events in an on-premises SQL database that exposes an OData 4.0 endpoint. Sales reps need to see a customer's recent shipment events on the Account page in real time, but the company does not want to consume Salesforce data storage for them. Which approach meets the requirements?

  1. A Use Salesforce Connect external objects for the events, related to Account through an indirect lookup on an external ID (correct answer)
  2. B Load the shipment events into a custom big object indexed by account number and show them on the Account page with a Lightning component
  3. C Replicate the events nightly into a custom object with Bulk API 2.0 and archive anything older than ninety days into a second custom object
  4. D Store the events as Files attached to each Account, generated by a daily export job that writes one CSV file per customer from the SQL database
Why: Salesforce Connect external objects read OData data on demand without copying it into Salesforce, and an indirect lookup joins the external rows to Account through a unique external ID. A big object or a replicated custom object both store the data in Salesforce and are not real time, with the custom object consuming data storage. Daily CSV files consume file storage, are stale, and cannot be queried as records.

What your score report looks like

Example attempt, SDA practice test 3

78%

Passed
Pass mark 58%

Score by exam domain
DomainWeightYour score%
Data Modeling and Database Design 25%
88
Master Data Management 5%
81
Salesforce Data Management 25%
76
Data Governance 10%
58
Large Data Volume Considerations 20%
84
Data Migration 15%
72

Study next: Data Governance. It is below the pass mark and carries 10% of the exam.

Domains and pass mark from our SDA practice tests. Scores are an example attempt.

Study plans

Two weeks

  1. Day 1: take practice test 1 in exam mode to get a baseline.
  2. Days 2 to 5: domain mode on Data Modeling and Database Design and Salesforce Data Management, the two most heavily weighted domains.
  3. Day 6: practice test 2 in exam mode, then the mistakes quiz.
  4. Days 7 to 12: practice tests 3 to 5, one every other day, each followed by its mistakes quiz.
  5. Days 13 and 14: final mode. Book the exam when your readiness stays above the pass mark.

Four weeks

  1. Week 1: one practice test in practice mode, reading every explanation. Note your two lowest domains.
  2. Week 2: domain mode on those two domains, then a second practice test in exam mode.
  3. Week 3: practice tests 3 and 4 in exam mode, with the mistakes and flagged quizzes after each.
  4. Week 4: practice test 5 and final mode until your readiness holds above the pass mark.

Questions about the SDA practice exams

Are these real SDA exam questions?
No. We write every question ourselves and map it to the published SDA exam objectives. We do not use leaked or recalled questions.
Do the time limit and pass mark match the official exam?
They match the settings of our practice tests. Exam providers change their format from time to time, so check the official exam page before you book.
Can I try it before I pay?
Yes. The free mini exam has 15 questions with full explanations and needs no account.
How long do I keep access?
A single-exam purchase gives you 12 months of access. All-Access includes this exam for as long as your subscription runs.
What happens after I finish a test?
You get a score, a pass or fail against the pass mark, a score per domain and every answer with its explanation.

Last updated November 2026. Written and reviewed by the DevOpsCode Lab team.

DevOpsCode Lab is not affiliated with Salesforce. SDA and related names are trademarks of their owners.

Related exams
Exam Vendor Level Questions Minutes Price
SASalesforce Agentforce Salesforce Specialty 300 105 $14.99
Analytics-101Salesforce Tableau Desktop Foundations (Analytics-101) Salesforce Foundational 225 70 $9.99
MSMDIMULESOFT-DEV-I Salesforce MuleSoft Developer I Salesforce Associate 300 120 $12.99
CADServiceNow Application Developer (CAD) ServiceNow Associate 300 90 $12.99
CSAServiceNow CSA ServiceNow Associate 300 90 $12.99
UiPath-ADAv1UiPath Pro Automation Developer Assoc. (UiPath-ADAv1) UiPath Professional 300 90 $14.99