Question 1 of 30
A company has implemented automated backups for its Azure SQL Database, which runs critical applications. The backup policy is configured to retain daily backups for 30 days and weekly backups for 12 weeks. The company also requires that certain backups be retained for long-term compliance purposes, specifically for 7 years. If the company needs to restore the database to a point in time exactly 45 days ago, which of the following statements accurately describes the implications of their current backup strategy?
The company will not be able to restore the database to that point in time due to the retention policy limitations.
The company can restore the database to that point in time using the weekly backups.
The company can restore the database to that point in time using the automated daily backups.
The company can restore the database to that point in time using the long-term retention backups.

Preparing for Microsoft DP-300 Administering Relational Databases on Microsoft Azure? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free