Data-Architect Practice Test

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.