PL-300 Free Practice Questions — Page 6

Question 52

HOTSPOT - You use Microsoft Power BI Desktop to review the data shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

Question 53

You have a Power BI tenant that contains a workspace named WS1. WS1 contains the following items: • A semantic model named SM1. • A report named RPT1 that is connected to SM1. • A report named RPT2 that is connected to SM1. • A report named RPT3 that is connected to SM1. • A dashboard named DB1 that contains content from RPT1 and RPT2. You need to grant workspace access to a group named Group1. The solution must meet the following requirements: • Group1 must be able to view RPT1, RPT2, and DB1. • Group1 must be prevented from viewing RPT3. • Group1 must be prevented from creating new reports and dashboards by using SM1. • Group1 must be prevented from sharing the reports and dashboards to other users. • Administrative effort must be minimized. What should you do?

Question 54

HOTSPOT - You use Power Query Editor to review the query shown in the following exhibit. Each Region value appears only on the row where it first occurred. Each subsequent occurrence of the Region value is blank. You need to ensure that every row contains the correct non-blank value. The solution must minimize development effort. Which column should you select, and which action should you perform on the column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 55

You are creating a new semantic model in Microsoft Power BI Desktop. You connect to a recently used data source and receive an error message indicating that the password is expired. You need to update the credentials for the data source. What should you do?

Question 56

You have a Microsoft Power BI Desktop report named Report1 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?

Question 57

You have a Power BI semantic model named Model1 that contains sales data. You need to ensure that Model1 is refreshed on the first day of each month to include last month’s sales data. What should you configure?

Question 58

You have a Power BI report that contains a bar chart. The bar chart displays sales by country. You need to ensure that a summary of the data shown on the bar chart is accessible by using a screen reader. What should you configure on the bar chart?

Question 61

DRAG DROP - You have a Power BI semantic model that contains a table. You need to create a Power BI report page that contains two visuals that meet the following requirements: • Visual 1: Displays the distribution of hierarchical data • Visual 2: Search and then filter by values Which type should you choose for each visual? To answer, drag the appropriate visual types to the correct visuals. Each visual type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Question 62

HOTSPOT - You use Power Query Editor to review a query that contains a column named Country. You need to view the following information in the Data preview view for the Country column: • The percentage of values that contain errors. • The count of empty values. What should you enable? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 63

You have a Power BI semantic model named Model1 that runs in Import storage mode. You need to reduce the size of Model1. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.