Microsoft Microsoft Certifications PL-300 Questions & Answers

• Question 221:

  DRAG DROP

  Note: This question is a part of a series of questions that present the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is

  exactly the same in each question in this series.

  Start of repeated scenario

  You have a Microsoft SQL Server database that has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

  

  You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

  

  You plan to use Power BI to import data from 2013 to 2015.

  Product Subcategory [Subcategory] contains NULL values.

  End of repeated scenario.

  You implement the Power BI model.

  You need to edit the Product Category table query to match the desired Power BI model.

  How should you complete the advanced query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.

  You may need to frag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  Correct Answer:

  

• Question 222:

  DRAG DROP

  You have a folder that contains 100 CSV files.

  You need to make the file metadata available as a single dataset by using Power Bi The solution must NOT store the data of the CSV files.

  Which three actions should you perform in sequence. To answer, mow the appropriate actions from the list of actions to the answer area and arrange them m the correct order.

  NOTE; More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

  Select and Place:

  

  Correct Answer:

  

• Question 223:

  DRAG DROP

  You are creating a Power Bi model and report.

  You have a single table in a data mode) named Product Product contains the following fields:

  1.

  ID

  2.

  Name

  3.

  Color

  4.

  Category

  5.

  Total Sales You need to create a calculated table that shows only the top eight products based on the highest value in Total Sales. How should you complete the DAX expression? To answer, drag the appropriate values to the coned targets. Each value 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.

  Select and Place:

  

  Correct Answer:

  

• Question 224:

  DRAG DROP

  You have a Power Bl table named Customer that contains a field named Email Address.

  You discover that multiple records contain the same email address.

  You need to create a calculated column to identify which records have duplicate email addresses.

  How should you complete the OAX expression for the calculated column? To answer, drag the appropriate values to the correct targets. Each value 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:

  

  Correct Answer:

  

  You are to count the number of rows having same email address.

  1.

  Declare a variable and call it any name you prefer

  2.

  Calculate the row count on the table

  3.

  Apply filter to ALL of the values in the table under the column name email address and equate it to the variable. You may need to read up filter functions for a proper understanding of how it works.

• Question 225:

  DRAG DROP

  You have a Microsoft Excel workbook that contains two tables.

  From Power BI, you create a dashboard that displays data from the tables.

  You update the tables each day.

  You need to ensure that the virtualizations in the dashboard are updated daily.

  Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to answer area and arrange them in the correct order.

  Select and Place:

  

  Correct Answer:

  

  References: https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

• Question 226:

  DRAG DROP

  You are preparing a financial report in Power BI.

  You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.

  

  You need to prepare the data to support the following:

  1.

  Visualizations that include all measures in the data over time

  2.

  Year-over-year calculations for all the measures

  Which four 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.

  Select and Place:

  

  Correct Answer:

  

  1.

  Use first row as header

  2.

  Unpivot all columns other than "Measure"

  3.

  Rename "Attribute" to "Year"

  4.

  Change data type of "Year" to date (Date > Year)

  Reference: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098

• Question 227:

  DRAG DROP

  You have a Power BI model that contains a table named Sales. Sales has the following three measures:

  A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million. A measure named Total Sales This Year that displays the sales from the current calendar year. The current value is 11.69 million. A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] ?Sales[This Year].

  You need to create the following visualization.

  

  How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value 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:

  

  Correct Answer:

  

  References: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

• Question 228:

  DRAG DROP

  You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

  

  Each file contains deltas of any new or modified rows from each load to the data lake.

  Multiple files can have the same customer ID.

  You need to keep only the last modified row for each customer ID.

  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.

  Select and Place:

  

  Correct Answer:

  

  1) Duplicate Customer query

  2) Group by CustId by Max ModifiedDate (only 2 columns to keep)

  3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

• Question 229:

  DRAG DROP

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

  

  You need to modify the chart to meet the following requirements:

  1.

  Identify months that have order counts above the mean.

  2.

  Display the mean monthly order count.

  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.

  Select and Place:

  

  Correct Answer:

  

  1.

  Select the line chart

  2.

  Add the average line

  3.

  Turn on Data Label

  Reference: https://community.powerbi.com/t5/Desktop/Moving-Average/td-p/43041

• Question 230:

  DRAG DROP

  You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.

  You need to build the dashboard.

  Which four 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.

  Select and Place:

  

  Correct Answer:

  

  When you view dashboards in portrait mode on a phone, you notice the dashboard tiles are laid out one after another, all the same size. In the Power BI service, you can create a customized view of a dashboard, specifically for portrait mode

  on phones.

  Step 1: Open the Dashboard.

  Step 2: Change the dashboard view to Phone view

  Step 3: Pin items from the reports to the dashboard.

  Step 4: Rearrange, resize, or remote items from the Phone view.

  Create a phone view of a dashboard

  1.

  In the Power BI service, open a dashboard (Step 1)

  2.

  Select the arrow next to Web view in the upper-right corner > select Phone view. (Step2)

  

  The phone dashboard edit view opens. Here you can unpin, resize, and rearrange tiles to fit the phone view. The web version of the dashboard doesn't change.

  3.

  Select a tile to drag, resize, or unpin it. You notice the other tiles move out of the way as you drag a tile. The unpinned tiles go in the Unpinned tiles pane, where they stay unless you add them back.

  4.

  If you change your mind, select Reset tiles to put them back in the size and order they were before.

  5.

  When you're satisfied with the phone dashboard layout, select the arrow next to Phone view in the upper-right corner > select Web view.

  Power BI saves the phone layout automatically.