More 70-462 Study Notes

Question 1

Which form of encryption encrypts/decrypts data at the cell level and requires applications to use encryption and decryption functions?

Answer 1

Cell-Level Encryption

Question 2

Which encryption method is a function of the file system and not of the SQL server?

Answer 2

Encrypting File System (EFS)

Question 3

Which encryption method is used to protect a computer’s system volume from unauthorized changes and startups?

Answer 3

BitLocker Drive Encryption (BDE)

Question 4

Which encryption method uses a certificate to encrypt the contents of the database, the database itself , and transaction log backups?

Answer 4

Transparent Data Encryption (TDE)

Question 5

Which encryption method requires the same certificate used for encryption as to decrypt the data before accessing?

Answer 5

Transparent Data Encryption (TDE)

Question 6

Database snapshots are stored using …

Answer 6

sparse files

Question 7

What is meant by the Copy-on-write operation?

Answer 7

Before a change is made to a a page it is written to to the snapshot

Question 8

What’s contained in the snapshot?

Answer 8

The previous version of each page that was changed since the snapshot was last taken

Question 9

A snapshot must be stored on the same instance as the database? (True/False)

Answer 9

True

Question 10

Command used to reduce the amount of allocated free space on a database?

Answer 10

DBCC SHRINKDATABASE

Question 11

Which sqlserver.exe option starts the SQL server in minimal configuration mode

Answer 11

-f

Question 12

Which option would you use if you needed to resolve a problem, and only allows a single connection

Answer 12

-f, if you need minimal configuration mode or -m if you need a full mode

Question 13

Which option is used to start a non-default instance

Answer 13

-s

Question 14

sqlserver -m

Answer 14

Starts the SQL server service in single user mode for troubleshooting or rebuilding the master database. You must stop the SQL Server Agent in order to connect.

Question 15

Which sqlserver.exe option disables monitoring features?

Answer 15

-x

Question 16

Which system variable stores the current language of the session?

Answer 16

@@LANGUAGE

Question 17

Which command would you use to check all the tables in the database but only the physical structure and can detect torn pages.

Answer 17

DBCC CHECKDB WITH PHYSICAL_ONLY

Question 18

DBCC CHECKDB REPAIR_FAST

Answer 18

Provides backward compatability but has no effect in SQL Server 2008 or higher

Question 19

How do you get DBCC to report how much tempdb space will be required and not perform a consistency check?

Answer 19

DBCC CHECKDB WITH ESTIMATEONLY

Question 20

In versions prior to 2012 this option was used to cause column values to be verified against the data type of the column.

Answer 20

DBCC CHECKDB WITH DATA_PURITY

does not need to be specified in 2012 because it always performed unless PHYSICAL_ONLY is specified

Question 21

When SQL Server cannot write to the C2 audit log, what happens?

Answer 21

The SQL Service shuts down.

Question 22

Backing up logs with NORECOVERY has what effect?

Answer 22

backs up the tail of the transaction log and allows you to recover transactions that occurred since the last logs that were shipped.