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 an ETL tool.
D.
Schedule jobs to export and delete using the Data Loader.
C.
Schedule jobs to export and delete using an ETL tool.
D.
Schedule jobs to export and delete using the Data Loader.
Explanation
Automation is key for millions of records. ETL tools (e.g., Informatica) and Data Loader CLI (Option D) support scheduled, automated exports/deletions via scripts or APIs. Manual exports (Options A/B) are unsustainable and error-prone. ETL tools handle complex transformations, logging, and error recovery. Data Loader CLI can be scripted via Bulk API for high-volume deletes. Steps:
Export data to cloud storage (e.g., AWS S3).
Delete records in batches to avoid governor limits.
Why not A/B?
UI exports (B) cap at 250k records, and Workbench (A) is manual. Both lack deletion automation.
Post-archive, use Big Objects or External Objects for rare access needs. This ensures compliance while freeing storage space.