Question 1

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

Accepted Answer

risk

Question 2

Which of the following is true about backup sets?

Accepted Answer

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

Question 3

Which of the following is NOT among the three primary factors that should be considered for each risk scenario identified?

Accepted Answer

A) probability of occurrence 
B) personnel involved in the scenario 
C) magnitude of the impact 
D) difficulty of timely detection 
A) probability of occurrence 
B) personnel involved in the scenario 
C) magnitude of the impact 
D) difficulty of timely detection B

Question 4

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?

Accepted Answer

A) RESTORE DATABASE FROM WITH NORECOVERY; 
B) RESTORE LOG FROM WITH FILE = n WITH NORECOVERY; 
C) RESTORE DATABASE FROM WITH NORECOVERY;. 
D) RESTORE DATABASE WITH RECOVERY; 
A) RESTORE DATABASE FROM WITH NORECOVERY; 
B) RESTORE LOG FROM WITH FILE = n WITH NORECOVERY; 
C) RESTORE DATABASE FROM WITH NORECOVERY;. 
D) RESTORE DATABASE WITH RECOVERY;

Question 5

Which recovery model causes all changes to the database to be written to the transaction log?

Accepted Answer

A) simple recovery model 
B) full recovery model 
C) bulk logged recovery model 
D) truncated recovery model 
A) simple recovery model 
B) full recovery model 
C) bulk logged recovery model 
D) truncated recovery model

Question 6

Match between columns
                        Premises: a process undertaken to identify and objectively quantify all potential data loss scenarios
a type of configuration setting that specifies which type of database transactions should be recorded in the transaction log
the active transaction log that contains the database changes since the last transaction log backup
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
a recovery model setting that causes the database engine not to record any events in the transaction log
the file that is the result of a backup operation
a unique variable that is computed based on the data contained in a page and used to verify the integrity of that data
a type of database backup in which only data in the primary filegroup and read-write filegroups are backed up by default
a type of database backup in which a database backup is broken into smaller units for performance reasons
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 risk assessment and is...

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

_____________ 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 9

If you experience database corruption, what should you do before performing a restore operation?

Accepted Answer

A) backup the transaction log tail 
B) restore the head of the transaction log 
C) perform a fresh full backup 
D) check the physical integrity of the database 
A) backup the transaction log tail 
B) restore the head of the transaction log 
C) perform a fresh full backup 
D) check the physical integrity of the database

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

What is a differential database backup?

Accepted Answer

A differential database backup only copi

Question 13

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

Accepted Answer

Restore full database backup R

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is a reason that transaction logs must be backed up frequently?

Accepted Answer

A) so you don't have to spend time backing up data files 
B) frequent backups increase the likelihood of a corrupt active transaction log 
C) when the log is backed up, it is truncated 
D) the tail of the log increases each time the log is backed up 
A) so you don't have to spend time backing up data files 
B) frequent backups increase the likelihood of a corrupt active transaction log 
C) when the log is backed up, it is truncated 
D) the tail of the log increases each time the log is backed up

Question 16

Which category of risk has the highest probability of occurrence?

Accepted Answer

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

Question 17

Which of the following is true about database backup types?

Accepted Answer

A) backups can be performed when a database is offline 
B) backups cannot be performed when a database is online 
C) SQL Server 2012 databases can only be backed up using Object Explorer 
D) incremental backups can be performed using the BackUp Database dialog box 
A) backups can be performed when a database is offline 
B) backups cannot be performed when a database is online 
C) SQL Server 2012 databases can only be backed up using Object Explorer 
D) incremental backups can be performed using the BackUp Database dialog box

Question 18

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

Accepted Answer

The bulk logged recovery model sits betw

Question 19

Which backup scheme reduces the amount of downtime to perform a restore but creates additional IT management and physical resource overhead?

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

Which of the following is true about backup sets?

Which of the following is NOT among the three primary factors that should be considered for each risk scenario identified?

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?

Which recovery model causes all changes to the database to be written to the transaction log?

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

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

If you experience database corruption, what should you do before performing a restore operation?

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

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.

What is a differential database backup?

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

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

Which of the following is a reason that transaction logs must be backed up frequently?

Which category of risk has the highest probability of occurrence?

Which of the following is true about database backup types?

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

Which backup scheme reduces the amount of downtime to perform a restore but creates additional IT management and physical resource overhead?

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

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Data Integration

Monitoring SQL Server 2012

Filters

Exam 8: Backup and Recovery

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

Which of the following is true about backup sets?

Which of the following is NOT among the three primary factors that should be considered for each risk scenario identified?

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?

Which recovery model causes all changes to the database to be written to the transaction log?

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

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

If you experience database corruption, what should you do before performing a restore operation?

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

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.

What is a differential database backup?

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

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

Which of the following is a reason that transaction logs must be backed up frequently?

Which category of risk has the highest probability of occurrence?

Which of the following is true about database backup types?

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

Which backup scheme reduces the amount of downtime to perform a restore but creates additional IT management and physical resource overhead?

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

Introduction to SQL Server 2012

Deploying SQL Server 2012

Architecture and Configuration

Creating SQL Server 2012 Databases

Transact:SQL Primer

SQL Server Security

Performance Monitoring and Optimization

Data Integration

Monitoring SQL Server 2012

Filters