Salesforce Certified Data Architect — Question 35

Universal Containers (UC) requires 2 years of customer related cases to be available on Salesforce for operational reporting. Any cases older than 2 years and up to 7 years need to be available on demand to service agents. UC creates 5 million cases per year.
Which two data archiving strategies should a data architect recommend? (Choose two.)

Answer options

• A. Sync cases older than 2 years to an external database and provide service agents access to the database.
• B. Use Custom objects for cases older than 2 years and use a nightly batch to move them.
• C. Use Heroku and external objects to display cases older than 2 years and the Bulk API to hard delete them from Salesforce.
• D. Use Big objects for cases older than 2 years and use a nightly batch to move them.

Correct answer: A, D

Explanation

Option A is correct because it allows for immediate access to older cases while offloading them from Salesforce. Option D is also correct as it effectively uses Big objects for large data storage while maintaining accessibility. Options B and C do not align with the need for immediate access or appropriate data management strategies for cases older than 2 years.