Plat-Arch-201 practice question 2 of 10
Cloud Kicks needs to purge detailed transactional records from Salesforce. The data should be aggregated at a summary level and available in Salesforce. What are two automated approaches to fulfill this goal? (Choose two.)
Full set: 257 questionsThe goal is to automate a process that aggregates detailed records into a summary, stores the summary in Salesforce, and purges the original details. A third-party ETL (Extract, Transform, Load) tool is designed for such data operations and can be scheduled to run automatically. It can extract data, perform the aggregation transformation, load the summary back, and then delete the source records. Schedulable Batch Apex is a native Salesforce solution for processing large data sets asynchronously. It can be coded to query records, calculate summaries, create summary records, and delete the detailed transactional records on a recurring schedule.
C. Third-party Business Intelligence system: BI systems are primarily for data analysis and visualization, not for data transformation and purging within the source system (Salesforce).
D. Apex Triggers: Triggers are not designed for large-scale, scheduled data processing. They execute on DML events and would be inefficient and likely hit governor limits.
1. Salesforce Developer Documentation, "Batch Apex". Batch Apex is designed for processing large numbers of records and can be scheduled. (See "Using Batch Apex" section).
2. Salesforce Developer Documentation, "Schedulable Interface". This interface allows developers to schedule Apex classes, such as a Batch Apex class, to run at a specific time.
3. Salesforce Architects, "Architect's Guide to Data Management". This guide discusses various data management strategies, including using ETL tools for data integration and archival processes (See "Data Archiving Strategies").
Keep practicing
Take the free Plat-Arch-201 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other Plat-Arch-201 practice questions
- Question 1Universal Containers (UC) wants to capture information on how data entities are stored wi…
- Question 3Universal Containers (UC) has multi -level account hierarchies that represent departments…
- Question 4Universal Containers has two systems. Salesforce and an on -premise ERP system. An archit…
- Question 5DreamHouse Realty has a Salesforce org that is used to manage Contacts. What are two thin…
- Question 6What is an advantage of using Custom metadata type over Custom setting?
- Question 7An architect has been asked to provide error messages when a future date is detected in a…
