70-465 · Question #32
You have a server that has SQL Server 2014 installed. The server contains 100 user databases. You need to recommend a backup solution for the user databases. The solution must meet the following…
The correct answer is A. A maintenance plan. Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies. Maintenance plans can be created to perform the following task (among others): Back up the database and transaction log…
Question
Options
- AA maintenance plan
- BSQL Server Agent jobs
- CPolicy-Based Management
- DA Data Definition Language (DDL) trigger
How the community answered
(53 responses)- A83% (44)
- B6% (3)
- C9% (5)
- D2% (1)
Explanation
Maintenance plans create a workflow of the tasks required to make sure that your database is optimized, regularly backed up, and free of inconsistencies. Maintenance plans can be created to perform the following task (among others): Back up the database and transaction log files. Database and log backups can be retained for a specified period. This lets you create a history of backups to be used if you have to restore the database to a time earlier than the last database backup. You can also perform differential backups.
Topics
Community Discussion
No community discussion yet for this question.