Salesforce DATA ARCHITECTURE AND MANAGEMENT DESIGNER Exam Questions

Questions for the DATA ARCHITECTURE AND MANAGEMENT DESIGNER were updated on : Dec 01 ,2025

Page 1 out of 15. Viewing questions 1-15 out of 222

Question 1

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?

  • A. Create a custom object to store aggregate data and run reports.
  • B. Contact Salesforce support to enable skinny table for cases.
  • C. Move data off of the platform and run reporting outside Salesforce, and give access to reports.
  • D. Build reports using custom Lightning components.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 2

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. Defer rollup summary field calculation during data migration.
  • B. Perform a batch job in serial mode and reduce the batch size.
  • C. Perform a batch job in parallel mode and reduce the batch size.
  • D. Leverage Data Loader's platform API to load data.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 3

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: L Point-of-sale system: All purchases for a customer
2. Salesforce; All customer service activity and sales activities for a customer
3. Mobile app: All bookings, preferences, and browser activity for a customer
4. Marketing: All email, SMS, and social campaigns for a customer
Customer service agents using Salesforee 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. Explore external data sources in Salesforce to build a 360 degree view of the customer.
  • B. Use a customer data mart to create the 360 degree view of the customer.
  • C. Periodically upload summary information in Salesforce to build a 360 degree view.
  • D. Migrate customer activities fro, all four system into Salesforce.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 4

Universal Containers (UC) is migrating from an on-premise homegrown customer relationship
management (CRM) system- During analysis, UC users highlight a pain point that there are multiple
versions of many customers.
What should the data architect do for a successful migration to mitigate the pain point?

  • A. Hire an intern manually de-duplicate the records after migrating to Salesforce.
  • B. Migrate the data as is, and use Salesforce's de-duplicating feature.
  • C. Have the users manually clean the data in the old system prior to migration.
  • D. Store the data in a staging database, and de-duplicate identical records.
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 5

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 custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
  • B. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
  • C. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.
  • D. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
Answer:

D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 6

Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group
membership processing, UC also has multiple admins on staff that perform manual adjustments to
the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing "lock
errors" consistently.
What should a data architect recommend to mitigate these errors?

  • A. Enable granular locking.
  • B. Remove SOQL statements from Apex Loops.
  • C. Enable sharing recalculations.
  • D. Ask Salesforce support for additional CPU power.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 7

Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity
management in Saiesforce Is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on
opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when
PPS updates their opportunities.
How should a data architect address this overwriting issue?

  • A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.
  • B. Change PSS integration to update only Opportunity Amount field when the value is null.
  • C. Change Opportunity Amount field access to Read Only for sales users field-level security.
  • D. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 8

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. leverage duplicate rules in Salesforce to validate duplicates during the account creation process.
  • B. Develop an Apex class that searches for duplicates and removes them nightly.
  • C. Implement an MDM solution to validate the customer information before creating Salesforce.
  • D. Build a custom search functionality that allows sales associates to search for customer in real time upon visiting their retail stores.
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 9

Universal Containers (UC) is implementing Salesforce and will be using Salesforce to track customer
complaints, provide white papers on products, and provide subscription based support.
Which license type will UC users need to fulfill UC's requirements?

  • A. Sales Cloud License
  • B. Lightning Platform Starter License
  • C. Service Cloud License
  • D. Salesforce License
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 10

Northern Trail Outfitters (NTO) has a variety of customers that include householder, 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 option should a data architect perform to resolve the issues with the customer data?

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

A, C, E

User Votes:
A
50%
B
50%
C
50%
D
50%
E
50%
Discussions
vote your answer:
A
B
C
D
E
0 / 1000

Question 11

Universal Container has a Sales Cloud implementation for a sales team and an enterprise resource
planning (ERP) as a customer master Sales team are complaining about duplicate account and data
quality issues with account data.
Which two solution should a data architect recommend to resolve the complaints?

  • A. Build a nightly batch job to de-dupe data, and merge account records.
  • B. Integrate Salesforce with ERP, and make ERP as system of truth.
  • C. Build a nightly sync job from ERP to Salesforce.
  • D. Implement a de-dupe solution and establish account ownership in Salesforce
Answer:

B, D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 12

UC is preparing to implement sales cloud and would like to 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. Create a criteria-based sharing rule.
  • B. Implicit sharing will automatically handle with standard functionality.
  • C. Add appropriate users to the account team.
  • D. Create an owner-based sharing rule.
Answer:

B

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 13

North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset
data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement?

  • A. Standard reports and dashboards
  • B. Async SOQL with a custom object
  • C. Standard SOQL queries
  • D. Einstein Analytics
Answer:

B, D

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 14

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's
main Salesforce org will be divided into two org:org A and org B, UC has delivered these
requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?

  • A. use as ETL tool to orchestrate the migration.
  • B. Use Data Loader for export and Data Import Wizard for import
  • C. Write a script to use the Bulk API
  • D. Use the Salesforces CLI to query, export, and import
Answer:

C

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000

Question 15

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

  • A. validation Rule
  • B. required Fields
  • C. Apex Class
  • D. Process Builder
Answer:

A

User Votes:
A
50%
B
50%
C
50%
D
50%
Discussions
vote your answer:
A
B
C
D
0 / 1000
To page 2