Salesforce data architecture and management designer practice test

Question 1

Cloud Kicks has the following requirements:
• Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all
separate custom objects).
• If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records
should not be allowed.
• Each custom object must have separate sharing models.
What should an Architect do to fulfill these requirements?

• A. Associate the Shipment to each parent record by using a VLOOKUP formula field.
• B. Create a required Lookup relationship to each of the three parent records.
• C. Create a Master-Detail relationship to each of the three parent records.
• D. Create two Master-Detail and one Lookup relationship to the parent records.

Question 2

Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-
time data migration, UC will need to keep the original date when a contact was created in the legacy
system. How should an Architect design the data migration solution to meet this requirement?

• A. After the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
• B. Create a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
• C. Enable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.
• D. Write an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.

Question 3

An architect has been asked to provide error messages when a future date is detected in a custom
Birthdate _c field on the Contact object. The client wants the ability to translate the error messages.
What are two approaches the architect should use to achieve this solution? Choose 2 answers
A.
Implement
a
third
-party
validation
process
with
translate
functionality.
B. Create a trigger on Contact and add an error to the record with a custom label.
C. Create a workflow field update to set the standard ErrorMessage field.
D. Create a validation rule and translate the error message with translation workbench.

Question 4

What is an advantage of using Custom metadata type over Custom setting?
A.
Custom
metadata
records
are
not
copied
from
production
to
sandbox.
B.
Custom
metadata
types
are
available
for
reporting.
C.
Custom
metadata
records
are
deployable
using
packages.
D. Custom metadata records are editable in Apex.

Question 5

Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is
that attachments associated with the Invoice_c custom object be classified by Types (i.e., ""Purchase
Order"", ""Receipt"", etc.) so that reporting can be performed on invoices showing the number of
attachments grouped by Type.
What should an Architect do to categorize the attachments to fulfill these requirements?

• A. Add additional options to the standard ContentType picklist field for the Attachment object.
• B. Add a ContentType picklist field to the Attachment layout and create additional picklist options.
• C. Create a custom picklist field for the Type on the standard Attachment object with the values.
• D. Create a custom object related to the Invoice object with a picklist field for the Type.

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
A.
Limitations
on
master
-detail
relationships.
B.
Org
data
storage
limitations.
C.
Bulk
API
limitations
on
picklist
fields.
D. Standard list view in -line editing.

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
answers
A.
Use
SOQL
queries
without
WHERE
conditions.
B.
Work
with
Salesforce
Support
to
enable
Skinny
Tables.
C.
Reduce
the
number
of
triggers
on
Order
_c
object.
D. Make the queries more selective using indexed fields.

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?
A.
Create
a
picklist
field,
values
sorted
alphabetically.
B.
Create
a
Master
-Detail
to
custom
object
ShippingStatus
c.
C.
Create
a
Lookup
to
custom
object
ShippingStatus
c.
D. Create a text field and make it an external ID.

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
answers

• A. 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.
• B. Write an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
• C. Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
• D. 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.

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?

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

Question 11

Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an
internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and
OData for bi-directional integration between Salesforce and the ERP system. UC has about one
million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have
requirements to view current invoice status and invoice amount from the opportunity page. When
creating an object to model invoices, what should the architect recommend, considering
performance
and
data
storage
space?

• A. Use Streaming API to get the current status from the ERP and display on the Opportunity page.
• B. Create an external object Invoice _x with a Lookup relationship with Opportunity.
• C. Create a custom object Invoice _c with a master -detail relationship with Opportunity.
• D. Create a custom object Invoice _c with a Lookup relationship with Opportunity.

Question 12

Universal Containers has a large number of Opportunity fields (100) that they want to track field
history on. Which two actions should an architect perform in order to meet this requirement?
Choose
answers

• A. Create a custom object to store a copy of the record when changed.
• B. Create a custom object to store the previous and new field values.
• C. Use Analytic Snapshots to store a copy of the record when changed.
• D. Select the 100 fields in the Opportunity Set History Tracking page.

Question 13

DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation?
(Choose two.)
A.
Use
the
private
sharing
model.
B.
Use
Salesforce
duplicate
management.
C.
Use
validation
rules
on
new
record
create
and
edit.
D. Use workflow to delete duplicate records.

Question 14

Universal Containers is looking to use Salesforce to manage their sales organization. They will be
migrating legacy account data from two aging systems into Salesforce. Which two design
considerations should an architect take to minimize data duplication? Choose 2 answers
A.
Use
a
workflow
to
check
and
prevent
duplicates.
B.
Clean
data
before
importing
to
Salesforce.
C.
Use
Salesforce
matching
and
duplicate
rules.
D. Import the data concurrently.

Question 15

Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have
noticed similar, but not identical. Account names and addresses. What should UC do to ensure
proper
data
quality?

• A. Use a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
• B. Run a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
• C. Enable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
• D. Make the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.