PrepAway - Latest Free Exam Questions & Answers

Does the solution meet the goal?

You need to ensure that the SecurityPin security requirements are met.

Solution: Using the Azure Portal, add Data Masking to the SecurityPin column, and exclude the dbo user. Add a SQL security policy with a filter predicate based on the user identity.

Does the solution meet the goal?

A. Yes

B. No

Explanation:
Instead of DataMasing, enable Always Encrypted for the SecurityPin column.

Scenario: Users’ SecurityPin must be stored in such a way that access to the database does not allow the viewing of SecurityPins. The web application is the only system that should have access to SecurityPins.


Leave a Reply