Check your knowledge

1.

Barry is a data modeler at the Tailspin Toys company who is developing a Power BI Desktop model that must enforce RLS. It must restrict access to specific product categories. Presently, the company sells products across four categories, and it's possible that the organization will add new categories in the future. The design shouldn't require republishing the model when the company defines new categories. What should Barry do?

Create one role for each product category.

Create one role and use the USERPRINCIPALNAME function to filter the Category column of the Product table.

Create one rule for each product category.

Create one rule and use the USERPRINCIPALNAME function to filter the Category column of the Product table.

2.

Camila is a Power BI developer at the Tailspin Toys company who is developing a Power BI Desktop import 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 Camila do?

Apply rules to dimension tables.

Apply rules to effective identities.

Apply rules to fact tables.

Apply rules to model relationships.

3.

Paulo is a developer at the Tailspin Toys company who is developing an app that embeds Power BI reports. The reports use a DirectQuery model that sources its data from an Azure SQL Database and is set up to use the users' OAuth2 credentials. The database already enforces RLS for specific Azure AD accounts. The embedded Power BI reports must enforce the same RLS. What parameter should Paulo use when generating an embed token with the `GenerateTokenRequestV2` method?

`CustomData`

`IdentityBlob`

`Roles`

`Username`

Answer the following questions to see what you've learned.

Feedback