Microsoft Exam AZ-305 Topic 2 Question 60 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 60
Topic #: 2

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?

AAlways Encrypted

BAzure Advanced Threat Protection

CTransparent Data Encryption

DDynamic Data Masking

Show Suggested Answer

Suggested Answer: D

by Quinn at Jun 30, 2024, 12:44 AM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Eun

1 months ago

I bet the IT help desk operators are just itching to see those full credit card numbers. Hey, as long as they don't share them on social media, right?

upvoted 0 times

...

Marge

1 months ago

Azure Advanced Threat Protection is great for detecting threats, but it doesn't address the specific security requirements mentioned in the question.

upvoted 0 times

...

Rosio

1 months ago

Transparent Data Encryption sounds tempting, but it won't help with the requirement to keep the Credit Card rating column secure. That's a separate concern.

upvoted 0 times

...

Leonard

1 months ago

I'm not sure Dynamic Data Masking is the right choice here. It only masks the output, but the data is still stored in plain text in the database.

upvoted 0 times

Linette

9 days ago

B) Azure Advanced Threat Protection

upvoted 0 times

...

Margarita

19 days ago

A) Always Encrypted

upvoted 0 times

...

3 months ago

I think the answer is D) Dynamic Data Masking because it can help us control who sees sensitive data.

upvoted 0 times

...