Question 1

How are full and differential database backups used?

Accepted Answer

A) a differential backup is followed by one or more full backups 
B) full backups copy data that has changed since the last differential backup 
C) differential backups are usually performed more often than full backups 
D) differential backups are more resource intensive than full backups

Question 2

List four business requirements factors that should be evaluated for each production user and system database.

Accepted Answer

The answer of List four business requirements factors that should...

Question 3

The rate at which a database changes will determine the ___________ with which backups must occur in order to minimize data loss

Accepted Answer

The answer of The rate at which a database changes...

Question 4

Which category of risk has the highest probability of occurrence? Explain your answer.

Accepted Answer

The answer of Which category of risk has the highest...

Question 5

What is the importance of the transaction log tail in transaction log backups?

Accepted Answer

The answer of What is the importance of the transaction...

Question 6

What is a checksum and how is it used with a database backup?

Accepted Answer

The answer of What is a checksum and how is...

Question 7

List the four commonly used types of backup plans.

Accepted Answer

The answer of List the four commonly used types of...

Question 8

What is a full database backup?

Accepted Answer

The answer of What is a full database backup?...

Question 9

Describe the two types of recovery objectives you should build for each production database under different risk scenarios.

Accepted Answer

The answer of Describe the two types of recovery objectives...

Question 10

In which risk category would an incompatibility between SQL Server and Windows be considered?

Accepted Answer

A) user error 
B) hardware failure 
C) system software failure 
D) environmental events

Question 11

Which of the following is true about recovery objectives?

Accepted Answer

A) they should be the same for each database 
B) the RTO is usually the same whether the recovery scenario involves one or many databases 
C) the RTO is the maximum amount of data that may be lost 
D) the recovery point objective is expressed as a time frame

Question 12

Backup sets can be assigned a(n)____________ date, which helps to ensure that existing backups on the media will not be overwritten until a specified time in the future.

Accepted Answer

The answer of Backup sets can be assigned a(n)____________ date,...

Question 13

After you devise a backup plan, you should do a risk assessment.

Accepted Answer

A) True 
 B)False

Question 14

What SQL command do you use when restoring transaction logs if you want to do a point-in-time restore?

Accepted Answer

A) TIMELOG 
B) TRANSACT 
C) STOPAT 
D) NOTAFTER

Question 15

Which of the following is true about the factors that should be considered when evaluating database business requirements and the associated risk assessments?

Accepted Answer

A) mission-critical systems provide administrators with a large time window for performing maintenance 
B) databases that have a high change rate require more frequent backups 
C) for best performance, backups should be done when the system is under peak load 
D) a single large database is usually easier to maintain than several smaller databases

Question 16

Which of the following is NOT a commonly used type of backup plan?

Accepted Answer

A) Full database backup, simple recovery model 
B) Single transaction log backup plus simple recovery model 
C) Single transaction log backup plus full database backup 
D) Full database backup plus multiple transaction log backups

Exam 8: Backup and Recovery