Term
When planning disaster recovery operations for databases, which of the following statements would be true?
A) Backup requirements will differ depending on the requirements of the organization.
B) Backup requirements will NOT differ depending on the requirements of the organization.
C) Certain organizations do NOT need backup plans.
D) All Of The Above |
|
Definition
| A) Backup requirements will differ depending on the requirements of the organization. |
|
|
Term
When referring to SQL Server 2000 backup architecture, which of the following statements would be true?
A) SQL Server 2000 offers a rigid backup architecture.
B) SQL Server 2000 does NOT offer any backup architecture at all.
C) SQL Server 2000 offers a flexible backup architecture.
D) All Of The Above |
|
Definition
| C) SQL Server 2000 offers a flexible backup architecture. |
|
|
Term
Which of the following is NOT considered a backup operation for SQL Server 2000?
A) Transaction Log Backup
B) Differential Database Backup
C) Full Database Backup
D) Registry Recovery Backup |
|
Definition
| D) Registry recovery backup |
|
|
Term
Which of the following backup operations is the easiest to perform?
A) Transaction Log Backup
B) Differential Database Backup
C) Full Database Backup
D) All Of The Above |
|
Definition
|
|
Term
When deciding which backup operation to use, which of the following should be considered?
A) The time it takes to perform the operation
B) The amount of data loss that is acceptable within the system
C) The time it would take to restore the database to an operational status
D) All of the above |
|
Definition
|
|
Term
SQL Server 2000 optimizes the storage of a full backup by doing which of the following?
A) Performing file compression on the database
B) Only storing the data in the database itself
C) Splitting the database
D) All Of The Above |
|
Definition
| B) Only storing the data in the database itself |
|
|
Term
Which of the following backup types creates a full copy of all of the data in the database?
A) Backup Set
B) Transaction Log Backup
C) Differential Database Backup
D) Full Database Backup |
|
Definition
|
|
Term
Which of the following backup options takes the most time to perform?
A) Full Database Backup
B) Differential Database Backup
C) Transitional Database Backup
D) All Of The Above |
|
Definition
|
|
Term
Which of the following database backup options only backs up the data pages that have changed since the last full database backup was performed?
A) Tranaction Log Backup
B) Differential Database Backup
C) Automatic Recovery backup
D) Registry Backup |
|
Definition
| B) Differential Database Backup |
|
|
Term
Which of the following database options is typically scheduled more frequently?
A) Full Database Backup
B) Transaction Log Backup
C) Differential Database Backup
D) None Of The Above |
|
Definition
| B) Transaction log backup |
|
|
Term
Which of the following backup options allows the transaction log to be backed up?
A) Transaction Log Backup
B) Differential Backup
C) System Recovery Backup
D) Auto-Recovery Backup |
|
Definition
| A) Transaction Log Backup |
|
|
Term
Which of the following backup options uses fewer processor resources to complete the backup?
A) Transaction Log Backup
B) Full Database Backup
C) Differential Database Backup
D) None of the above |
|
Definition
| A) Transaction Log Backup |
|
|
Term
Which of the following statements would be considered true about a database?
A) It can reside on multiple physical drives
B) Files in the database can be grouped into an object called a filegroup
C) Both A & B
D) None Of The Above |
|
Definition
|
|
Term
A(n) ____ is chosen based on the needs of an individual database.
A) Database Model
B) Recovery Model
C) Bulk-logged Model
D) Simple Model |
|
Definition
|
|
Term
A recovery model addresses different needs including which of the following?
A) Minimizing data loss in the event of a failure.
B) The amount of disk space available to store backups.
C) Impacting performance on the system.
D) All Of The Above |
|
Definition
|
|
Term
Which of the following would NOT be an example of an SQL Server 2000 recovery model?
A) Registry Bulk-Logged
B) Simple
C) Full
D) Bulk-Logged |
|
Definition
|
|
Term
Which of the following recovery models permits high-performance bulk copy operations and requires minimal space usage?
A) Differential
B) Simple
C) Full
D) Bulk-logged |
|
Definition
|
|
Term
Which of the following recovery models prevents work loss due to a lost or damaged data file?
A) Simple
B) Full
C) Differential
D) Bulk-logged |
|
Definition
|
|
Term
The figure shown above depicts which of the following? ( photo of 7 full backup databases)
A) Simple recovery model performing full backups every day
B) Full recovery model performing full backups everyday.
C) Bulk-logged recovery model performing full backups everyday.
D) All Of The Above |
|
Definition
| A) Simple recovery model performing full backups everyday. |
|
|
Term
Which of the following recovery models can recover data to the end of any backup?
A) Simple
B) Full
C) Bulk-logged
D) None Of The Above |
|
Definition
|
|
