Free Microsoft PL-300 Exam Questions

You have a Power B1 report named ReportA. You have a Power B1 tenant that allows users to export data. You need to ensure that consumers of ReportA cannot effort any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE Each correct selection is worth one point.

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 the CSV file shown in the following table. You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first? 

You import a Power Bl dataset that contains the following tables:Date

• Product

• Product Inventory

The Product inventory table contains 25 million rows. A sample of the data is shown in the following table

The Product Inventory table relates to the Date table by using the DateKey column. The Product inventory table relates to the Product table by using the ProductKey column. You need to reduce the size of the data model without losing information. 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?