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.

Explanation:


Leave a Reply