Exam 70-764 topic 1 question 163 discussion

Actual exam question from Microsoft's 70-764

Question #: 163
Topic #: 1

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 requirements:
✑ Perform a transaction log backup every hour.
✑ Perform a full backup of each database every week.
✑ Perform a differential backup of each database every day.
✑ Ensure that new user databases are added automatically to the backup solution.
What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.

A. A maintenance plan
B. SQL Server Agent jobs
C. Policy-Based Management
D. A Data Definition Language (DDL) trigger

Show Suggested Answer

Suggested Answer: A 🗳️
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.

by TheSwedishGuy at Jan. 29, 2020, 2:49 p.m.

Comments

Submit Cancel

TheSwedishGuy

Highly Voted 5 years, 5 months ago

Maintenance Plans lets you make schedules and plans for common DBA tasks. When creating a maintenance plan it's possible to select which databases this is supposed to be performed on. There you can select "All databases", meaning any new databases will have this maintenance plan as well. https://www.mssqltips.com/sqlservertip/6099/getting-started-with-sql-server-maintenance-plans--part-1/

upvoted 5 times

...