Question 330
An Azure SQL operations team investigates: A database team needs to demonstrate which roles see masked results without assuming it prevents all data inference. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.
Explanation
Correct Answers
The reported Azure SQL or SQL Server condition is: A database team needs to demonstrate which roles see masked results without assuming it prevents all data inference. The specific supported administrative response is: Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately. The technical risk is: Dynamic data masking is not encryption or a complete barrier against inference by a user able to query data. Confirm the correction with: Authorized privileged users see expected values and restricted users receive masked output under tested permissions.
The acceptance evidence for this incident (A database team needs to demonstrate which roles see masked results without assuming it prevents all data inference.) is: Authorized privileged users see expected values and restricted users receive masked output under tested permissions. It directly tests whether the remediation (Use supported dynamic data masking for low-privilege query-result obfuscation while enforcing true authorization separately.) solves the specified issue, instead of proving an unrelated database control works.
Incorrect Answers
SQL encrypted connections and TLS verification (2.2) would demonstrate or implement: An approved SQL client validates the intended server certificate and rejects an untrusted endpoint during a controlled test. This choice can be useful for that problem, but it does not establish the Dynamic data masking limitations (2.3) control being assessed here.
Sensitive data classification and discovery (2.3) addresses another technical failure: Unclassified personal or payment data may be exposed through poorly scoped reporting or overlooked control decisions. The required paired action and test concerns Dynamic data masking limitations (2.3); a passing result for this alternative could leave that requirement unresolved.
SQL authentication management on SQL server vms (2.1) addresses another technical failure: Poorly governed shared SQL logins are hard to rotate and can bypass centralized identity lifecycle management. The paired-answer requirement concerns Dynamic data masking limitations (2.3); this alternative does not provide the matching intervention and separate acceptance evidence.