Data-Architect Exam Questions and Answers

QUESTION: 6

Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues.
Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Limitations on master -detail relationships.
Org data storage limitations.
Bulk API limitations on picklist fields.
Standard list view in -line editing.

Answer(s): C,D

Reveal Solution Next Question

QUESTION: 7

Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year.
What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers

Use SOQL queries without WHERE conditions.
Work with Salesforce Support to enable Skinny Tables.
Reduce the number of triggers on Order _c object.
Make the queries more selective using indexed fields.

Answer(s): B,D

Reveal Solution Next Question

QUESTION: 8

Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records.
When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?

Create a picklist field, values sorted alphabetically.
Create a Master -Detail to custom object ShippingStatus c.
Create a Lookup to custom object ShippingStatus c.
Create a text field and make it an external I

Answer(s): A

Reveal Solution Next Question

QUESTION: 9

Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months.
What are two approaches that will meet this requirement? Choose 2 answers

Create a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
Create a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.

Answer(s): B,C

Reveal Solution Next Question

QUESTION: 10

Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?

Create a "before delete" trigger to check if the current user is not the owner.
Set the Sharing settings as Public Read Only for the Contact object.
Set the profile of the users to remove delete permission from the Contact object.
Create a validation rule on the Contact object to check if the current user is not the owner.

Answer(s): A

Reveal Solution Next Question

Salesforce Data-Architect Exam (page: 2) Salesforce Certified Data Architect Updated on: 25-Dec-2025

QUESTION: 6

QUESTION: 7

QUESTION: 8

QUESTION: 9

QUESTION: 10

Salesforce Data-Architect Exam (page: 2)
Salesforce Certified Data Architect
Updated on: 25-Dec-2025