What will you do to accomplish the task?

You work as a Software Developer for ABC Inc. The company uses Visual Studio .NET 2008 as its application development platform. You create an ASP.NET Web application using .NET Framework 3.5. The application stores sensitive profile data in a SQL Server 2008 database. You are required to make sure that no profile data is stored in clear text.

What will you do to accomplish the task?
A . Use the Aspnet_regiis.exe tool to encrypt the connection string that is used to connect to the database.
B . Create a custom profile provider and ensure that the provided information is encrypted before it is stored in the database.
C . Enable the secure sockets layer encryption for the SQL Server connections.
D . Use SQL Profiler.

View Answer

Answer: B