If you want to provide workspace access to a co-worked to allow them to create and edit Power BI reports but don’t want them to be able to update apps, which workspace role should be assigned?

You have created a supplier quality report and are asked to add row-level security to your data model. You decide to add dynamic row-level security that uses a user’s email address. You have a column for a user’s email address called UserEmail.

What DAX function would you use to create a new role using the UserEmail field?

Which of the following Query Editor tools allows you dynamically change the source of your query?

You want to connect to an on-premise database in your company (which has been set up on a Gateway) but are unable to obtain credentials to connect directly to it yourself. What would be the best way to gain access to this data?

Which type of cardinality describes the ideal type of table relationship in Power BI Desktop?

Workspace apps cannot be shared with which of the following options?

True or False: if you want to model your data (e.g. define your own relationships and create DAX measures) you need to use Power BI Desktop rather than just connecting to data in the Power BI Service.

Sync Slicers allow slicer selections to carry over between pages. This functionality requires that all slicers be visible on each page.

Why is the column profiling feature in the Query Editor potentially useful?

You manage an analytics team and one of your junior analysts asks you to help identify some reasons why their report performance is slow. Which of the following options would you suggest they investigate?