Administering a SQL Database Infrastructure — Question 249

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.

Answer options

• A. One-way encryption
• B. Transparent Data Encryption (TDE)
• C. Encrypting File System (EFS)
• D. Reversible encryption

Correct answer: C

Explanation

The best choice for securely storing passwords is One-way encryption, as it ensures that passwords cannot be easily retrieved even if the database is compromised. Transparent Data Encryption (TDE) and Encrypting File System (EFS) protect data at rest but do not specifically address password security in the same way. Reversible encryption is not advisable for passwords because it allows for decryption, making it less secure.