You have a table named Table1 that contains 1 million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar(16) data type. You have a certificate named Cert1. You need to replace Column1 with a new encrypted column that uses one-way hashing. Which code segment should you execute before you remove Column1? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.
Build List and Reorder:
Correct Answer:
Explanation/Reference:
According to these references, the answer looks correct.
References:
http://www.databasejournal.com/features/mssql/article.php/3922881/Column-Level-Encryption-in-SQL-Server.htm
http://msdn.microsoft.com/en-us/library/bb510663.aspx
http://msdn.microsoft.com/en-us/library/ms179331.aspx
http://msdn.microsoft.com/en-us/library/ms175491.aspx
http://msdn.microsoft.com/en-us/library/ms181860.aspx
http://msdn.microsoft.com/en-us/library/ms174361.aspx
http://msdn.microsoft.com/en-us/library/ms190499.aspx
http://msdn.microsoft.com/en-us/library/ms177938.aspx
http://msdn.microsoft.com/en-us/library/ms345262.aspx
http://msdn.microsoft.com/en-us/library/ms188357.aspx
http://msdn.microsoft.com/en-us/library/ms175491.aspx