M.O.C. 2.0.7.6.4

Which of the following are the limitations of temporal tables? (Choose TWO)

• Can audit SELECT statements

• INSERT, UPDATE, and DELETE statements all audited in the same way

• History table will be in the same database

• User tracking does not require adding a column to the table to hold SUSER_SNAME

• INSERT, UPDATE, and DELETE statements all audited in the different way

________________________ occur in the background to meet the upper time limit suggested by the recovery interval server configuration option.

• Automatic checkpoints

• Manual backups

• Scheduled maintenance

• User-triggered updates

Which of the following reports are available from the management data warehouse overview? (Choose TWO)

• Disk Usage report

• List of User report

• Server Activity report

• User Activity report

• Database Activity report

Which fixed server role should be regarded as equivalent to sysadmin because of its ability to assign server principals to server roles?

• serveradmin

• securityadmin

• processadmin

• setupadmin

Which of the followings are Column-Level security?

• Can assign permissions at a column level.

• Can assign permissions for multiple columns in one GRANT or DENY statement.

• Column-level GRANT statements override table-level DENY statements.

• All of the above.

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.

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

What type of backup does the below code do?

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

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