Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 421:

  You are reviewing a query that produces 10,000 rows in the Power Query Editor.

  You need to identify whether a column contains only unique values.

  Which two Data Preview options can you use? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Column profile
  B. Column distribution
  C. Show whitespace
  D. Column quality
  E. Monospace
  A. Column profile
  B. Column distribution

  ---

  Explanation

  B: Column distribution: This feature provides a set of visuals underneath the names of the columns that showcase the frequency and distribution of the values in each of the columns. The data in these visualizations is sorted in descending order from the value with the highest frequency.

  By hovering over the distribution data in any of the columns, you get information about the overall data in the column (with distinct count and unique values).

  A: Column profile: This feature provides a more in-depth look at the data in a column [compared to column distribution]. Apart from the column distribution chart, it contains a column statistics chart.

  https://docs.microsoft.com/en-us/power-query/data-profiling-tools

• Question 422:

  HOTSPOT

  You are enhancing a Power BI model that has DAX calculations.

  You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.

  Which DAX functions should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  https://www.kasperonbi.com/get-the-ytd-of-the-same-period-last-year/

• Question 423:

  You have a Power BI semantic model that contains a table named Table1. Table1 contains the following columns:

  1. WebsiteName

  2. URL

  You need to create a report named Report1 that will contain a table visual. The solution must meet the following requirements:

  1. Display the website name.

  2. Enable users to navigate to the website's URL by selecting the website name.

  What should you use?

  A. data categories
  B. Conditional Formatting
  C. inline hierarchy labels
  D. URL icons
  B. Conditional Formatting

• Question 424:

  DRAG DROP

  You are modeling data in a table named SalesDetail by using Microsoft Power BI.

  You need to provide end users with access to the summary statistics about the SalesDetail data. The users require insights on the completeness of the data and the value distributions.

  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:

  

  

  ---

  Step 1: Create a blank query as a data source

  Start with a New Source in Power Query Editor, and then Blank Query.

  

  Create a parameter that use a query for suggested values.

  Step 2: Specify the following query, then close and apply. -Table.Profile(#SalesDetail")

  In the new blank query, in the formula bar (if you don't see the formula bar, check the formula bar option in the View tab of the Power Query Editor), type below expression:

  =Table.Profile()

  Note that this code is not complete yet, we need to provide a table as the input of this function.

  Note: The Table.Profile() function takes a value of type table and returns a table that displays, for each column in the original table, the minimum, maximum, average, standard deviation, count of values, count of null values and count of distinct values.

  Step 3: Create a visual for the query table.

  The profiling data that you get from Table.Profile function is like below;

  

  After loading the data into Power BI, you'll have the table with all columns, and it can be used in any visuals.

  https://radacad.com/create-a-profiling-report-in-power-bi-give-the-end-user-information-about-the-data

• Question 425:

  A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuery to access tables from an on premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow.

  You need to use the dataflow in a report. The solution must meet the following requirements:

  1. Minimize online processing operations.

  2. Minimize calculation times and render times for visuals.

  3. include data from the current year, up to and including the previous day.

  What should you do?

  A. Create a dataflows connection that has Import mode selected and schedule a dairy refresh.
  B. Create a dataflows connection that has DirectQuery mode selected.
  C. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset
  D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.
  A. Create a dataflows connection that has Import mode selected and schedule a dairy refresh.

• Question 426:

  You have a Microsoft 365 subscription that contains the resources shown in the following table.

  

  You create a new dashboard that uses row-level security (RLS) filters. You define a new role named Consultants.

  To which resource can you assign the Consultants role?

  A. Group2
  B. Team1
  C. Sales reports
  D. Group1
  A. Group2

• Question 427:

  HOTSPOT

  You are profiling data by using Power Query Editor.

  You have a table that contains a column named column1. Column statistics and Value distribution for column1 are 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.

  

  

  ---

  Box 1: are 20 values that occur - There are 20 unique values.

  Box 2: Elm, American - Elm, American is below Peer, flowering species in the graphic.

• Question 428:

  You have a query in Power Query Editor that contains the following data.

  

  You need to transform the data to appear as shown in the following table.

  

  What should you do?

  A. Split the Classes column into rows by using a delimiter.
  B. Unpivot the Classes column.
  C. Extract the text between delimiters in the Classes column.
  D. Convert the Classes column into a list.
  A. Split the Classes column into rows by using a delimiter.

• Question 429:

  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 have a Microsoft Excel workbook that is saved to Microsoft SharePoint Online. The workbook contains several Power View sheets.

  You need to recreate the Power View sheets as reports in the Power Bl service.

  Solution: From the Power Bl service, get the data from SharePoint Online, and then click Connect Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  We need to click "Import", not "Connect".

  References:

  https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files

• Question 430:

  HOTSPOT

  You have a Power Bl report.

  You have the following tables.

  

  You have the following DAX measure.

  Accounts := CALCULATE ( DISTINCTCOUNT (Balances[AccountID]), LASTDATE ('Date'[Date])

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: No

  It will show the total number of accounts that were live at the last day of the year only.

  Note:

  DISTINCTCOUNT counts the number of distinct values in a column.

  LASTDATE returns the last date in the current context for the specified column of dates.

  Box 2: No

  It will show the total number of accounts that were live at the last day of the month only.

  Box 3: Yes

  https://docs.microsoft.com/en-us/dax/distinctcount-function-dax

  https://docs.microsoft.com/en-us/dax/lastdate-function-dax