Salesforce Certified Data Architecture Practice Test

What methods should be recommended for automatically archiving all inactive Account data older than 3 years?

1. Use the Force.com Workbench to export the data

2. Schedule a weekly export file from Salesforce UI

3. Schedule jobs to export and delete using an ETL tool

4. Schedule jobs to export and delete using the Data Loader

The correct answer is: Schedule jobs to export and delete using an ETL tool

Using an ETL (Extract, Transform, Load) tool to schedule jobs for exporting and deleting inactive Account data older than three years is the most effective method in this scenario for several reasons. Firstly, ETL tools are designed specifically for handling large volumes of data and can manage both data extraction and transformation processes efficiently. This is particularly important when dealing with inactive records, as it allows for complex filtering and validation to identify which records should be archived based on specific criteria, such as age and activity status. Secondly, ETL tools often come with automation capabilities that facilitate scheduling regular jobs, streamlining the archiving process without requiring manual intervention. This ensures that the archiving process is consistent and reliable over time, minimizing the risk of human error and ensuring that data management practices align with retention policies. In contrast, using the Salesforce UI for scheduled exports might not offer the same level of flexibility or automation required for this task. While it can handle data exports, it lacks the capability to perform bulk deletes automatically after archiving, which is a critical component of the overall process of managing inactive accounts. The Data Loader can indeed be used for data exports and deletions, but it generally requires manual scheduling unless additional scripts are created to automate the process. This could