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

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.

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.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


yuri

yuri

.. unfortunately option ‘G’ contains wrong expression ‘every three hours’
-> wording should be adapted to ‘every hour’