DRAG DROP
You plan to create a new table that will contain a column named Salary. Salary will contain
highly sensitive data.
Salary must meet the following requirements:
Contain numeric data.
Contain only encrypted data that remains encrypted in memory.
You need to identify which encryption type and data type must be used for Salary.
Which encryption type and data type should you identity?
To answer, drag the appropriate encryption type and data type to the correct identifier in the
answer area.
Explanation:
According to this. It’s:
1.Cell-Leve encryption
2.Varbinary
https://blogs.technet.microsoft.com/canitpro/2012/03/14/the-sql-guy-post-20-using-cell-level-encryption-in-sql-server/