DATA-ARCHITECT practice question 28 of 35

Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?

Full set: 257 questions
Answer options
A: Use a Lead standard report and filter on the IsDeleted standard field.
B: Use a Converted Lead report to display data on Leads that have been deleted.
C: Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
D: Send data to a Data Warehouse and mark Leads as deleted in that system. Correct answer
Correct Answer:
D. Send data to a Data Warehouse and mark Leads as deleted in that system.
Explanation

Once a record is deleted and cleared from the Recycle Bin, it is permanently removed from Salesforce and cannot be recovered using platform tools like reports or queryAll. The only way to maintain this data is to implement an archival strategy. This involves extracting the data to an external system, such as a Data Warehouse, before it is deleted. In the external system, the record can be flagged as "deleted" while preserving its data for historical analysis or compliance purposes. This is a standard data governance and archival pattern.

Why Incorrect

A. Standard reports cannot access deleted records. The IsDeleted field is not available for filtering in standard reports.
B. A Converted Lead report shows leads that were successfully converted into Accounts and Contacts, which is a different lifecycle state from being deleted.
C. The queryAll API method and ALL ROWS SOQL keyword can only retrieve records that are soft-deleted (i.e., still in the Recycle Bin), not records that have been permanently purged.

References

1. Salesforce. (2021). Architect's Guide to Data Management. Salesforce Architects. "For data that must be retained long-term for compliance or other reasons, but is no longer actively used, consider an off-platform archival solution." (p. 12).

2. Salesforce Developer Documentation. SOQL and SOSL Reference: ALL ROWS. "Use ALL ROWS to query all records in an organization, including deleted records and archived activities. ... you can only use ALL ROWS in a top-level query." This confirms it only works for soft-deleted records.

3. Salesforce Help. (2023). View and Purge the Recycle Bin. "After records are permanently deleted, they can’t be recovered."

Scroll to Top