Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam AZ-305 Topic 2 Question 60 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 60
Topic #: 2
[All AZ-305 Questions]

You have to deploy an Azure SQL database named db1 for your company. The databases must meet the following security requirements

When IT help desk supervisors query a database table named customers, they must be able to see the full number of each credit card

When IT help desk operators query a database table named customers, they must only see the last four digits of each credit card number

A column named Credit Card rating in the customers table must never appear in plain text in the database system. Only client applications must be able to decrypt the information that is stored in this column

Which of the following can be implemented for the Credit Card rating column security requirement?

Show Suggested Answer Hide Answer
Suggested Answer: D

Contribute your Thoughts:

Melvin
27 days ago
I'm not sure, but I think A) Always Encrypted could also work to encrypt the Credit Card rating column.
upvoted 0 times
...
Wei
28 days ago
I agree with Leota. Dynamic Data Masking seems like the best option to protect the Credit Card rating column.
upvoted 0 times
...
Leota
1 months ago
I think the answer is D) Dynamic Data Masking because it can help us control who sees sensitive data.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77