Certified Data Architect

Here you have the best Salesforce Certified Data Architect practice exam questions

  • You have 136 total questions to study from
  • Each page has 5 questions, making a total of 28 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on October 12, 2025
  • This site is not affiliated with or endorsed by Salesforce.
Question 1 of 136
Universal Containers (UC) is replacing a home grown CRM solution with Salesforce. UC has decided to migrate operational (open and active) records to Salesforce, while keeping historical records in legacy system. UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?
    Correct Answer: C

    A mashup allows Salesforce to display real-time data from external systems within the Salesforce interface. This solution ensures that historical records can be accessed as needed by displaying them in Salesforce without the need to migrate all historical data. This approach is efficient and keeps historical data readily available while minimizing storage and management overhead within Salesforce.

Question 2 of 136
Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance Issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?
    Correct Answer: A

    To improve performance for agents running case reports with a large volume of records and fields, enabling a skinny table for the Case object is a suitable solution. Skinny tables are specially designed to speed up read-only operations and queries by reducing the number of joins required, thus enhancing reporting performance. Support from Salesforce is needed to enable and configure skinny tables tailored to the specific needs of the organization.

Question 3 of 136
A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
1. State in which the customer is located
2. City in which the customer is located if available
3. Zip code in which the customer is located if available
4. Changes to this information should have minimum code change
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?
    Correct Answer: B

    To effectively maintain pricing criteria with minimal code changes, custom metadata types are the best solution. Custom metadata types allow for easy deployment and management of configuration data, which includes state, city, and zip code hierarchies. This solution ensures that any changes to the pricing criteria can be made without requiring significant changes to the codebase, aligning with the requirement to minimize code changes.

Question 4 of 136
A customer is operating in a highly regulated industry and is planning to implement Salesforce. The customer information maintained in Salesforce. includes the following:
1. Personally Identifiable information (PII)
2. IP restrictions on profiles organized by geographic location
3. Financial records that need to be private and accessible only by the assigned sales associate
Enterprise Security has mandated access to be restricted to users within a specific geography with detailed monitoring of user activity. Additionally, users should not be allowed to export information from Salesforce.
Which three Salesforce Shield capabilities should a data architect recommend? (Choose three.)
    Correct Answer: A, B, E

    To ensure compliance with the security requirements mentioned, three key Salesforce Shield capabilities should be recommended: Event Monitoring to monitor all user activity, Encrypt sensitive customer information maintained in Salesforce, and Transaction Security policies to prevent export of Salesforce data. Event Monitoring will allow for detailed tracking of user actions, ensuring that any unauthorized access or changes are flagged. Encrypting sensitive information addresses the need to safeguard personally identifiable information and financial records. Transaction Security policies specifically help to restrict and control data export, fulfilling the requirement to prevent users from exporting information out of Salesforce.

Question 5 of 136
Universal Containers (UC) is transitioning from Classic to Lightning Experience.
What does UC need to do to ensure users have access to its notes and attachments in Lightning Experience?
    Correct Answer: D

    To ensure users have access to notes and attachments in Lightning Experience, Universal Containers needs to migrate Notes and Attachments to Enhanced Notes and Files using a migration tool. This migration ensures compatibility and a better user experience in the Lightning interface.