What should you recommend?

You are creating a database that will store usernames and passwords for an application.
You need to recommend a solution to store the passwords in the database.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

You are creating a database that will store usernames and passwords for an application.
You need to recommend a solution to store the passwords in the database.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

A.
One-way encryption

B.
Encrypting File System (EFS)

C.
Transparent Data Encryption (TDE)

D.
Reversible encryption

Explanation:
* Transparent Data Encryption (TDE) is a special case of encryption using a symmetric key. TDE encrypts an
entire database using that symmetric key called the database encryption key. The database encryption key is
protected by other keys or certificates which are protected either by the database master key or by an
asymmetric key stored in an EKM module.
* SQL Server provides the following mechanisms for encryption:
Transact-SQL functions
Asymmetric keys
Symmetric keys
Certificates
Transparent Data Encryption
Transparent Data Encryption (TDE)



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Razor

Razor

A. One-way encryption
Passwords are never decrypted. You just look up one Hash against another.