Exam 70-464 topic 1 question 54 discussion

Actual exam question from Microsoft's 70-464

Question #: 54
Topic #: 1

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.
Select and Place:

Show Suggested Answer

Suggested Answer:

by CodeMaestro at July 1, 2020, 12:25 p.m.

Comments

Submit Cancel

Luzix

4 years, 6 months ago

It´s correct due to the encryption functions use character or binary data as input and output. https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2005/administrator/cc966395(v=technet.10)?redirectedfrom=MSDN https://www.sqlservercentral.com/blogs/using-cell-level-encryption-in-sql-server

upvoted 3 times

Kepty

4 years, 5 months ago

Agree .

upvoted 1 times

...

CodeMaestro

4 years, 10 months ago

I think the correct answer is Decimal for the data type as it is a numeric data type as opposed to varbinary.

upvoted 1 times

...

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam

Exam 70-464 topic 1 question 54 discussion

Comments

Luzix

Kepty

CodeMaestro

SY0-701