StudyByteLearn
← AZ-305: Azure Infrastructure Solutions
AZ-305 · Relational data

Practice question 127 of 400 · easy

A multi-tenant shared SQL database must restrict each authenticated tenant to its own rows. Which capability directly matches?

Choose the single best answer.

  1. A.Dynamic masking of the tenant ID alone
  2. B.TDE alone
  3. C.Long-term backup retention
  4. D.Row-level security with suitable predicates and identity context
Show the answer and explanation

✓ Correct answer

  • Row-level security with suitable predicates and identity context

Row-level security filters authorized rows. TDE addresses at-rest confidentiality, masking changes presentation, and LTR stores history; none of these alone enforce tenant row access. Source guide: PDF page 25.

Read the source reference

This item is flagged for content review.

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

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.