RSS Feed

Multiple Choice Questions - Always Encrypted

Multiple Choice Questions - Always Encrypted


1. Always Encrypted is a . . . . . . technology.

A) client side
B) server side
C) both A & B
D) none of above

2. Using Always Encrypted requires

A) Creating the column master key definition
B) Creating Hardware Security Module
C) Creating an Azure Key Vault
D) Creating the column encryption key

3. Column master keys are protecting keys used to encrypt column encryption keys. Information about column master keys, including their location, is stored in the database in . . . . . . .

A) Object Catalog Views
B) Data Dictionary Views
C) System Catalog Views
D) Dynamic Management Views

4. After creating the certificate and configuring it as a column master key, you must then export and distribute it to all computers requiring access to the data.

A) True
B) False

5. Always Encrypted does not support . . . . . . . . . . queries and it also requires you to use parameters when inserting data or updating encrypted columns.

A) parameterized
B) ad-hoc parameterized
C) ad-hoc
D) ad-hoc non-parameterized

6. To create a column master key, use . . . . . . statement.

A) CREATE COLUMNS MASTER KEY
B) CREATE COLUMNMASTER KEY
C) CREATE COLUMN MASTER KEY
D) STORE COLUMN MASTER KEY

7. Always Encrypted supports two different types of encryption namely

A) Non-deterministic, randomized encryption
B) Deterministic, randomized encryption
C) Deterministic, non-randomized encryption
D) Optimistic, randomized encryption

8. Once data is encrypted using Always Encrypted

A) SQL Server is unable to decrypt it to perform any operations that require decrypted data.
B) SQL Server is able to decrypt it, in two easy steps, in order to perform any operations that require decrypted data.
C) SQL Server is able to decrypt it, but not easily, in order to perform any operations that require decrypted data.
D) None of the above.

9. One of the limitations of Always Encrypted is that Encrypted columns cannot have . . . . . . constraints.

A) DEFAULT
B) NOT NULL
C) CHECK
D) UNIQUE

10. With Always Encrypted, the data is decrypted on the driver level and is stored in memory in plain text.

A) True
B) False

Answers