Free Microsoft Data Engineering DP-700 Actual Exam Questions - Question 5 Discussion
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?
D. The key here is you need something that can dynamically filter rows based on who's querying, and functions are designed for that in row-level security setups. Constraints (B) are more about data integrity, not filtering access. Procedures (A) don't filter data on select queries, and schemas (C) are more about organizing objects, not controlling access at the row level. So the function is what actually applies the security logic per user.
D, since functions define the filtering logic needed for row-level security.
Probably D. Functions let you define the filter logic for each user’s data, which fits RLS well. Constraints (B) handle data rules, not security filtering.
I’m thinking it’s not B since constraints usually handle data integrity, not filtering per user. Could the function in D be right just because it applies the filter logic? What about A or C though, are procedures or schemas involved in RLS at all?
Makes sense to use a function since RLS filters need logic—D for sure.
Gotta go with D here.