Multiple choice technology databases

What tool should you recommend for a junior DBA to use to create a simple backup strategy for a database?

  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Database Maintenance Plan Wizard is the standard SQL Server tool designed for administrators to easily configure common database maintenance tasks, including backup strategies. Database Engine Tuning Advisor, Configuration Manager, and general design surfaces do not serve as guided backup strategy wizards.

Keep practicing — related questions