Question 1

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 2

Company S was recently acquired by Company T. As part of the acquisition, all of the data for the

Company S's Salesforce instance (source) must be migrated into the Company T's Salesforce instance

(target). Company S has 6 million Case records.

An Architect has been tasked with optimizing the data load time.

What should the Architect consider to achieve this goal?

Options :

A : Pre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.

B : Directly leverage Salesforce-to-Salesforce functionality to load Case data.

C : Load the data in multiple sets using Bulk API parallel processes

D : Utilize the Salesforce Org Migration Tool from the Setup Data Management menu.

Answer: A

Question 3

UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor

and measure data quality.

Which 2 solutions should a data architect recommend to monitor and measure data quality?

Choose 2 answers.

Options :

A : Use custom objects and fields to identify issues.

B : Review data quality reports and dashboards.

C : Install and run data quality analysis dashboard app

D : Export data and check for data completeness outside of Salesforce.

Answer: B,C

Question 4

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 5

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

Higher Test Marks with Free Online Data-Architect Exam Practice

Buying Options: