Knowledge check

Completed

Choose the best response for each of the questions below.

Check your knowledge

1.

Joshua is a data modeler at Adventure Works who is developing a model for a large data warehouse. The model must enforce RLS, and the Power BI reports that connect to the model should deliver the fastest possible performance. What should Joshua do?

Apply rules to dimension tables.

Apply rules to hierarchies.

Apply rules to fact tables.

2.

Rupali is a data modeler at Adventure Works who is developing an import model to analyze employee timesheet data. The employee table stores the employee social security number (SSN) in a column. While the model will be available for all company managers, it will also be available to employees in the Payroll department. However, reports must only reveal employee SSNs to payroll employees. What feature should Rupali use to restrict access to the SSN column?

RLS.

SSO.

OLS.

3.

Kasper is a data modeler at Adventure Works who is developing a model that must enforce RLS. It must restrict access to only the sales regions assigned to the report consumer. The source database includes a table that stores employee usernames and their assigned region(s). What should Kasper do?

Create an OLS role and use a dynamic rule.

Create an RLS role and use a dynamic rule.

Create an RLS role and use a static rule.

You must answer all questions before checking your work.