You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. ABC_DB have 200 GB information where 3
GB of the information is changed daily. ABC_DB has its recovery model set for Simple. However,
ABC.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.
.. unfortunately option ‘G’ contains wrong expression ‘every three hours’
-> wording should be adapted to ‘every hour’