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?
A.
One-way encryption
B.
Reversible encryption
C.
Encrypting File System (EFS)
D.
Secure Sockets Layer (SSL)
Correct, one way hashing is what needs to be used in this case:
https://www.mssqltips.com/sqlservertip/4037/storing-passwords-in-a-secure-way-in-a-sql-server-database/