BenchMark Quizzes by MDFT Pro

Implement Row-Level Security In Warehouse

You work as a Security Administrator for Mark at MDFT Pro, a well-known training agency. MDFT Pro operates a Fabric warehouse named DW1 that stores comprehensive sales data for all training courses, certification programs, and educational materials sold by the agency. The warehouse contains a table that is used by multiple sales representatives across different regions and product lines. Mark has identified a security concern: currently, all sales representatives can see the entire sales dataset, including sales made by other representatives in different territories. To comply with data privacy policies and ensure appropriate data access, Mark has asked you to implement row-level security (RLS) so that each sales representative can see only their own sales records and cannot access data belonging to other representatives.

Which warehouse object do you require to implement row-level security?

Choose the correct answer from the options below.

Explanations for each answer:

STORED PROCEDURE is incorrect. Stored procedures are used to encapsulate business logic and SQL operations, but they are not the appropriate object for implementing row-level security filters in Fabric warehouses.
CONSTRAINT is incorrect. Constraints are used to enforce data integrity rules like primary keys, foreign keys, and check constraints, but they cannot be used to implement row-level security based on user context.
SCHEMA is incorrect. Schemas are logical containers for database objects and are used for organizing tables and views, but they don't provide the mechanism for filtering rows based on user identity.
FUNCTION is correct. Inline table-valued functions are used in Fabric warehouses to implement row-level security. The function contains the filtering logic that determines which rows a user can access, and it's applied through a security policy.

Learn more about row-level security in Fabric Warehouse:

Warehouse Row-Level Security

Practice Exam

Implement Row-Level Security In Warehouse

Discuss this question on social media: