Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:
1. High Value
2. Medium Value
3. Low Value
Which strategy should a data architect recommend to configure customer type?

A.

Lookup to a custom object with defined choices.

B.

Single-select restricted picklist with defined choices.

C.

Provide help text to guide users with defined choices.

D.

Create a validation rule to limit entry to defined choices.

Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

A.

Use scheduled batch Apex to copy aggregate information into a custom object and delete the original records.

B.

Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.

C.

Use Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.

D.

Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.

NTO would like to retrieve their SF orgs meta data programmatically for backup within a various external. Which API is the best fit for accomplishing this task?

A.

Metadata API

B.

Tooling API

C.

Bulk API in serial mode

D.

SOAP API

For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load. Which two recommended options assign Account ownership to mitigate potential performance problems?

A.

Let a “system user” own all the Account records without assigning any role to this user in Role Hierarchy.

B.

Let a “system user” own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

C.

Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.

D.

Let a “system user” own all the Account records and make this user part of the highestlevel role in the Role Hierarchy.

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

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.

Universal Containers has been a customer of Salesforce for 10 years. Currently they have 2 million accounts in the system. Due to an erroneous integration built 3 years ago, it is estimated there are 500,000 duplicates in the system. Which solution should a data architect recommend to remediate the duplication issue?

A.

Develop an ETL process that utilizers the merge API to merge the duplicate records

B.

Utilize a data warehouse as the system of truth

C.

Extract the data using data loader and use excel to merge the duplicate records

D.

Implement duplicate rules

Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?

A.

Load Contact records together using the Streaming API via the Upsert operation.

B.

Delete all existing records, and then load all records together via the Insert operation.

C.

Load all records via the Upsert operation to determine new records vs. existing records.

D.

Load new records via the Insert operation and existing records via the Update operation.

Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?

A.

use as ETL tool to orchestrate the migration.

B.

Use Data Loader for export and Data Import Wizard for import

C.

Write a script to use the Bulk API

D.

Use the Salesforces CLI to query, export, and import

A custom pricing engine for a Salesforce customer has to be decided by factors with the following hierarchy:
State in which the customer is located
City in which the customer is located if available
Zip code in which the customer is located if available
Changes to this information should have minimum code changes
What should a data architect recommend to maintain this information for the custom pricing engine that is to be built in Salesforce?

A.

Create a custom object to maintain the pricing criteria.

B.

Assign the pricing criteria within customer pricing engine.

C.

Maintain require pricing criteria in custom metadata types.

D.

Configure the pricing criteria in price books.

Which two aspects of data does an Enterprise data governance program aim to improve?

A.

Data integrity

B.

Data distribution

C.

Data usability

D.

Data modeling