UUS Practice Tests⌕ Search
IT Certifications · Plat-Arch-201

Salesforce Data Architect Exam Practice Test

Salesforce data architecture focuses on how records are structured, related, validated, retained, and exchanged across systems. Practice topics include choosing field types and relationship models, maintaining stable external identifiers, enforcing data quality, and supporting integrations without unnecessary record duplication. These decisions shape how Salesforce data can be maintained, reported on, and used by connected applications.

Exam overview

Exam providerSalesforce
Exam codePlat-Arch-201
CategoryIT Certifications

About the Salesforce Data Architect Exam

Architects evaluate whether information belongs in Salesforce storage or should be accessed from an external source, then design object relationships to support the required reporting and record behavior. This includes distinguishing lookup, master-detail, and many-to-many patterns; modeling repeating attributes as related records; and selecting fields that preserve source-system identifiers during imports. Data-quality decisions can involve validation rules, while audit requirements may call for extended field history. Architects also consider how changes move between environments through metadata deployment artifacts and how external applications receive change notifications through event-driven patterns. These choices affect storage, data integrity, integration reliability, and the effort required to evolve a Salesforce data model. The practice material offers scenario-based prompts across these kinds of design decisions, rather than asserting an official topic list or weighting.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

A company wants to prevent users from changing a calculated value while still displaying it on record pages and in reports. Which field design is generally appropriate?

  1. AFormula field
  2. BLong text area
  3. CEncrypted text field
  4. DMulti-select picklist
Show answerCorrect answer: A

A formula field derives its value from other fields or supported expressions and is not directly edited by users. It is suitable for displaying calculated values, subject to formula limitations and reporting requirements.

Question 2

A business wants to combine data from an external system in Salesforce without copying the external records into Salesforce storage. Which approach should the architect evaluate?

  1. AExternal objects through Salesforce Connect
  2. BA scheduled export and re-import of all records
  3. CA long text field containing serialized records
  4. DA custom object populated with nightly snapshots
Show answerCorrect answer: A

Salesforce Connect can expose data from supported external systems as external objects, allowing users and supported platform features to work with external data without storing a full copy as Salesforce records. Suitability depends on connector, access, and feature requirements.

Question 3

A data architect is mapping customer data from an external system into Salesforce. The external system’s customer identifier must remain stable and support matching records during repeated imports. What is the best field design?

  1. AUse a custom field marked as an External ID and uniquely constrain it when appropriate
  2. BUse the customer’s current mailing address as the record identifier
  3. CUse the Salesforce record name as the only matching key
  4. DGenerate a new random identifier for every import
Show answerCorrect answer: A

A stable External ID field supports matching and upserting records using the source system’s identifier. A uniqueness constraint can prevent duplicate values when the source identifier is intended to identify exactly one record.

Question 4

A Salesforce team needs to move configuration changes between development and test environments in a repeatable way. Which artifact is commonly used to package metadata for deployment?

  1. AA metadata deployment package or source-controlled metadata project
  2. BA report export in CSV format
  3. CA database backup file containing record data only
  4. DA list view shared with the test users
Show answerCorrect answer: A

Salesforce metadata can be deployed using metadata packages or source-based deployment workflows. These carry configuration such as object and field definitions; a CSV export is data, not a metadata deployment artifact.

Question 5

A company needs to represent several alternate names for each organization, with each name having a language and a valid-from date. Which data-modeling approach best supports these attributes without adding a fixed set of name fields to the organization record?

  1. ACreate a related custom object with one record per alternate name
  2. BAdd a separate text field for every anticipated language
  3. CStore all names and dates in one long text field
  4. DUse a formula field that concatenates the organization name with its language
Show answerCorrect answer: A

A related object allows each alternate name to have its own language, effective date, and other attributes, and supports a variable number of names per organization. Fixed fields and concatenated text are harder to validate, query, and maintain.

Question 6

A company wants to enforce that a customer account’s postal code is populated whenever its country is set to a particular value. Which declarative mechanism is most appropriate for preventing invalid saves?

  1. AA validation rule that checks the relevant country and postal-code conditions
  2. BA dashboard filter that excludes records with blank postal codes
  3. CA sharing rule based on the country field
  4. DA compact layout that displays the postal-code field
Show answerCorrect answer: A

A validation rule can evaluate field values at save time and prevent records from being saved when the specified condition is violated. Reports and layouts can expose or display data but do not enforce this data-quality requirement.

Question 7

A company’s analytics team needs to retain a complete history of changes to a critical custom field for several years. Standard field history tracking does not meet the required retention period. Which option is designed for extended field audit history?

  1. AField Audit Trail
  2. BA formula field referencing the current value
  3. CA dashboard refresh schedule
  4. DA duplicate rule
Show answerCorrect answer: A

Field Audit Trail is designed to extend field history retention beyond the standard field history tracking period, subject to the organization’s product entitlements and configuration. A formula field only evaluates current data and does not preserve prior values.

How to use this practice test

The free practice bank contains 50 questions, with up to 20 randomly selected for a session. Answer each scenario by identifying the data-model or integration requirement it describes, then compare your choices with the results shown after the session. Use missed questions to pinpoint concepts that need further review.

Preparation tips

  • For each relationship scenario, sketch the parent and child objects and identify whether the requirement calls for lookup, master-detail, or a junction object.
  • Practice mapping external identifiers to Salesforce fields; distinguish stable matching keys from fields intended for display or reporting.
  • Compare external-record access with copying records into Salesforce, noting how each choice affects storage and data availability.
  • Work through data-quality and audit scenarios by matching requirements to validation rules, field history tracking, or extended field audit history.
  • Review change-delivery options and metadata deployment artifacts, distinguishing event-driven notifications from repeated polling and configuration from business data.
Official sourceOfficial exam page ↗