Question 1

Universal Containers (UC) has adopted Salesforce as its primary sales automated tool. UC has 100,00

customers with a growth rate of 10% a year, UC uses an on-premise web-based billing and invoice

system that generates over 1 million invoices a year supporting a monthly billing cycle.

The UC sales team needs to be able to pull a customer record and view their account status, Invoice

history, and opportunities without navigating outside of Salesforce.

What should a data architect use to provide the sales team with the required functionality?

Options :

A : Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout

B : Write an Apex callout and populate a related list to display on the account record

C : Create a mashup page that will present the billing system records within Salesforce.

D : Create a visual force tab with the billing system encapsulated within an iframe.

Answer: C

Question 2

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.)

Options :

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.

Answer: A,B

Question 3

Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

Options :

A : Ask sales people to search for populating company profile and location data

B : Run reports to identify records which does not have company profile and location data

C : Leverage external data providers populate company profile and location data

D : Export data out of Salesforce and send to another team to populate company profile and location data

Answer: B

Question 4

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is

facing query timeout issues while extracting these records.

What should a data architect recommend in order to get around the time out issue?

Options :

A : Use a custom auto number and formula field and use that to chunk records while extracting data.

B : The REST API to extract data as it automatically chunks records by 200.

C : Use ETL tool for extraction of records

D : Ask SF support to increase the query timeout value.

Answer: C

Question 5

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

Options :

A : How many fields are defined on the custom objects that need to be archived?

B : Which profiles and users currently have access to these custom object records?

C : If reporting is necessary, can the information be aggregated into fewer, summary records?

D : Will the data being archived need to be reported on or accessed in any way in the future?

E : Are there any regulatory restrictions that will influence the archiving and purging plans?

Answer: A,C,D

Free Data-Architect Mock Exam – Practice Online Confidently

Buying Options: