SF-Data-Arch Salesforce Data Management Practice Question
A Data Architect is designing a data retention policy for a custom object that stores transaction records. The object has a master-detail relationship to Account and contains over 50 million records. The business requires that records older than 7 years be automatically deleted, but they must be archived first for compliance. Which approach should the architect recommend?
⚠ Common exam trap
The trap here is thinking that declarative tools like workflow rules can delete records, but they cannot perform deletions.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use a scheduled batch Apex job that exports records to an external system and then deletes them from Salesforce.
A scheduled batch Apex job is the most appropriate solution because it can automate the export of old records to an external archive and then delete them from Salesforce. Batch Apex is designed for processing large data volumes and can be scheduled to run regularly. This approach ensures compliance with the retention policy and offloads data to reduce storage costs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Configure a time-based workflow rule to delete records after 7 years.
Why it's wrong here
Time-based workflow rules can trigger actions based on time, but they cannot delete records directly. They can only update fields or send notifications. Also, workflow rules have limits on the number of records and are not designed for bulk deletion of millions of records. This approach would not meet the archiving requirement.
- ✗
Create a formula field that flags records older than 7 years and use a sharing rule to hide them.
Why it's wrong here
Formula fields and sharing rules do not delete records. They can only flag or restrict access. This approach would leave the records in the system, consuming storage and potentially violating the retention policy that requires deletion after archiving. It does not address the archiving requirement either.
- ✓
Use a scheduled batch Apex job that exports records to an external system and then deletes them from Salesforce.
Why this is correct
A scheduled batch Apex job can query records older than 7 years, export them to an external archive via callouts or middleware, and then delete them. This meets the archiving and deletion requirements. It is a scalable solution for large data volumes and can be scheduled to run during off-peak hours.
- ✗
Use the Data Loader to manually export and delete records every quarter.
Why it's wrong here
Data Loader is a client-side tool that requires manual intervention and cannot be scheduled natively. It is not suitable for automating a retention policy on a large scale. Manually exporting and deleting millions of records every quarter is error-prone and does not provide the reliability needed for compliance.
About these practice questions
One of 222 original SF-Data-Arch practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Data-Arch practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Data-Arch exam.