Free Salesforce Certified Platform Data Architect Exam Practice Questions

Sample Practice Questions

Try these 10 sample questions from the Salesforce Certified Platform Data Architect Exam practice bank. Each includes the answer and explanation. Continue with the interactive practice above to review the full question set.

1. 1A custom Inspection record must remain available after its related Site record is deleted, with the Site link cleared. Which relationship design meets this requirement?

   1. A. A master-detail field from Inspection to Site
   2. B. An optional lookup from Inspection to Site with clear-on-delete behavior
   3. C. A required lookup from Inspection to Site that prevents deletion
   4. D. An optional lookup from Inspection to Site with cascade deletion enabled

   Answer: B

   Explanation: The lookup deletion option states: "Clear the value of this field". Select an optional lookup with this behavior to preserve the Inspection and clear its Site reference. Master-detail deletes related details; preventing deletion or cascading it does not meet the requested behavior.

   Reference: Object Relationships Overview — Lookup — optional lookup deletion behaviors

2. 2Several source systems use different structures and names for the same customer concepts. An MDM design for Salesforce needs one shared structure to which each source can map. Which modeling approach addresses that requirement?

   1. A. Keep each source schema as an unrelated target model
   2. B. Use field sensitivity labels as the shared customer structure
   3. C. Map the sources to a canonical customer data model
   4. D. Use record sharing rules to translate source field meanings

   Answer: C

   Explanation: Salesforce describes connecting sources as "mapping data from the source to a canonical data model". A canonical model supplies common structure and semantics for source mappings. Independent target schemas, sensitivity labels, and sharing rules do not provide that common customer representation.

   Reference: Q&A: Inside Salesforce Customer 360 — How Customer 360 Truth enables consistent, reconciled data — CIM paragraph

3. 3Sales employees need standard Opportunity functionality. Operations employees need only custom applications plus Accounts and Contacts. Which traditional user-license allocation matches these requirements without granting every employee the full CRM license?

   1. A. Salesforce Platform for sales; Salesforce for operations
   2. B. Identity Only for sales; Salesforce Platform for operations
   3. C. Salesforce for sales; Salesforce Platform for operations
   4. D. Salesforce Platform for both groups

   Answer: C

   Explanation: The Platform license excludes objects "such as forecasts, leads, campaigns, and opportunities." The same description includes Accounts, Contacts, and custom apps. Full Salesforce therefore fits sales, while Platform fits operations. Platform and Identity Only do not provide the sales group’s required Opportunity entitlement.

   Reference: Standard User Licenses — Platform User Licenses — Salesforce Platform; Salesforce User Licenses — Salesforce

4. 4A Salesforce appointment application needs a customer's name, contact details, and preferred time. It has no business need for the customer's financial history. Which modeling decision follows data minimization?

   1. A. Collect financial history and hide it on the main layout
   2. B. Collect financial history and mark it optional
   3. C. Omit financial-history collection from this application
   4. D. Collect financial history and move it into a less-used object

   Answer: C

   Explanation: The privacy module states: "Organizations should only collect the minimum amount of data necessary for the processing purpose in question." Omitting unnecessary financial history limits collection to the defined purpose. Hiding, making optional, or relocating unnecessary data does not achieve the same minimization.

   Reference: Apply Data Privacy Principles — Data Minimization

5. 5An LDV report filters an indexed Status field with NOT EQUALS Closed. The small set of open statuses is known and selective. Which filter redesign follows Salesforce's index guidance?

   1. A. Use NOT CONTAINS Closed as the Status condition
   2. B. Use a positive IN filter listing the open statuses
   3. C. Keep Status NOT EQUALS Closed and add a row limit
   4. D. Use Status NOT IN a list containing Closed

   Answer: B

   Explanation: The guidance says: "For better performance, filter using = or IN, and the reciprocal values." A selective positive open-status list avoids the negative operator. NOT CONTAINS and NOT IN remain negative conditions; limiting returned rows does not replace the NOT EQUALS predicate with an index-eligible positive filter.

   Reference: Maximizing the Performance of Force.com SOQL, Reports, and List Views — Using NOT and !=

6. 6Customer files from several legacy systems contain inconsistent formats and known duplicates. Which preparation step does Salesforce recommend before the initial load?

   1. A. Load all source rows, then begin cross-source cleansing in production
   2. B. Normalize formats before loading but postpone known duplicate resolution
   3. C. Clean formats and deduplicate the combined source data before loading
   4. D. Deduplicate each source file separately and leave cross-source duplicates

   Answer: C

   Explanation: Salesforce advises: "Try to clean and de-duplicate as much of your data as possible prior to loading." Address both inconsistent values and known duplicates across the sources. Delaying cleanup, correcting only formats, or deduplicating only within individual files leaves known avoidable issues in the initial target load.

   Reference: Manage Data at Scale with Salesforce — Step 1: Prepare Your Data

7. 7Each Consultant can participate in many Engagements, and each Engagement can include many Consultants. The participation itself has fields such as allocation percentage. How should this be modeled using Salesforce's master-detail approach?

   1. A. Add a hierarchical relationship on Consultant to Engagement
   2. B. Store Engagement identifiers in a text field on Consultant
   3. C. Create a junction object linking Consultant and Engagement
   4. D. Create one master-detail field directly from Consultant to Engagement

   Answer: C

   Explanation: Salesforce states: "When modeling a many-to-many relationship, you use a junction object to connect the two objects you want to relate to each other." The junction record represents each participation and holds its allocation. A single direct relationship cannot represent both many sides, and text identifiers do not create the relationship model.

   Reference: Object Relationships Overview — Create a Many-to-Many Object Relationship

8. 8An enterprise needs one persisted, governed customer record used as the authoritative source across Salesforce and several operational systems. Which unification approach matches this scope?

   1. A. Centralized master data management across the systems
   2. B. Duplicate detection and merging confined to one CRM
   3. C. A key-ring approach linking the separate source records
   4. D. A nightly append of all source records into an unmastered table

   Answer: A

   Explanation: The module describes MDM as data "Stored as a single, trusted golden record." It states: "This unified record is then used as the source of truth across systems." Local CRM deduplication does not govern the other systems. A key ring links rather than consolidates source records, while an unmastered append does not establish one authoritative record.

   Reference: Compare Customer Profile Unification Approaches — Master Data Management Platforms

9. 9A design proposes assigning two baseline user licenses to the same employee so that the employee can combine their object entitlements. Which correction follows Salesforce's user-license model?

   1. A. Assign a single appropriate baseline user license and evaluate supported add-ons separately
   2. B. Assign the second baseline license through the employee's role
   3. C. Assign one baseline license per custom object the employee accesses
   4. D. Assign both baseline licenses by creating two permission sets

   Answer: A

   Explanation: Salesforce states: "Each user can have only one user license." The architect must select one suitable baseline and separately assess applicable supplementary entitlements. Roles and permission sets do not attach a second baseline user license.

   Reference: User Licenses — How User Licenses Work

10. 10A Salesforce program collected personal data for servicing warranty claims. A new project proposes using it for unrelated profiling. Which design review directly addresses the purpose-limitation principle?

    1. A. Review the new processing purpose and its appropriate legal basis before reuse
    2. B. Treat the original warranty purpose as authorization for any later profiling
    3. C. Treat encryption of the stored data as authorization for the new purpose
    4. D. Treat unchanged data ownership as authorization for the new purpose

    Answer: A

    Explanation: The module states: "Organizations should process personal data only for specified, explicit, and legitimate purposes." A new profiling purpose needs appropriate review. The original warranty purpose does not automatically cover unrelated profiling, and neither encryption nor unchanged ownership establishes authorization for a new purpose.

    Reference: Apply Data Privacy Principles — Purpose Limitation