DP-300 Certification Practice Question #284

Question

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.
What should you include in the plan?

Accepted Answer

The security and compliance requirement is to retain database backups for a set period (e.g., two months) beyond the default service tier retention. On an Azure SQL Database PaaS solution, this is accomplished by configuring the long-term backup retention (LTR) policy under the logical server's "Backups" settings — exposed in the portal as "Manage Backups" / "Retention policies". ResearchSrv01 is the logical server for ResearchDB1, so configuring the server's Manage Backups settings is the correct action. Suggested Answer, Most Voted, and all substantive community comments agree. No dissent exists.

More DP-300 practice questions