Salesforce Certified Advanced Administrator — Question 117

Cloud Kicks is looking for a way to back up its data daily.

What should the administrator recommend?

Answer options

• A. Schedule a report and have the data emailed to the admin to put in the target destination.
• B. Extract the data with the Import Wizard and push it to the target destination.
• C. Set up Salesforce’s Data Export Service and store the data in the target destination.
• D. Use an ETL tool that can be scheduled to extract the data and push it to the target destination.

Correct answer: D

Explanation

The correct answer is D because an ETL tool can automate the extraction and loading of data, ensuring daily backups without manual intervention. Options A and B require manual steps, which are not efficient for daily backups, while option C, although useful, may not provide the scheduling flexibility needed for daily operations.