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.
Explanation: