Salesforce Certified Data Architect — Question 22

Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data. Currently, it has data backup processes that runs weekly, which backs up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.
What should a data architect recommend for a daily backup and restore solution?

Answer options

• A. Change weekly backup process to daily backup, and implement a custom restore solution.
• B. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
• C. Use ETL tool for backup and restore from EDW.
• D. Use AppExchange package for backup and restore.

Correct answer: D

Explanation

The correct answer is D because AppExchange packages are specifically designed for Salesforce environments and often include features that facilitate both backup and restore processes seamlessly. Options A, B, and C do not provide the same level of integration and ease of use as an AppExchange solution, and may require more custom development or manual processes, which could introduce complexity and potential for error.