Universals Containers’ system administrators have been complaining that they are not able to make changes to its users’ record, including moving them to new territories without getting “unable to lock row” errors. This is causing the system admins to spend hours updating user records every day. What should the data architect do to prevent the error?

A.

Reduce number of users updated concurrently.

B.

Enable granular locking.

C.

Analyze Splunk query to spot offending records.

D.

Increase CPU for the Salesforce org.

Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data, Currently, it has data backup processes that runs weekly, which back up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage. What should a data architect recommend for a daily backup and restore solution?

A.

Use AppExchange package for backup and restore.

B.

Use ETL for backup and restore from EDW.

C.

Use Bulk API to extract data on daily basis to EDW and REST API for restore.

D.

Change weekly backup process to daily backup, and implement a custom restore solution.

How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

A.

Remove "customize application" permissions from everyone else.

B.

Export the metadata and search it for the fields in question.

C.

Create a field history report for the fields in question.

D.

Export the setup audit trail and find the fields in question.

Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce. Which approach for data archiving is appropriate for this scenario?

A.

1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.

B.

1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.

C.

1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.

D.

1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.

Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC's Data Architect recommend to ensure scalability?

A.

Ensure invoice line items simply reference existing Opportunity line items.

B.

Ensure the account product vendor includes Wave Analytics in their offering.

C.

Ensure the account product vendor provides a sound data archiving strategy.

D.

Ensure the accounting product runs 100% natively on the Salesforce platform.

Universal Containers (UC) is building a Service Cloud call center application and has a multi-system support solution. UC would like or ensure that all systems have access to the same customer information. What solution should a data architect recommend?

A.

Make Salesforce the system of record for all data.

B.

Implement a master data management (MDM) strategy for customer data.

C.

Load customer data in all systems.

D.

Let each system be an owner of data it generates.

A company wants to document the data architecture of a Salesforce organization. What are two valid metadata types that should be included? (Choose two.)

A.

RecordType

B.

Document

C.

CustomField

D.

SecuritySettings

Due to security requirements, Universal Containers needs to capture specific user actions, such as login, logout, file attachment download, package install, etc. What is the recommended approach for defining a solution for this requirement?

A.

Use a field audit trail to capture field changes.

B.

Use a custom object and trigger to capture changes.

C.

Use Event Monitoring to capture these changes.

D.

Use a third-party AppExchange app to capture changes.

DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights. What are two approaches an Architect should recommend? (Choose two.)

A.

Weekly Snapshots

B.

Einstein Analytics

C.

Setup Audit Trails

D.

AppExchange Apps

A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting. What strategy should a data architect use to ensure a better user experience for the Sales Reps?

A.

Create a Permission Set to hide old data from Sales Reps.

B.

Use Batch Apex to archive old data on a rolling nightly basis.

C.

Archive and purge old data from Salesforce on a monthly basis.

D.

Set data access to Private to hide old data from Sales Reps.