Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 221:

  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 222:

  You have the visual shown in the exhibit. (Click the Exhibit tab.)

  

  You need to show the relationship between Total Cost and Total Sales over time.

  What should you do?

  A. Add a play axis.
  B. Add a slicer for the year.
  C. From the Analytics pane, add an Average line.
  D. Create a DAX measure that calculates year-over-year growth.
  A. Add a play axis.

  ---

  Explanation

  When to use a slicer

  Slicers are a great choice when you want to: Display commonly used or important filters on the report canvas for easier access.

  Make it easier to see the current filtered state without having to open a drop-down list.

  Filter by columns that are unneeded and hidden in the data tables.

  Create more focused reports by putting slicers next to important visuals.

  Note: Suppose you want your report readers to be able to look at overall sales metrics, but also highlight performance for individual district managers and different time frames. You could create separate reports or comparative charts. You could add filters in the Filters pane. Or you could use slicers. Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

• Question 223:

  DRAG DROP

  You use Power Query Editor to import three tables named Customers, Address, and Country.

  In the source system, not every customer has a related address, but every address has a related country.

  You need to merge all the tables into a single query. The solution must optimize query refresh performance.

  Which type of join should you use for each merge operation? To answer, drag the appropriate join types to the correct operations. Each join 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 224:

  For the sales department at your company, you publish a Power Bl report and a semantic model that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.

  The semantic model contains several measures.

  You need to create a new Power Bl report from the existing data that will use many of the measures created in the initial Power Bl semantic model.

  The solution must minimize development effort.

  Which type of data source should you use?

  A. an Excel workbook
  B. a ShaiePoint folder
  C. Power Bl dataset
  D. Power Bl dataflows
  B. a ShaiePoint folder

• Question 225:

  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?

  A. the tab order
  B. alt text
  C. conditional formatting
  D. the layer order
  B. alt text

• Question 226:

  HOTSPOT

  You have a Power BI model that contains a table named Sales and a related date table. Sales contains a measure named Total Sales.

  You need to create a measure that calculates the total sales from the equivalent month of the previous year.

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 227:

  You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success.

  Which type of visualization should you use?

  A. Key influences
  B. Funnel chart
  C. Q&A
  D. Line and clustered column chart
  A. Key influences

  ---

  Explanation

  The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers.

  The key influencers visual is a great choice if you want to: See which factors affect the metric being analyzed. Contrast the relative importance of these factors. For example, do short-term contracts have more impact on churn than long-term contracts?

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

• Question 228:

  You have a Power BI report named ReportA.

  You have a Power BI tenant that allows users to export data.

  You need to ensure that consumers of ReportA cannot export 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.

  A. From Power BI Desktop, modify the Report settings.
  B. From Power BI Desktop, modify the Data Load settings.
  C. From the Power BI service, modify the dataset permissions.
  D. From the Power BI service, modify the Report settings.
  A. From Power BI Desktop, modify the Report settings.
  D. From the Power BI service, modify the Report settings.

• Question 229:

  HOTSPOT

  You have a Power BI semantic model named Model1.

  You need to create a measure that will display the sales result for all blue units. The solution must maintain the existing filter context.

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 230:

  You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.

  The reports display the data configured as shown in the following table.

  

  You need to ensure that the users of the reports can locate the correct report by using natural language queries.

  What should you do?

  A. From the properties of the dataset, create four Featured Q&A Questions.
  B. From the Format settings of the reports, modify the Page Information.
  C. From the properties of the dataset, modify the Q&A and Cortana settings.
  D. From the properties of the workspace, modify the Language Settings.
  C. From the properties of the dataset, modify the Q&A and Cortana settings.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/service-q-and-a-direct-query#limitations-during-public-preview