PrepAway - Latest Free Exam Questions & Answers

How can you setup a backup service while also making sure that minimum disk space is used?

You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 instance that contains a database named TK_DB. TK_DB have 200 GB information
where 3 GB of the information is changed daily. TK_DB has its recovery model set for
Simple. However, TestKing.com states that data loss of more than one hour for transactions
during business hours is a NO – NO.

How can you setup a backup service while also making sure that minimum disk space is
used? (Select two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Run a daily incremental backup during non-office hours.

B.
Run a daily hybrid backup during non-office hours.

C.
Run a daily full backup during non-office hours.

D.
Run a daily differential backup during non-office hours.

E.
Run a daily transactional log backup during non-office hours.

F.
Run a transaction log backup every three hours during business hours.

G.
Run a differential backup every three hours during business hours.

H.
Run a full backup every three hours during business hours.

I.
Run a hybrid backup every three hours during business hours.

J.
Run a incremental backup every three hours during business hours.
K.
Only one action is required.

Explanation:
A large percentage of the database is changed daily. It is therefore better to use differential
backups during the office hours compared to the standard transactional backups.


Leave a Reply