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?
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.