Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?

• A. Reduce data storage by purging old data.
• B. Implement an AppExchange package.
• C. Schedule a weekly export file.
• D. Review projected data storage needs.

Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

• A. Use Formula fields to surface information I related entities on the report.
• B. Use an indexed data field with bounded data filters.
• C. Use unbounded date ranges to filter the report.
• D. Use triggers to populate denormalized related fields on the Account.

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 new records via the Insert operation and existing records via the Update operation.
• B. Delete all existing records, and then load all records together via the Insert operation.
• C. Load Contact records together using the Streaming API via the Upsert operation.
• D. Load all records via the Upsert operation to determine new records vs. existing records.

The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatID field:
Select id, description, Subject from Task where WhatId!= NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?

• A. Change query to SOSL.
• B. Add limit 100 to the query.
• C. Remove description from the requested field set.
• D. Change the where clause to filter by a deterministic defined value.

Universal Containers (UC) has 1,000 accounts and 50,000 opportunities. UC has an enterprise security requirement to export all sales data outside of Salesforce on a weekly basis. The security requirement also calls for exporting key operational data that includes events such as file downloads, logins, logouts, etc.
Which two recommended approaches would address the above requirement?

• A. Use Event Monitoring to extract event data to on-premise systems.
• B. Use a custom built extract job to extract operational data to on-premise systems.
• C. Use Field Audit History to capture operational data and extract it to on-premise systems.
• D. Use Weekly Export to extract transactional data to on-premise systems.