Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Design Row-Level Security

HardPipelines00:00
Practice interviewer
In session
5 left
00:00

Your question is Design Row-Level Security. Take a moment with it on the right.

Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).

You need to log in / sign up to chat or submit.

Problem

Scenario

You are designing access controls for a shared analytics workspace used by multiple government agencies. Each agency can see only its own rows, while a small set of cross-agency administrators can view approved shared datasets. The same semantic model backs dashboards, exports, and ad hoc queries, so the security layer has to work consistently across all access paths.

Question

How would you design Row-Level Security for a multi-agency workspace with compartmentalized access?