StudyByteLearn
← SC-100: Microsoft Cybersecurity Architect
SC-100 · Data classification encryption databases and storage

Practice question 469 of 498 · easy

Employees should query only their department's rows in an Azure SQL table using a trustworthy execution context. Which feature is most directly relevant?

Choose the single best answer.

  1. A.Row-level security with a suitable predicate and security policy
  2. B.Dynamic masking as the row filter
  3. C.TDE as the department selector
  4. D.A storage account SAS
Show the answer and explanation

✓ Correct answer

  • Row-level security with a suitable predicate and security policy

Row-level security enforces row predicates. Dynamic masking alters displayed field values, TDE encrypts stored files, and a Storage SAS does not define SQL department row access.

Read the source reference

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study material. Not affiliated with or endorsed by Microsoft. These are original learning questions, not actual exam questions. Product capabilities and exam objectives can change; verify current Microsoft documentation. Practice scores do not predict or guarantee an exam result.