BenchMark Quizzes by MDFT Pro

Implement RLS And OLS For Data Security In Power BI

You have a dataset in Power BI at MDFT Pro with tables for Employees, Payroll, Sales, and Students. Each table has different security requirements to protect sensitive information:

Only HR can access the Employees table
Only managers can access the Payroll table, and they can only access salaries from their own department
Everybody can access the Sales table, but Employees can only access Sales records from their own business unit
Only HR can access the Students table

How should you implement data access for each table to ensure the right level of security?

Choose all correct answers from the options below.

Explanations for each answer:

Employees: Object Level Security only (OLS) is correct. OLS restricts access to the entire Employees table, ensuring only HR can access personally identifiable information.
Payroll: Object Level Security and Row Level Security (OLS and RLS) is correct. OLS restricts access to the Payroll table to managers, and RLS filters rows so each manager only sees salaries from their department.
Sales: Row Level Security only (RLS) is correct. RLS filters the Sales table so employees only see results from their business unit.
Students: No security required is incorrect. The Students table contains sensitive information and should be restricted to HR only. Not applying security would expose confidential student data.

Learn more about RLS and OLS in Power BI:

RLS And OLS In Power BI

Exam Preparation Quiz

Implement RLS And OLS For Data Security In Power BI