A user belongs to two OneLake security roles in user identity mode. One role grants full table access, and the other applies row-level security to restrict rows. What effective behavior should you expect?

ARow-level security always wins

BFull access wins because the most permissive role takes precedence

CAccess is denied until the roles are merged

DSQL GRANT statements decide the result

More Implement and manage an analytics solution Questions

64 questions

Full Microsoft Certified: Fabric Data Engineer Associate Practice Test

All topics covered

All Microsoft Certified: Fabric Data Engineer Associate Questions

Browse by topic

Related Questions

A team needs read-only access to all items in a Fabric workspace but must not modify them. Which wor...

easy

A Fabric item is shared with an analyst by using item permissions only. What does the default Read p...

easy

A data engineer wants the SQL analytics endpoint to pass each signed-in user's identity to OneLake f...

easy

Which Git provider is officially supported by Microsoft Fabric Git integration?...

easy

An architect wants OneLake row-level and column-level security to be enforced when users query a lak...

medium

View all Implement and manage an analytics solution questions

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.