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 Maintenance Plan Wizard

  2. Database Engine Tuning Advisor

  3. SQL Server Configuration Manager

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

The Database Maintenance Plan Wizard is a user-friendly tool built into SQL Server Management Studio designed to guide DBAs through setting up routine maintenance tasks, including backups. The Engine Tuning Advisor optimizes index performance, and Configuration Manager manages network protocols.

Keep practicing — related questions