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 specifically designed to help DBAs create comprehensive maintenance plans including backup strategies. Database Engine Tuning Advisor is for performance tuning, SQL Server Configuration Manager is for server configuration, and the design surface requires more advanced knowledge.

Keep practicing — related questions