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 questionsOnce 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.
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.
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."
Keep practicing
Take the free DATA-ARCHITECT practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DATA-ARCHITECT practice questions
- Question 1Which three characteristics of a skinny table help improve report and query performance?
- Question 2Universal Containers (UC) has built a custom application on Salesforce to help track ship…
- Question 3Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not …
- Question 4Universal Container (UC) has accumulated data over years and has never deleted data from …
- Question 5Universals Containers’ system administrators have been complaining that they are not able…
- Question 6Universal Containers is experiencing frequent and persistent group membership locking iss…
