YOU ARE A PART-TIME DATABASE ADMINISTRATOR FOR A SMALL COMPANY THA...

11. You are a part-time database administrator for a small company that relies on its 3GB database for all business needs. You decide to implement a backup strategy of performing a full backup at 1:00 a.m. every night. What is the easiest way to implement your strategy?A. Open NTBACKUP from Start | Programs | Accessories | System Tools. Create the backup and schedule it to recur every day at 1:00 a.m.B. Use the BACKUP DATABASE Transact-SQL statement to create and schedule the backup job to recur every day at 1:00 a.m.C. Use the Backup Database wizard from SQL Server Management Studio to create the backup job and schedule it to recur every day at 1:00 a.m.D. Use the SQL Server Agent New Job wizard to create the backup job and schedule it to recur every day at 1:00 a.m.