PrepAway - Latest Free Exam Questions & Answers

Which of the following actions should you take?

You work as a database administrator at ABC.com. The ABC.com network consists of a single
domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
ABC.com has a Storage Area Network that hosts a Sales database. The data file of the Sales
database is 1 TB in size, and is stored on a dedicated LUN that only has 500 GB of useable space

left. The transaction log of the Sales database is 5 GB in size, and is stored on a dedicated LUN
that only has 2.5 GB of useable space left.
A full backup is configured to occur weekly on a Sunday at 10 AM. You have been instructed to
configure backups to occur at 3 hour intervals on a daily basis, Monday to Friday. The first daily
backup should occur at 8 AM, and the last should be at 5 PM. Furthermore, you are informed that
the backups should be minimal in size.
Which of the following actions should you take?

PrepAway - Latest Free Exam Questions & Answers

A.
You should consider configuring the use of incremental backups.

B.
You should consider configuring the use of differential backups.

C.
You should consider configuring the use of NO_CHECKSUM backups.

D.
You should consider configuring the use of snapshot backups.

Explanation:

One Comment on “Which of the following actions should you take?


Leave a Reply