Free Microsoft PL-300 Exam Questions

You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege. Which role should you assign to the user?

You are creating a report in Power BI Desktop. You load a data extract that includes a free text field named coll. You need to analyze the frequency distribution of the string lengths in col1. The solution must not affect the size of the model. What should you do?

You have a Power Bl report hosted on powerbi.com that displays expenses by department for department managers. The report contains a line chart that shows expenses by month. You need to enable users to choose between viewing the report as a line chart or a column chart. The solution must minimize development and maintenance effort. What should you do?

You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace, You need to connect to BI Finance and create a report. Which actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Vou have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1. You need to simplify the connection to the data source for User1. Which type of file should you create?