Salesforce data architecture and management designer practice test

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.

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.

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.

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.

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.

Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the
Accounting department with missing States and incorrectly formatted Postal Codes.
Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

• A. Change each address field to required on the Page Layout.
• B. Write an Apex Trigger to require all fields to be populated.
• C. Utilize a Validation Rule with a REGEX operator on Postal Code.
• D. Utilize a Validation Rule with a CONTAINS operator on address fields.

Universal Containers (UC) has multi -level account hierarchies that represent departments within
their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants
to clean the data so as to have a single Contact across departments. What two solutions should UC
implement
to
cleanse
their
data?
Choose
answers

• A. Make use of a third -party tool to help merge duplicate Contacts across Accounts.
• B. Use Data.com to standardize Contact address information to help identify duplicates.
• C. Use Workflow rules to standardize Contact information to identify and prevent duplicates.
• D. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.

Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know
how they can enforce it throughout the organization. Which two approaches should an architect
recommend
to
enforce
this
new
plan?
Choose
answers

• A. Schedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
• B. Use Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
• C. Schedule reports that will automatically catch duplicates and merge or delete the records every week.
• D. Store all data in an external system and set up an integration to Salesforce for view -only access.

Universal Containers wants to implement a data -quality process to monitor the data that users are
manually entering into the system through the Salesforce UI. Which approach should the architect
recommend?
A.
Allow
users
to
import
their
data
using
the
Salesforce
Import
tools.
B.
Utilize
a
3rd
-party
solution
from
the
AppExchange
for
data
uploads.
C. Utilize an app from the AppExchange to create data -quality dashboards.
D. Use Apex to validate the format of phone numbers and postal codes.

A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate
records.
Which two approaches should the manager take to achieve this goal? (Choose two.)

• A. Acquire an AppExchange Lead de-duplication application.
• B. Implement Salesforce Matching and Duplicate Rules.
• C. Run the Salesforce Lead Mass de-duplication tool.
• D. Create a Workflow Rule to check for duplicate records.