If row-level security must filter data based on the viewer's identity using dynamic rules, what should you implement?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

If row-level security must filter data based on the viewer's identity using dynamic rules, what should you implement?

Explanation:
Row-level security with a dynamic rule. You need per-row filtering that adapts to who is querying, so the policy must evaluate the viewer’s identity at query time and filter each row accordingly. Static rules wouldn’t change based on who runs the query, and object-level security blocks access to entire objects rather than individual rows, which doesn’t achieve per-row filtering. A dynamic policy tied to the current user ensures only the appropriate rows are visible to each viewer.

Row-level security with a dynamic rule. You need per-row filtering that adapts to who is querying, so the policy must evaluate the viewer’s identity at query time and filter each row accordingly. Static rules wouldn’t change based on who runs the query, and object-level security blocks access to entire objects rather than individual rows, which doesn’t achieve per-row filtering. A dynamic policy tied to the current user ensures only the appropriate rows are visible to each viewer.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy