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.
Answer: D
Latest 70-764 Dumps Valid Version with 451 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund