Font size
Worksheets20764 - SQL - Mod 5 and 6
Total questions: 18
Worksheet time: 10mins
What kind of database might be a good candidate for a full backup strategy?
A big database that can be backed up quickly.
A small database that can be backed up quickly.
A medium database that can be backed up quickly.
None of the them
SQL Server has three database recovery models. Match the following recovery model with its characteristics - Simple recovery model
This model requires log backups for manageability and can enhance the performance of bulk copy operations.
This model requires log backups for manageability and avoids data loss due to a damaged or missing data file.
This model does not permit or require log backups and automatically truncates the log to keep space requirements small.
SQL Server has three database recovery models. Match the following recovery model with its characteristics - Full recovery model
This model requires log backups for manageability and can enhance the performance of bulk copy operations.
This model requires log backups for manageability and avoids data loss due to a damaged or missing data file.
This model does not permit or require log backups and automatically truncates the log to keep space requirements small.
SQL Server has three database recovery models. Match the following recovery model with its characteristics - Bulk-logged recovery model
This model requires log backups for manageability and can enhance the performance of bulk copy operations.
This model requires log backups for manageability and avoids data loss due to a damaged or missing data file.
This model does not permit or require log backups and automatically truncates the log to keep space requirements small.
_______________________ occur in the background to meet the upper time limit suggested by the recovery interval server configuration option.
Automatic checkpoints
Manual checkpoints
Indirect checkpoints
Internal checkpoints
A full backup of a database includes the data files and the active part of the transaction log. The first step in the backup is that a CHECKPOINT operation is performed. True or false?
True
False
A backup strategy that involves transaction log backups must be combined with a _____________ or a strategy that combines the use of full and differential database backups.
Partial database strategy
Differential database strategy
Transaction log strategy
Full database strategy
What are the benefits of backing up to Microsoft Azure Blob?
(Choose TWO).
Limited storage for your backups.
Offsite backup storage with the need for tapes and transportation.
No backup hardware to purchase or maintain.
Offsite backups are available for restore instantly without the need for tape retrieval.
Backup hardware to purchase or maintain.
The most important aspect of creating a backup strategy is that it must not be designed in response to the business requirements and strategy.
True
False
What are the unique features of transaction log restores?
Point-in-time recovery.
The ability to restore up to the point of failure if only data files are corrupt.
Both of them.
None of them.
Which of the following are benefits of compressing backups? (Choose TWO).
Reduces size of backup on device
Decreases I/O requirements
Reduces I/O requirements
Decreases CPU usage
Decreases speed of backup and restore
A full database backup will back up all of the data pages in the database and also saves the active portion of the transaction log. True or false?
True
False
A ____________ backs up only the primary filegroup and filegroups that are set to read-write.
Partial backup
File backup
Filegroup backup
All of the them
Which of the following backup performs the following SQL command?
BACKUP DATABASE AdventureWorks
TO DISK = 'D:\Backups\AW_Copy.bak'
WITH COPY_ONLY, INIT;
Compressing backup
Encrypting backup
Decrypting backup
Copy-only backup
A single backup is called a backup set, and is written to a media set, which can contain up to ______ backup devices.
32
16
64
128
You can find information about a specific media set by executing the RESTORE statement. Match the following: RESTORE LABELONLY
Returns a list of data and log files contained in a backup set.
Returns information about the backup media on a specified backup device.
Returns all the backup header information for all backup sets on a particular backup device.
You can find information about a specific media set by executing the RESTORE statement. Match the following: RESTORE HEADERONLY
Returns a list of data and log files contained in a backup set.
Returns information about the backup media on a specified backup device.
Returns all the backup header information for all backup sets on a particular backup device.
You can find information about a specific media set by executing the RESTORE statement. Match the following: RESTORE FILELISTONLY
Returns a list of data and log files contained in a backup set.
Returns information about the backup media on a specified backup device.
Returns all the backup header information for all backup sets on a particular backup device.
