MS SQL Server - 44 - Encrypting Data MCQ

44 – Encrypting Data MCQ

Best of luck!

1 / 22

1. In MS SQL Server, what is the primary purpose of a symmetric key?

To encrypt data using a pair of keys (public and private)

To store digital signatures

To validate user credentials

To encrypt data using a single key for both encryption and decryption

2 / 22

2. Which type of encryption key uses a pair of keys (public and private) for data encryption and decryption?

Certificate

Symmetric key

Asymmetric key

Hash key

3 / 22

3. In SQL Server, what is the primary purpose of an asymmetric key?

To validate user credentials

To store digital signatures

To encrypt data using a pair of keys (public and private)

To encrypt data using a single key for both encryption and decryption

4 / 22

4. Which SQL statement is used to create a symmetric key in SQL Server?

CREATE KEY KeyName

CREATE ASYMMETRIC KEY KeyName

CREATE CERTIFICATE KeyName

CREATE SYMMETRIC KEY KeyName

5 / 22

5. What is the primary purpose of a certificate in SQL Server?

To validate user credentials

To encrypt data using a pair of keys (public and private)

To encrypt data using a single key for both encryption and decryption

To store digital signatures

6 / 22

6. In SQL Server, which SQL statement is used to create an asymmetric key?

CREATE SYMMETRIC KEY KeyName

CREATE KEY KeyName

CREATE ASYMMETRIC KEY KeyName

CREATE CERTIFICATE KeyName

7 / 22

7. What is the primary purpose of a certificate in SQL Server?

To encrypt data using a pair of keys (public and private)

To validate user credentials

To encrypt data using a single key for both encryption and decryption

To store digital signatures

8 / 22

8. In SQL Server, which SQL statement is used to create a certificate?

CREATE ASYMMETRIC KEY KeyName

CREATE CERTIFICATE CertName

CREATE KEY KeyName

CREATE SYMMETRIC KEY KeyName

9 / 22

9. What is the primary purpose of editing metadata concerning user keys in SQL Server?

To change the key used for data encryption

To validate user credentials

To encrypt data using a single key for both encryption and decryption

To store digital signatures

10 / 22

10. In SQL Server, what is the primary purpose of Extensible Key Management (EKM)?

To create symmetric keys

To manage user credentials

To integrate with external hardware security modules (HSMs) for key management

To encrypt data using a pair of keys (public and private)

11 / 22

11. What is one method of data encryption in SQL Server that uses a single key for both encryption and decryption?

Certificate encryption

Hashing

Symmetric encryption

Asymmetric encryption

12 / 22

12. In SQL Server, which statement is true about symmetric key encryption?

It is only used for digital signatures.

It uses a pair of keys (public and private) for data encryption and decryption.

It is commonly used for encrypting large volumes of data.

It requires the use of certificates.

13 / 22

13. Which SQL statement is used to edit metadata concerning user keys in SQL Server?

ALTER SYMMETRIC KEY KeyName

ALTER KEY KeyName

ALTER CERTIFICATE CertName

ALTER ASYMMETRIC KEY KeyName

14 / 22

14. What is the primary purpose of the OPEN SYMMETRIC KEY statement in SQL Server?

To generate a digital signature

To create a new symmetric key

To open an existing symmetric key for data encryption or decryption

To open an existing asymmetric key for data encryption or decryption

15 / 22

15. In SQL Server, which SQL statement is used to edit the metadata of an asymmetric key?

ALTER KEY KeyName

ALTER CERTIFICATE CertName

ALTER SYMMETRIC KEY KeyName

ALTER ASYMMETRIC KEY KeyName

16 / 22

16. What is the primary purpose of the CREATE SYMMETRIC KEY statement in SQL Server?

To open an existing asymmetric key for data encryption or decryption

To create a new symmetric key

To open an existing symmetric key for data encryption or decryption

To generate a digital signature

17 / 22

17. In SQL Server, what is one method of data encryption that uses a pair of keys (public and private) for encryption and decryption?

Asymmetric encryption

Symmetric encryption

Certificate encryption

Hashing

18 / 22

18. What is the primary purpose of the CLOSE SYMMETRIC KEY statement in SQL Server?

To open an existing symmetric key for data encryption or decryption

To close an open symmetric key

To generate a digital signature

To create a new symmetric key

19 / 22

19. In SQL Server, what is the primary purpose of the DROP SYMMETRIC KEY statement?

To remove an existing symmetric key

To open an existing symmetric key for data encryption or decryption

To generate a digital signature

To create a new symmetric key

20 / 22

20. In SQL Server, what is the primary purpose of the DROP ASYMMETRIC KEY statement?

To open an existing symmetric key for data encryption or decryption

To remove an existing asymmetric key

To create a new symmetric key

To generate a digital signature

21 / 22

21. What is the primary purpose of the ALTER CERTIFICATE statement in SQL Server?

To generate a digital signature

To create a new symmetric key

To modify the metadata of an existing certificate

To open an existing symmetric key for data encryption or decryption

22 / 22

22. In SQL Server, what is the primary purpose of the DROP CERTIFICATE statement?

To remove an existing certificate

To generate a digital signature

To create a new symmetric key

To open an existing symmetric key for data encryption or decryption

Your score is

MS SQL Server – 44 – Encrypting Data MCQ