DecryptByKeyAutoCert is ________________ type function. A. Symmetric

decryptbykeyautocert-is-type-function-a-symmetric

DecryptByKeyAutoCert is ________________  type function.

A. Symmetric Encryption and decryption

B. Encryption Hashing

C. Asymmetric Encryption and decryption

D. Symmetric decryption with Automatic key handling

The question was asked in an interview for job.

Question is taken from Builtin Functions topic in division Laying the Foundation of SQL Server

The correct option is D. Symmetric decryption with Automatic key handling

Best explanation: DecryptByKeyAutoCert function decrypts by using a symmetric key that is automatically decrypted with a certificate.