Multiple choice technology databases

What tool should you recommend for a junior DBA to use to create a simple backup strategy for a SQL Server 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 designed specifically for junior DBAs to create backup strategies, maintenance tasks, and other database management plans through a guided interface. The Database Engine Tuning Advisor is for query optimization, Configuration Manager manages services, and the design surface is for advanced manual configuration.

Keep practicing — related questions