PrepAway - Latest Free Exam Questions & Answers

How should you configure the backup solution?

You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. The sales and marketing departments contain a total of 60 users. Each user
uses a custom application that stores data in a SQL Server database. Each user has a separate database. A
server named ABC-SQL1 hosts the 60 databases. You need to configure a backup solution for all the
databases. The solution must ensure that any new databases configured on ABC-SQL1 are automatically
added to the backup schedule. The backup schedule consists of a full backup every night, a differential backup
every hour and a transaction log backup every 15 minutes. How should you configure the backup solution?

PrepAway - Latest Free Exam Questions & Answers

A.
You should configure SQL Server Agent jobs.

B.
You should configure Change Data Capture.

C.
You should configure Policy-Based Management.

D.
You should configure a Maintenance Plan.


Leave a Reply