Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application.
Which two methods should be recommended to meet this requirement? Choose 2 answers

• A.Use the Force.com Workbench to export the data.
• B.Schedule a weekly export file from the Salesforce UI.
• C.Schedule jobs to export and delete using the Data Loader.
• D.Schedule jobs to export and delete using an ETL tool.

Comment: *

Name: *

Email: *

Verification: *

A Salesforce customer has millions of orders every year. Each order contains, on average, ten line items. The customer wants its Sales Reps to know how much money each customer generates year -over -year, but they are running out of data storage in Salesforce. What data archiving plan should the architect recommend?

• A.Annually delete orders and order line items and ensure the customer has order information in another system.
• B.Annually aggregate order amount data to store in a custom object, then delete those orders and order line items.
  c Annually export and delete orders and order line items and store them in a zip file in case the data is needed later.
• C.Annually export and delete order line items and store them in a zip file in case they data is needed later.

Comment: *

Name: *

Email: *

Verification: *

A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

• A.Create a formula field instead of having multiple filter criteria.
• B.Make sure the query doesn't contain NULL in any filter criteria.
• C.Modify the integration users' profile to have View All Data.
• D.Create custom indexes on the fields used in the filter criteria.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when de-normalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

• A.Bulk API limitations on picklist fields.
• B.Limitations on master -detail relationships.
• C.Org data storage limitations.
• D.Standard list view in-line editing.

Comment: *

Name: *

Email: *

Verification: *

UC is implementing sales cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?

• A.Store files outside of salesforce and access them to real time.
• B.Use classic encryption to encrypt files.
• C.Implement 3rd party App Exchange app to encrypt files.
• D.Implement shield platform encryption to encrypt files.

Comment: *

Name: *

Email: *

Verification: *