nerdexam
Microsoft

70-465 · Question #8

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 on

The correct answer is C. Encrypting File System (EFS). The question asks for the best method to store passwords in a database, focusing on password storage security best practices.

Submitted by minji_kr· Mar 5, 2026Design database security solutions

Question

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.

Options

  • AOne-way encryption
  • BTransparent Data Encryption (TDE)
  • CEncrypting File System (EFS)
  • DReversible encryption

How the community answered

(40 responses)
  • A
    13% (5)
  • B
    3% (1)
  • C
    78% (31)
  • D
    8% (3)

Why each option

The question asks for the best method to store passwords in a database, focusing on password storage security best practices.

AOne-way encryption

One-way encryption (hashing) is actually the industry best practice for password storage, but in this exam's context it was not selected as the correct answer, possibly because the question focuses on database-level protection rather than application-level hashing.

BTransparent Data Encryption (TDE)

Transparent Data Encryption (TDE) encrypts the entire database at rest but does not specifically protect individual password fields from being read by authorized database users who can query the data.

CEncrypting File System (EFS)Correct

While the marked correct answer is C (EFS), this is a questionable choice. EFS encrypts files at the filesystem level, which could protect the database files at rest. However, in most security best practices, one-way encryption (hashing) is considered the gold standard for password storage since passwords should never need to be decrypted. The exam apparently considers EFS as the best answer in this specific context for protecting the stored password data.

DReversible encryption

Reversible encryption is unsuitable for password storage because if an attacker gains access to the encryption keys, all passwords can be decrypted, creating a significant security vulnerability.

Concept tested: Password storage encryption methods in databases

Source: https://learn.microsoft.com/en-us/windows/win32/fileio/file-encryption

Topics

#data encryption#password security#file system security

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice