Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 81:

  You are building a data model for a Power Bl report. You have data formatted as shown in the following table.

  

  You need to create a clustered bar chart as shown in the following exhibit.

  

  What should you do?

  A. From Power Query Editor, split the Machine-User column by using a delimiter.
  B. In a DAX function, create two calculated columns named Machine and User by using the substitute function.
  C. From Power Query Editor, create a column that contains the last three digits of the Machine-User column.
  D. in a DAX function, create two measures named Machine and User by using the substitute function.
  A. From Power Query Editor, split the Machine-User column by using a delimiter.

  ---

  Explanation

  Split a column of text (Power Query)

  You can split a column with a text data type into two or more columns by using a common delimiter character. For example, a Name column that contains values written as <LastName>, <FirstName> can be split into two columns using the comma (,) character.

  Note: Power Query is an Extract Transform Load (ETL) tool. It allows us to Download and fetch data from different sources. We call this data ingestion

  Combine, clean, and model this data. We call this data wrangling

  https://support.microsoft.com/en-us/office/split-a-column-of-text-power-query-5282d425-6dd0-46ca-95bf-8e0da9539662

• Question 82:

  HOTSPOT

  You need to create a measure that returns the percent of revenue by product category.

  How should you complete the measure? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 83:

  You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4.

  Query1 loads customer data into the model and is referenced by the other three queries.

  You discover that data refresh for the model is slow.

  You need to improve the data refresh time. The solution must minimize costs.

  What should you do?

  A. Run the Table.buffer function in Query1.
  B. Duplicate Query1 to all the other queries.
  C. Reconfigure Query1 as a dataflow entity.
  D. From the Power BI Admin portal, increase the Capacity settings.
  C. Reconfigure Query1 as a dataflow entity.

• Question 84:

  You have a Power BI tenant.

  You have reports that use financial datasets and are exported as PDF files.

  You need to ensure that the reports are encrypted.

  What should you implement?

  A. dataset certifications
  B. row-level security (RLS)
  C. sensitivity labels
  D. Microsoft Intune policies
  C. sensitivity labels

  ---

  Explanation

  General availability of sensitivity labels in Power BI.

  Microsoft Information Protection sensitivity labels provide a simple way for your users to classify critical content in Power BI without compromising productivity or the ability to collaborate. Sensitivity labels can be applied on datasets, reports, dashboards, and dataflows. When data is exported from Power BI to Excel, PowerPoint or PDF files, Power BI automatically applies a sensitivity label on the exported file and protects it according to the label's file encryption settings. This way your sensitive data remains protected no matter where it is.

  https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-data-protection-ga-and-introducing-new-capabilities/

• Question 85:

  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:

  1. Visual 1: Displays the distribution of hierarchical data

  2. 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.

  Select and Place:

  

  

• Question 86:

  You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4.

  Query1 loads customer data into the model and is referenced by the other three queries.

  You discover that data refresh for the model is slow.

  You need to improve the data refresh time. The solution must minimize costs.

  What should you do?

  A. Run the Table. buffer function in Query 1.
  B. From the Power BI Admin portal. Increase the Capacity settings.
  C. Reconfigure Query1 as a dataflow entity.
  D. Duplicate Query1 to all the other queries.
  C. Reconfigure Query1 as a dataflow entity.

• Question 87:

  HOTSPOT

  How should you distribute the reports to the board? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 88:

  Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

  After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You are modeling data by using Microsoft Power Bl. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records.

  During the development process, you need to import a sample of the data from the Order table.

  Solution: You add a WHERE clause to the SQL statement.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 89:

  You plan to generate a line chart to visualize and compare the last six months of sales data for two departments.

  You need to increase the accessibility of the visual.

  What should you do?

  A. Configure a unique marker for each series.
  B. Configure a distinct color for each series.
  C. Replace long text with abbreviations and acronyms.
  D. Move important information to a tooltip.
  A. Configure a unique marker for each series.

• Question 90:

  HOTSPOT

  You are using Performance Analyzer to analyze the performance of a visual in a Power BI report.

  You need to identify the following log information:

  The time spent to retrieve data from the source

  The time required to wait for other visuals to complete

  Which task categories should you review? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.