Skip to content
DP-700
Implement and manage an analytics solution
hard
Question 2 of 64

A SQL analytics endpoint currently uses delegated identity mode with SQL roles and SQL-defined row-level security. The team switches it to user identity mode. What should they expect?

AExisting SQL roles remain active and OneLake roles are ignored
BSQL table permissions and SQL row-level security are ignored, and access must be defined in OneLake roles
CDynamic data masking continues from SQL while table access moves to OneLake
DThe switch affects only views and stored procedures

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.

Sign in to join the discussion