Question 1

Which category of risk has the highest probability of occurrence?&#10;A)user error&#10;B)hardware failure&#10;C)system software failure&#10;D)environmental events

Accepted Answer

User error has the highest probability of occurrence as it can happen due to lack of awareness, training or mistake while performing a task. Hardware failure, system software failure and environmental events are less likely to occur on a regular basis.

Question 2

Which of the following is true about backup sets?&#10;A)backup sets are usually stored to the same media as the database log&#10;B)when the expiration date on a backup set passes, the data is no longer usable&#10;C)backups made to tape are preferable to using disks due to better performance&#10;D)a backup device references a physical location where backup sets are stored

Accepted Answer

A backup device references a physical location such as a tape or disk where backup sets are stored. Option A is incorrect because it is generally recommended to store backup sets on a separate media than the database log. Option B is not entirely true as expired backup sets may still be readable, but they may not be reliable or recommended for use in a restore. Option C is not necessarily true as the performance of backups to tape or disk may depend on various factors such as hardware and software configurations.

Question 3

If you experience database corruption, what should you do before performing a restore operation?&#10;A)backup the transaction log tail&#10;B)restore the head of the transaction log&#10;C)perform a fresh full backup&#10;D)check the physical integrity of the database

Accepted Answer

Before performing a restore operation, it's important to backup the transaction log tail to ensure that you capture any transactions that occurred after the last backup, minimizing data loss.

Question 4

How are full and differential database backups used?&#10;A)a differential backup is followed by one or more full backups&#10;B)full backups copy data that has changed since the last differential backup&#10;C)differential backups are usually performed more often than full backups&#10;D)differential backups are more resource intensive than full backups

Accepted Answer

Differential backups are typically performed more frequently than full backups because they only capture data that has changed since the last full backup, making them quicker and less resource-intensive.

Question 5

The AwlaysOn capabilities of SQL Server 2012 effectively replace the need to perform traditional backups.

Accepted Answer

While AlwaysOn provides high availability and disaster recovery capabilities, it should not be relied upon as a replacement for traditional backups. Backups are still necessary to protect against human error, data corruption, and other potential issues.

Question 6

Which of the following is NOT a commonly used type of backup plan?&#10;A)Full database backup, simple recovery model&#10;B)Single transaction log backup plus simple recovery model&#10;C)Single transaction log backup plus full database backup&#10;D)Full database backup plus multiple transaction log backups

Accepted Answer

Single transaction log backup plus simple recovery model is not a commonly used type of backup plan. This type of backup plan does not provide complete data recovery in case of a system failure or data loss. The other options (A, C, D) are commonly used types of backup plans and provide more comprehensive protection for data.

Question 7

What SQL command do you use when restoring transaction logs if you want to do a point-in-time restore?&#10;A)TIMELOG&#10;B)TRANSACT&#10;C)STOPAT&#10;D)NOTAFTER

Accepted Answer

The correct SQL command for performing a point-in-time restore of transaction logs is "STOPAT". This command allows you to specify the exact point in time to which the database should be restored.

Question 8

Which of the following SQL commands should you perform in a database recovery operation right before you check the logical and physical integrity of the database?&#10;A)RESTORE DATABASE FROM WITH NORECOVERY;&#10;B)RESTORE LOG FROM WITH FILE = n WITH NORECOVERY;&#10;C)RESTORE DATABASE FROM WITH NORECOVERY;&#10;D)RESTORE DATABASE WITH RECOVERY;

Accepted Answer

The answer of Which of the following SQL commands should...

Question 9

Transaction logs are required in the event that a database needs to be restored back to a specific point in time.

Accepted Answer

Transaction logs record all changes made to a database and are used during the restore process to roll forward or roll back to a specific point in time. Without transaction logs, it would be impossible to accurately restore a database to a particular point in time.

Question 10

Which recovery model causes all changes to the database to be written to the transaction log?&#10;A)simple recovery model&#10;B)full recovery model&#10;C)bulk logged recovery model&#10;D)truncated recovery model

Accepted Answer

The full recovery model causes all changes to the database to be written to the transaction log. This allows for point-in-time recovery and the ability to restore to a specific point in time, which is not possible with the simple or bulk logged recovery models. The truncated recovery model is not a valid recovery model option.

Question 11

Which backup scheme reduces the amount of downtime to perform a restore but creates additional IT management and physical resource overhead?&#10;A)Full database backup plus differential database backup plus multiple transaction log backups&#10;B)Single transaction log backup plus full database backup&#10;C)Full database backup plus multiple transaction log backups&#10;D)Single transaction log backup plus simple recovery model

Accepted Answer

The answer of Which backup scheme reduces the amount of...

Question 12

Which of the following is true about the factors that should be considered when evaluating database business requirements and the associated risk assessments?&#10;A)mission-critical systems provide administrators with a large time window for performing maintenance&#10;B)databases that have a high change rate require more frequent backups&#10;C)for best performance, backups should be done when the system is under peak load&#10;D)a single large database is usually easier to maintain than several smaller databases

Accepted Answer

The answer of Which of the following is true about...

Question 13

Which of the following is true about recovery objectives?&#10;A)they should be the same for each database&#10;B)the RTO is usually the same whether the recovery scenario involves one or many databases&#10;C)the RTO is the maximum amount of data that may be lost&#10;D)the recovery point objective is expressed as a time frame

Accepted Answer

The answer of Which of the following is true about...

Question 14

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

Accepted Answer

The answer of After you devise a backup plan, you...

Question 15

Which of the following is a reason that transaction logs must be backed up frequently?&#10;A)so you don't have to spend time backing up data files&#10;B)frequent backups increase the likelihood of a corrupt active transaction log&#10;C)when the log is backed up, it is truncated&#10;D)the tail of the log increases each time the log is backed up

Accepted Answer

The answer of Which of the following is a reason...

Question 16

In which risk category would an incompatibility between SQL Server and Windows be considered?&#10;A)user error&#10;B)hardware failure&#10;C)system software failure&#10;D)environmental events

Accepted Answer

The answer of In which risk category would an incompatibility...

Question 17

Data loss caused by environmental events has the greatest possibility of occurrence.

Accepted Answer

The answer of Data loss caused by environmental events has...

Question 18

Which of the following is NOT among the three primary factors that should be considered for each risk scenario identified?&#10;A)probability of occurrence&#10;B)personnel involved in the scenario&#10;C)magnitude of the impact&#10;D)difficulty of timely detection

Accepted Answer

The answer of Which of the following is NOT among...

Question 19

Which of the following is true about database backup types?&#10;A)backups can be performed when a database is offline&#10;B)backups cannot be performed when a database is online&#10;C)SQL Server 2012 databases can only be backed up using Object Explorer&#10;D)incremental backups can be performed using the BackUp Database dialog box

Accepted Answer

The answer of Which of the following is true about...

Question 20

SQL Server 2012 can back up database files to physical disk media or to tape.

Accepted Answer

The answer of SQL Server 2012 can back up database...

Question 21

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 22

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 23

Match between columns&#10;                        Premises: a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a process undertaken to identify and objectively quantify all potential data loss scenarios&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;the active transaction log that contains the database changes since the last transaction log backup&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a process that occurs each time a database is backed up; causes space to be made available in the active transaction log for recording new activity&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;a recovery model setting that causes the database engine not to record any events in the transaction log&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;the file that is the result of a backup operation&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a type of database backup in which a database backup is broken into smaller units for performance reasons&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time&#10;a database log that records changes that occur to the data in a database over time

Accepted Answer

The Answer of simple recovery model and transaction logs and is...

Question 24

What is a differential database backup?

Accepted Answer

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

Question 25

_____________ logs record changes that occur to the data in a database over time.

Accepted Answer

The answer of _____________ logs record changes that occur to...

Question 26

What is a full database backup?

Accepted Answer

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

Question 27

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 28

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 29

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 30

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 31

The output of a __________ assessment is used to prioritize the allocation of resources in the most effective manner possible.

Accepted Answer

The answer of The output of a __________ assessment is...

Question 32

List the sequence of tasks you should perform to recover a database using backups.

Accepted Answer

The answer of List the sequence of tasks you should...

Question 33

By undertaking an assessment of the risk factors and business requirements, you can build a set of ____________ objectives for each production database under different risk scenarios.

Accepted Answer

The answer of By undertaking an assessment of the risk...

Question 34

List the four commonly used types of backup plans.

Accepted Answer

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

Question 35

What is the bulk logged recovery model an what type of restores does it support?

Accepted Answer

The answer of What is the bulk logged recovery model...

Question 36

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

Deck 8: Backup and Recovery