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.)
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.