PL-300 Free Practice Questions — Page 8

Question 62

DRAG DROP - You have a Power BI semantic model. You need to configure row-level security (RLS) to restrict data access for users that have the Viewer permissions. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question 63

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 64

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 65

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 66

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 67

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 68

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 69

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 70

You create a Power BI workspace named Workspace1. You publish a semantic model and a report to Workspace1. You need to configure Workspace1 to meet the following requirements: • Provide access to a group named Sales. • Ensure that Sales can invite other users to Workspace1. • Follow the principle of least privilege. Which role should you assign to Sales?

Question 71

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.