Always Encrypted Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Data Encryption

What you'll be asked

  1. What is the primary purpose of using 'Always Encrypted' in a database environment?
  2. Where are the Column Master Keys (CMK) stored when using Always Encrypted?
  3. Which of the following is a key difference between Deterministic and Randomized encryption in Always Encrypted?
  4. When an application connects to a database using Always Encrypted, which component is responsible for the actual encryption and decryption of the data?
  5. If you need to perform a range comparison (e.g., WHERE Salary > 50000) on an encrypted column, which configuration is required?

Answers and explanations come after you submit.