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

Practice question 125 of 400 · medium

An application has an Azure role allowing SQL resource management but SELECT fails. What should be inspected?

Choose the single best answer.

  1. A.The application's authenticated database principal and data roles/permissions
  2. B.Only the management-plane Contributor assignment, assuming it grants every SQL data permission
  3. C.Whether TDE must be disabled for managed identities
  4. D.Only IP firewall rules, assuming network access authorizes SELECT
Show the answer and explanation

✓ Correct answer

  • The application's authenticated database principal and data roles/permissions

Management-plane rights differ from database data authorization; inspect identity mapping and database roles. A Contributor assignment alone does not supply every SQL data permission, and firewall reachability does not authorize SELECT. TDE and managed identity can coexist. Source guide: PDF page 24.

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.