70-464 Free Dumps Study Materials
Question 2: You have a table named Table1 that contains one 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 must add a column named Column2 that contains an encrypted version of the data from
Column1. You must use two-way encryption. You plan to remove Column1 after you create Column2.
Which five Transact-SQL statements should you run in sequence before you remove Column1? To
answer, move the appropriate Transact-SQL statements from the list of Transact-SQL statements to
the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any correct orders
you select.
Correct Answer:Explanation:
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-
of-data?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/statements/close-symmetric-key-transact-sql?view=sql-
server-2017