Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 251:

  You create a Power Bl report named Summary.

  You discover that Summary is slow.

  You run Performance analyzer to identify performance metrics for Summary.

  Which two metrics display the execution duration in Performance analyzer?

  Each correct answer present part of the solution. NOTE: Each correct answer is worth one point.

  A. Top Operations
  B. Dependencies
  C. Server requests
  D. DAX query
  E. Visual display
  D. DAX query
  E. Visual display

• Question 252:

  You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

  

  Which type of visual should you use?

  A. Q&A
  B. decomposition tree
  C. smart narrative
  D. key influencers
  B. decomposition tree

  ---

  Explanation

  The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. It is also an artificial intelligence (AI) visualization, so you can ask it to find the next dimension to drill down into based on certain criteria.

  This makes it a valuable tool for ad hoc exploration and conducting root cause analysis.

  Example:

  

• Question 253:

  DRAG DROP

  You are using Power BI Desktop to profile data in Power Query Editor.

  You need to review the percentage of errors and the maximum value of each column.

  Which options should you use in Power Query Editor? To answer, drag the appropriate options to the correct requirements. Each option 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 254:

  You are developing a report page. Some users will navigate the report by using a keyboard, and some users will consume the report by using a screen reader. You need to ensure that the users can consume the content on a report page in a logical order.

  What should you configure in Microsoft Power Bl Desktop?

  A. the bookmark order
  B. the layer order
  C. the tab order
  D. the X position
  C. the tab order

  ---

  Explanation

  If you find yourself unable to navigate to an object or visual while using a keyboard, it may be because the report author has decided to hide that object from the tab order. Report authors commonly hide decorative objects from the tab order. If you find that you cannot tab through a report in a logical manner, you should contact the report author. Report authors can set the tab order for objects and visuals.

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-consuming-tools

• Question 255:

  You have a PBIX file that contains sensitive information.

  You need to secure the information to meet the following requirements:

  1. Only internal users must be able to open the file if the file is shared via email.

  2. Once the file is published, only internal users must be able to open the semantic model and the report downloaded from the Power BI service.

  What should you do?

  A. From Microsoft Power BI Desktop, apply a sensitivity label.
  B. Certify the semantic model and the report.
  C. Use a live connection for the file.
  D. From the Power BI service, apply a sensitivity label.
  A. From Microsoft Power BI Desktop, apply a sensitivity label.

• Question 256:

  HOTSPOT

  You have a table that contains a column named Phone. The following is a sample of the data in the Phone column.

  

  You need to add a new column that contains the data in the format of nnn-nnn-nnnn.

  How should you complete the Query Editor formula? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  References:

  https://docs.microsoft.com/en-us/powerquery-m/text-replace

  https://docs.microsoft.com/en-us/powerquery-m/text-end

• Question 257:

  You are creating a query to be used as a Country dimension in a star schema.

  A snapshot of the source data is shown in the following table.

  

  You need to create the dimension.

  The dimension must contain a list of unique countries.

  Which two actions should you perform? Each correct answer presents part of the solution.

  A. Remove duplicates from the Country column.
  B. Remove duplicates from the City column.
  C. Remove duplicates from the table.
  D. Delete the City column.
  E. Delete the Country column.
  A. Remove duplicates from the Country column.
  D. Delete the City column.

  ---

  Explanation

  To create a dimension table for Country from your source data, you need to perform these two actions34: Delete the City column. You don't need this column for your Country dimension, as it is not a descriptive attribute of Country. You can create another dimension table for City if you want to use it in your analysis. Remove duplicates from the Country column. You want to have a list of unique countries in your dimension table, so you need to remove any duplicate values from this column.

• Question 258:

  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 (RIS) 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. Group 1
  C. Sales reports

• Question 259:

  HOTSPOT

  You need to calculate the last day of the month in the balance sheet data to ensure that you can relate the balance sheet data to the Date table.

  Which type of calculation and which formula should you use? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: A DAX Calculated measure

  Box 2: Date.EndofQuarter(#date([Year],[Mont],1)) ENDOFQUARTER returns the last date of the quarter in the current context for the specified column of dates.

  The following sample formula creates a measure that returns the end of the quarter, for the current context.

  = ENDOFQUARTER(DateTime[DateKey]) Reference:

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

• Question 260:

  You have a CSV file that contains user complaints. The file contains a column named Logged, logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

  You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

  What should you do?

  A. Create a column by example that starts with 2018-12-31.
  B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  C. Apply the parse function from the Date transformations options to the Logged column.
  D. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.
  B. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date