# Free SDA practice questions

> 10 free SDA practice questions with the correct answer and an explanation.

Page: https://devopscodelab.com/exams/salesforce-data-architect/free-practice-questions/
Practice exams: https://devopscodelab.com/exams/salesforce-data-architect/

### Question 1 of 10

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?

- A. A lookup relationship from Invoice Line to Invoice with the field marked required and deletion of a referenced invoice prevented
- B. A master-detail relationship from Invoice Line to Invoice with the sharing setting that allows Read access on the master to edit details
- C. A junction object between Invoice and User so that each assigned sales user receives access to the lines through the junction record
- D. A master-detail relationship with reparenting allowed so that lines can be moved under an invoice the sales user is able to access

**Answer:** A

**Explanation:** 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 10

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?

- A. A custom Enrolment junction object with two master-detail relationships, one to Student and one to Course, holding the grade
- B. Two lookup relationships on a custom Enrolment object, with a nightly scheduled flow that deletes enrolments whose student or course is gone
- C. A multi-select picklist of course codes on Student, with a long text area field that stores the grade for each code entered
- 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

**Answer:** A

**Explanation:** 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 10

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?

- A. Use Salesforce Connect external objects for the events, related to Account through an indirect lookup on an external ID
- 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
- 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
- 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

**Answer:** A

**Explanation:** 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.

### Question 4 of 10

A bank wants a single view of each customer across six systems without changing those systems or copying full customer data into a hub. The hub should only hold matching keys and links to the source records. Which MDM style is this?

- A. Centralized style
- B. Consolidation style
- C. Registry style
- D. Coexistence style

**Answer:** C

**Explanation:** Registry style keeps only identifiers and cross-references, building the unified view at read time from the sources, with no changes to them. Consolidation copies data into a hub for a golden record used for reporting, coexistence also synchronizes the golden record back, and centralized style makes the hub the only authoring system.

### Question 5 of 10

A company wants to back up all Salesforce data weekly and be able to restore specific records with their relationships after accidental deletions or bad data loads. Which approach provides this most completely?

- A. A full sandbox refreshed every week, which holds a copy of production data that can be copied back when needed
- B. The weekly Data Export Service, with export files stored on a shared drive for administrators to reload with Data Loader
- C. The Recycle Bin, which keeps deleted records for 15 days so administrators can restore them with their child records
- D. A backup and recovery solution that captures data and metadata and restores records with their relationships

**Answer:** D

**Explanation:** A backup and recovery product, such as Salesforce Backup or an AppExchange solution, captures data and metadata and restores records with their relationships. Data Export files can be reloaded but rebuilding relationships and IDs is manual. The Recycle Bin does not help with bad updates and is time limited, and sandboxes are not backups and cannot be copied back to production.

### Question 6 of 10

Sales reps keep creating duplicate leads. The business wants reps to be warned and to see possible matches when they save a lead that matches an existing contact by email, but still be allowed to save it, while the duplicates are reported. Which configuration meets this?

- A. A before-save record-triggered flow that searches contacts by email and, if it finds one, assigns the lead to a data steward queue
- B. A matching rule on Lead that compares to Contact by email, used by a duplicate rule set to Allow with an alert and reporting enabled
- C. A duplicate rule on Lead set to Block on create and edit, using the standard contact matching rule with an alert to the user
- D. A validation rule on Lead that uses VLOOKUP to compare the email with contacts and shows an error message when they match

**Answer:** B

**Explanation:** Duplicate rules can compare leads with contacts through a cross-object matching rule, and the Allow action with alert and report shows matches while still letting the user save and creating duplicate record sets for reporting. A validation rule or a Block action prevents the save, which the business does not want, and VLOOKUP works only on custom objects. A flow that reassigns the lead neither warns the user nor shows the matches.

### Question 7 of 10

A healthcare provider must encrypt patient diagnosis fields at rest while still allowing users to filter list views on them with exact-match criteria. Keys must be rotated and controlled by the company. Which solution should the architect recommend?

- A. Field-level security that hides the diagnosis fields from all profiles except clinicians, combined with sandbox data masking
- B. Shield Platform Encryption with probabilistic encryption on all fields, plus a separate formula field that copies each diagnosis
- C. Classic encrypted custom fields with masking characters shown to users who do not have the View Encrypted Data permission
- D. Shield Platform Encryption with deterministic encryption on the diagnosis fields and tenant secrets managed by the company

**Answer:** D

**Explanation:** Deterministic encryption in Shield Platform Encryption keeps fields encrypted at rest but still supports exact-match filtering, and customers manage tenant secrets and key rotation. Classic encrypted fields cannot be filtered and offer limited key control. Probabilistic encryption blocks filtering and a copying formula field would expose plaintext, while field-level security controls visibility but does not encrypt anything.

### Question 8 of 10

A query on a custom object with 8 million records filters on a custom text field Region__c and is timing out. The Query Plan tool shows a table scan. The filter typically returns about 20,000 records. What should the data architect do first?

- A. Request a custom index on Region__c from Salesforce Support, since the filter is selective enough to use it
- B. Add an ORDER BY clause on Region__c and a LIMIT of 50,000 rows so the query optimizer sorts more efficiently
- C. Convert Region__c to a formula field that references the owner's region, so the value is calculated at runtime
- D. Change the filter to use a LIKE operator with a leading wildcard so that partial region names also match

**Answer:** A

**Explanation:** Twenty thousand rows out of 8 million is well under the selectivity threshold for a custom index, so an index on Region__c lets the optimizer avoid the table scan. A leading wildcard makes the filter non-selective, and ORDER BY with LIMIT does not make the filter itself selective. A cross-object formula field cannot be indexed and is calculated at runtime, which is slower.

### Question 9 of 10

A custom object has a lookup to Account. One Account named Unassigned is the parent of 900,000 records, and inserts into the object are failing with lock errors. What is this condition called, and how should it be addressed?

- A. Selectivity failure; request a custom index on the lookup field so inserts no longer lock the parent
- B. Ownership skew; give the owner of the Unassigned account the View All Data permission so the lock is released
- C. Lookup skew; spread the records across several placeholder parents or leave the lookup blank where possible
- D. Sharing skew; change the custom object to Public Read Only so that parent locks are not acquired

**Answer:** C

**Explanation:** When a very large number of records point to the same lookup parent, inserts and updates contend for a lock on that parent, which is lookup skew; spreading records over multiple parents or leaving the lookup null reduces contention. Ownership skew is about record owners, an index does not affect row locking, and changing sharing defaults does not remove parent locks.

### Question 10 of 10

A legacy system has 1.5 million attachments related to accounts and cases. They must be migrated into Salesforce Files and appear on the right records. Which approach should the architect use?

- A. Insert ContentVersion records with the file data and set FirstPublishLocationId to the related record's ID
- B. Insert ContentDocument records directly with the binary data and a ParentId field for the related record
- C. Insert Attachment records with ParentId set, then run the platform conversion that turns them into Files
- D. Upload all files to a single Library, then ask users to link each file to its record from the Files tab

**Answer:** A

**Explanation:** Creating ContentVersion records with FirstPublishLocationId stores each file and links it to the related record in one step. Loading Attachment records keeps the legacy model and needs another conversion. Manual linking is impractical at this volume, and ContentDocument records are created automatically from ContentVersion rather than inserted directly.

Ready for a timed run? Take the free 15-question SDA mini exam: https://devopscodelab.com/app/exams/salesforce-data-architect/mini/

DevOpsCode Lab is not affiliated with Salesforce. SDA and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
