Chapter 6 Quiz

Question 1

_______ and _______can be used to simplify management of permissions

Answer 1

Roles , schemas

Question 2

_______does not prevent data loss but can make data _______

Answer 2

Encryption , unintelligible

Question 3

A SQL Server login may not access a database directly because it is a _______

Answer 3

server-level principal

Question 4

Databases often contain _______ or confidential information that must be protected

Answer 4

sensitive

Question 5

_______ keys use a public key to encrypt and a different, private key to decrypt

Answer 5

Asymmetric

Question 6

use a public key to encrypt and a different (private) key to decrypt data

Answer 6

Asymmetric keys

Question 7

_______are the objects in a database and on a SQL Server instance that can be secured

Answer 7

Securables

Question 8

TDE uses a _______ key called the _______ to encrypt individual pages within data and log files

Answer 8

symmetric ,DEK

Question 9

use the same key to encrypt and decrypt data

Answer 9

Symmetric keys

Question 10

SQL Server _______operate at the level of the SQL Server _______and are server-level security principals

Answer 10

logins , instance

Question 11

a symmetric key used to protect asymmetric private keys and certificates stored in the database

Answer 11

– Database master key (DMK)

Question 12

SQL function that uses a passphrase to generate a key and uses the Triple DES algorithm to encrypt data

Answer 12

EncryptByPassphrase()

Question 13

SQL function that encrypts data using a key that has been registered with the database

Answer 13

– EncryptByKey() -

Question 14

Client/server messages are susceptible to _______

Answer 14

interception

Question 15

A user connecting to SQL server must have an _______ that specifies the type of authentication used by that login

Answer 15

associated SQL Server login

Question 16

key management system within Windows OS

Answer 16

Windows Data Protection API (DPAPI)

Question 17

A ____ is used in conjunction with a ____ to encrypt data

Answer 17

key , cipher

Question 18

a block cipher that translates fixed-size blocks of unencrypted data into corresponding fixed-sized blocks of encrypted data

Answer 18

Advanced Encryption Standard (AES)

Question 19

uses a symmetric key (called the database encryption key - DEK) to encrypt pages within the physical data and log files

Answer 19

Transparent Data Encryption (TDE)

Question 20

another column value that is unique to the row and used in conjunction with the key to secure data

Answer 20

Authenticator

Question 21

_______ keys use the same key to encrypt and decrypt data

Answer 21

Symmetric

Question 22

feature that enables third-party key management solutions to be used in conjunction with SQL Server

Answer 22

Encryption key management (EKM)

Question 23

SQL Server uses a _______ approach to encrypt

Answer 23

hierarchical

Question 24

_______ enables third-party key management in conjunction with SQL Server

Answer 24

Encryption key management (EKM)

Question 25

_______ is performed during logon when a user requests access to a system

Answer 25

Authentication

Question 26

created the first time a SQL Server instance is started

Answer 26

– Service master key (SMK)

Question 27

applies the Data Encryption Standard (DES) cipher three times to the data using three different 64-bit keys

Answer 27

3-key Triple DES