Exam DP-700 topic 1 question 57 discussion

Actual exam question from Microsoft's DP-700

Question #: 57
Topic #: 1

You have a Fabric warehouse named DW1. DW1 contains a table that stores sales data and is used by multiple sales representatives.

You plan to implement row-level security (RLS).

You need to ensure that the sales representatives can see only their respective data.

Which warehouse object do you require to implement RLS?

A. TRIGGER
B. SCHEMA
C. FUNCTION
D. DATABASE ROLE

Show Suggested Answer

Suggested Answer: C 🗳️

by gretito_g at June 9, 2025, 1:42 p.m.

Comments

Submit Cancel

e392998

1 week, 4 days ago

Selected Answer: C

function is the the way to control filtering. Role control access permission to the table and database

upvoted 1 times

...

rehoboth2165

2 months ago

Selected Answer: C

FUNCTION ✅ Used to define the logic to filter rows based on user identity (predicate function) ✅ Yes D. DATABASE ROLE Can assign permissions, but not used for filtering rows dynamically ❌ No

upvoted 4 times

...