Is the Certified Data Architect practice exam free?

Yes. ExamCademy offers all 136 Certified Data Architect practice questions for free with a registered account. No payment needed. Optional supporter features add AI explanations and spaced repetition study tools.

How accurate are the Certified Data Architect practice questions?

All Certified Data Architect questions are community-created and reviewed by moderators to align with Salesforce's published exam objectives. The community continuously reports and fixes issues to keep content accurate and up to date.

How should I study for the Certified Data Architect exam?

Start by browsing practice questions to identify weak areas. Use spaced repetition (Learn Mode) to focus study time on topics you struggle with. Combine practice questions with official Salesforce documentation and hands-on experience for best results.

Certified Data Architect Practice Exam — Free 136+ Questions

136Practice Questions

3Study Modes

FreeTo Get Started

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Page 1 of 6 • Questions 1-25 of 136

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

Northern Trail Outfitters (NTO) has outgrown its current Salesforce org and will be migrating to a new org shortly. As part of this process, NTO will be migrating all of its metadata and data. NTO's data model in the source org has a complex relationship hierarchy with several master-detail and lookup relationships across objects, which should be maintained in the target org.
Which three things should a data architect do to maintain the relationship hierarchy during migration? (Choose three.)

A Redefine the master-detail relationship fields to lookup relationship fields in the target org.
B Use Data Loader to export the data from the source org and then import/upsert into the target org in sequential order.
C Keep the relationship fields populated with the source record IDs in the import file.
D Replace source record IDs with new record IDs from the target org in the import file.
E Create an external ID field for each object in the target org and map source record IDs to this field.

Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:

NTO has a total of five million customers.
Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three options should a data architect perform to resolve the Issues with the customer data? (Choose three.)

A Invest in data duplication tool to de-dupe and merge duplicate records across all systems.
B Use Salesforce CDC to sync customer data across all systems to keep customer record in sync.
C Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
D Create a unique global customer ID for each customer and store that in all systems for referential identity.
E Duplicate customer records across the systems and provide a two-way sync of data between the systems.

Northern Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org. NTO also owns several secondary orgs that the service, finance, and marketing teams work out of. At the moment, there is no integration between central and secondary orgs, leading to data visibility issues.
Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

A A middleware solution that extracts and distributes data across both the hub and spokes.
B Develop custom APIs to poll the spoke org for change data and push into the hub org.
C Develop custom APIs to poll the hub org for change data and push into the spoke orgs.
D A backup and archive solution that extracts and restores data across orgs.

A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:

Salesforce CRM
Custom billing solution
Customer master data management (MDM)
Contract management system
Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?

A Store the Salesforce ID in all the solutions to identify the customer.
B Create a custom field as external ID to maintain the customer ID from the MDM solution.
C Create a custom object that will serve as a cross-reference for the customer ID.
D Create a customer database, and use this ID in all systems.

Northern Trail Outfitters (NTO) has the following systems:
Customer master—source of truth for customer information

Service cloud—customer support -
Marketing cloud—marketing communications
Enterprise data warehouse-business reporting
The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information.
NTO is planning to implement a master data management (MDM) solution across the enterprise.
Which three data issues will an MDM tool solve? (Choose three.)

A Data loss and recovery
B Data accuracy and quality
C Data completeness
D Data duplication
E Data standardization

A casino is implementing Salesforce and is planning to build a customer 360-degree view for a customer who visits its resorts. The casino currently maintains the following systems that record customer activity:

Point-of-sale system: All purchases for a customer
Salesforce: Ail customer service activity and sales activities for a customer
Mobile app: All bookings, preferences, and browser activity for a customer
Marketing: All email, SMS, and social campaigns for a customer
Customer service agents using Salesforce would like to view the activities from all four systems to provide support to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?

A Use a customer data mart to create the 360-degree view of the customer.
B Periodically upload summary information in Salesforce to build a 360-degree view.
C Migrate customer activities from all four systems into Salesforce.
D Explore external data sources in Salesforce to build a 360-degree view of the customer.

Universal Containers (UC) has the following systems:

Billing system
Customer support system
CRM system
UC has been having trouble with business intelligence across the different systems. Recently UC implemented a master data management (MDM) solution that will be the system of truth for the customer records.
Which MDM data element is needed to allow reporting across these systems?

A Phone number
B Email address
C Full name
D Globally Unique Identifier

During the implementation of Salesforce, a customer has the following requirements for Sales Order:

Sales Order information needs to be shown to users in Salesforce.
Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
Sales Order information has more than 150 million records.
Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in Salesforce?

A Use custom objects to maintain Sales Orders in Salesforce.
B Use external objects to maintain Sales Orders in Salesforce.
C Use custom big objects to maintain Sales Orders in Salesforce.
D Use Standard Order object to maintain Sale Orders in Salesforce.

Universal Containers is preparing to implement Sales Cloud and would like its users to have Read Only access to an Account record if they have access to its child Opportunity record.
How would a data architect implement this sharing requirement between objects?

A Implicit sharing will automatically handle this with standard functionality.
B Create an owner-based sharing rule.
C Add appropriate users to the Account team.
D Create a criteria-based sharing rule.

Universal Containers is using Salesforce for Opportunity management and enterprise resource planning (ERP) for order management. Sales reps do not have access to the ERP and have no visibility into order status.
What solution should a data architect recommend to give the sales team visibility into order status?

A Leverage Canvas to bring the order management UI in to the Salesforce tab.
B Build real-time integration to pull order line items into Salesforce when viewing orders.
C Build batch jobs to push order line items to Salesforce.
D Leverage Salesforce Connect to bring the order line item from the legacy system to Salesforce.

A large multinational B2C Salesforce customer is looking to implement their distributor management application in Salesforce. The application has the following capabilities:

Distributors create Sales Orders in Salesforce.
Sales Orders are based on Product prices applicable to their region.
Sales Orders are closed once they are fulfilled.
It is decided to maintain Sales Orders in Opportunities object.
How should the data architect model this requirement?

A Create lookup to Custom Price object and share with distributors.
B Manually update Opportunities with Prices applicable to distributors
C Configure Price Books for each region and share with distributors.
D Add custom fields in Opportunity and use triggers to update prices.

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM. UC is concerned about the quality of data being entered by users and through external integrations.
Which two solutions should a data architect recommend to mitigate data quality issues? (Choose two.)

A Leverage third-party AppExchange tools.
B Leverage Apex to validate the format of data being entered via a mobile device.
C Leverage validation rules and workflows.
D Leverage picklist and lookup fields where possible.

A large Insurance provider is looking to implement Salesforce. The following conditions exist:

Multiple channels for lead acquisition
Duplicate leads across channels
Poor customer experience and higher costs
On analysis, it was found that there are duplicate leads that are resulting in multiple quotes and opportunities.
Which three actions should a data architect recommend to mitigate the issues? (Choose three.)

A Implement third-party solution to dean and enrich lead data.
B Implement de-duplication strategy to prevent duplicate leads.
C Build a custom solution to identify and merge duplicate leads.
D Standardize lead information across all channels.
E Build process to manually search and merge duplicates.

A large automobile company has implemented Salesforce for its sales associates. Leads flow from its website to Salesforce using a batch integration in Salesforce. The batch job converts the leads to Accounts in Salesforce. Customers visiting their retail stores are also created in Salesforce as Accounts.
The company has noticed a large number of duplicate Accounts in Salesforce. On analysis, it was found that certain customers could interact with its website and also visit the store. The sales associates use Global Search to search for customers in Salesforce before they create the customers.
Which option should a data architect choose to implement to avoid duplicates?

A Develop an Apex class that searches for duplicates and removes them nightly.
B Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
C Leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
D Implement an MDM solution to validate the customer information before creating Accounts in Salesforce.

Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and automated updates at the same time.
What should a data architect do in order to resolve the issue?

A Enable granular locking.
B Enable parallel sharing rule calculation.
C Enable defer sharing calculation.
D Enable implicit sharing.

A large retail company has recently chosen Salesforce as Its CRM solution. They have the following record counts:
2,500,000 Accounts
25,000,000 Contacts
When doing an initial performance test, the data architect noticed an extremely slow response-time for reports and list views.
What should a data architect do to solve the performance issues?

A Create a Skinny Table to represent Account and Contact objects.
B Limit data loading to the 2,000 most recently created records.
C Add Custom Indexes on frequently searched Account and Contact fields.
D Load only data that the user is permitted to access.

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?

A Leverage real-time integration to pull records into Salesforce.
B Build a swivel chair solution to go into the legacy system and display records.
C Leverage mashup to display historical records in Salesforce.
D Bring all data in Salesforce, and delete it after a year.

Universal Container has implemented Sales Cloud to manage patient and related health records. During a recent security audit of the system, it was discovered that some standard and custom fields need to encrypted.
Which solution should a data architect recommend to encrypt existing fields?

A Implement shield platform encryption to encrypt custom and standard fields.
B Export data out of Salesforce and encrypt custom and standard fields.
C Implement classic encryption to encrypt custom and standard fields.
D Use Apex Crypto Class to encrypt custom and standard fields.

As part of addressing General Data Protection Regulation (GDPR) requirements, Universal Containers (UC) plans to implement a data classification policy for all of its internal systems that store customer information including Salesforce.
What should a data architect recommend so that UC can easily classify customer information maintained in Salesforce under both standard and custom objects?

A Use Data Classification metadata fields available in Field definition.
B Build reports that contain customer data and classify manually.
C Create a custom picklist field to capture classification of information on the Contact object.
D Use an AppExchange product to classify fields based on policy.

Universal Containers requires all customers to provide either a phone number or an email address when registering for an account.
What should the data architect use to ensure this requirement is met?

A Validation Rule
B Apex Class
C Process Builder
D Required Fields

Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs chance of encountering race conditions on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?

A Embed the keywords FOR UPDATE after SOQL statements.
B Refactor or optimize classes and triggers for maximum CPU performance.
C Migrate programmatic logic to processes and flows.
D Disable classes or triggers that have the potential to obtain the same record.

Universal Containers has a rollup summary field on account to calculate the number of contacts associated with an account. During the account load, Salesforce is throwing an "UNABLE_TO_LOCK_ROW" error.
Which solution should a data architect recommend to resolve the error?

A Perform a batch job in parallel mode and reduce the batch size.
B Defer rollup summary field calculation during data migration.
C Perform a batch job in serial mode and reduce the batch size.
D Leverage Data Loader’s platform API to load data.

Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?

A Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.
B Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
C Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
D Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in
Salesforce:

Information in certain records is incomplete.
Incorrect entry in certain fields causes records to be excluded in report filters.
Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues? (Choose three.)

A Explore third-party data providers to enrich and augment information entered in Salesforce.
B Build a sales data warehouse with purpose-built data marts for dashboards and senior management reporting.
C Design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect.
D Periodically export data to cleanse data and import them back into Salesforce for executive reports.
E Leverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records.

Northern Trail Outfitters (NTO) has been using Salesforce for Sales and Service for 10 years. For the past two years, the marketing group has noticed a rise from 0% to 35% in returned mail when sending mail using the contact information stored in Salesforce.
Which solution should the data architect use to reduce the amount of returned mail?

A Email all customers and ask them to verify their information and to call NTO if their address is incorrect.
B Delete contacts when the mail is returned to save postal costs for NTO.
C Have the sales team call all existing customers and ask to verify the contact details.
D Use a third-party data source to update the contact information in Salesforce.

Certified Data ArchitectPreview

About the Certified Data Architect Exam

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Certified Data ArchitectPreview

About the Certified Data Architect Exam

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25