nerdexam
Microsoft

70-465 · Question #96

You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. You are developing a custom CRM application named CorpCRM. The application will…

The correct answer is A. One-way encryption. To ensure usernames and passwords in the CorpCRMDB1 database are secure, the most suitable solution is one-way encryption, commonly implemented through hashing, which prevents the original passwords from being retrieved even if the database is compromised.

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

Question

You work as a Developer at ABC.com. All databases are hosted on Windows Server 2012 servers running SQL Server 2012. You are developing a custom CRM application named CorpCRM. The application will store usernames and passwords in a SQL Server 2012 database named CorpCRMDB1. You need to ensure the usernames and passwords are secure. Which of the following would be most suitable password storage solution?

Options

  • AOne-way encryption
  • BReversible encryption
  • CEncrypting File System (EFS)
  • DSecure Sockets Layer (SSL)

How the community answered

(47 responses)
  • A
    77% (36)
  • B
    2% (1)
  • C
    13% (6)
  • D
    9% (4)

Why each option

To ensure usernames and passwords in the CorpCRMDB1 database are secure, the most suitable solution is one-way encryption, commonly implemented through hashing, which prevents the original passwords from being retrieved even if the database is compromised.

AOne-way encryptionCorrect

One-way encryption, typically achieved through hashing algorithms, is the most suitable method because it transforms the password into a unique, fixed-length string that is computationally infeasible to reverse engineer back to the original password. This approach ensures that even if an attacker gains access to the stored password hashes, they cannot directly obtain the clear-text user passwords, significantly enhancing security.

BReversible encryption

Reversible encryption allows the original password to be decrypted from its stored form, which poses a significant security risk if the encryption key is compromised, making it less secure than one-way hashing for password storage.

CEncrypting File System (EFS)

Encrypting File System (EFS) encrypts files and folders at the operating system level, securing the database files at rest, but it does not directly secure the passwords *within* the database application layer or dictate the method of password storage itself.

DSecure Sockets Layer (SSL)

Secure Sockets Layer (SSL) is a protocol used to encrypt data *in transit* over a network, securing communication between the application and the database server, but it does not address how passwords are *stored at rest* within the database.

Concept tested: Secure password storage using hashing

Source: https://learn.microsoft.com/en-us/aspnet/identity/overview/features-api/password-storage-in-aspnet-identity

Topics

#Password security#One-way encryption#Hashing#SQL Server security

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice