PrepAway - Latest Free Exam Questions & Answers

Tag: how could you include the driver in the image using the least amount of administrative effort

Which method should you use to perform the tasks by using the least administrative effort?

You are a database administrator for Verigon Corporation. You maintain all the SQL Server 2008 databases forthe company. The company receives data regarding the processed orders from the various branches of thecompany. After the data is verified by the audit department, the appropriate tables in the database are updatedwith the data by 6 A.M. You are required to perform the following tasks after the tables have been updated:
? Rebuild the indexes in the tables at 8:00 A.M.
? Update the statistics for the tables and indexes in the database at 10:00 P.M.
? Perform a differential backup of the database at 7:00 P.M.
Which method should you use to perform the tasks by using the least administrative effort?