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 provides a step-by-step interface specifically designed for creating backup and maintenance plans. It is the most appropriate tool for a junior DBA because it simplifies the process of creating a reliable backup strategy. Database Engine Tuning Advisor is for query optimization, and Configuration Manager manages server services.

Keep practicing — related questions