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

Practice question 472 of 498 · hard

A Synapse analyst can edit a notebook but cannot query a SQL pool table. What should the architect assess before changing access?

Choose the single best answer.

  1. A.Remove all network restrictions before checking the identity and SQL grants
  2. B.Assume editing a notebook proves SQL data rights are already present
  3. C.Grant workspace administration without identifying the failed permission plane
  4. D.The identity and separate SQL data permission involved in the failed operation
Show the answer and explanation

✓ Correct answer

  • The identity and separate SQL data permission involved in the failed operation

Workspace capabilities and SQL data permissions are separate. Notebook editing is not proof of table access, broad workspace administration expands privilege without diagnosing SQL rights, and removing network restrictions before assessing the described permission boundary is unjustified.

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.