Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 431:

  You have a BI dataset and a connected report.

  You need to ensure that users can analyze data in Microsoft Excel by connecting directly to the dataset.

  You grant the users the Build permission for dataset What Should do next?

  A. Change default visual interaction for the report
  B. For the report change the Export data setting to Summarized data, data with current layout and underlying data
  C. For the report, change the Export data setting to None
  D. Certify the dataset used by the report.
  C. For the report, change the Export data setting to None

  ---

  Explanation

  Note the part of the question that says "ONLY by connecting directly to the dataset." As mentioned in

  https://www.designmind.com/blog/business-intelligence/export-underlying-data-in-power-bi,

  "You should export summarized data when you want to see the relevant data in the visualization." Therefore, D cannot be the right answer, as summarized data is not obtained from connecting directly to the dataset, but rather by effectively filtering the dataset based on the contents of the visualization.

• Question 432:

  DRAG DROP

  You have a Power BI report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to 5.

  You need to format the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.

  

  Which three actions should you perform in sequence in Power BI Desktop? 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:

  

  

• Question 433:

  You are creating a visual in a Power BI report. The associated semantic model contains sales from the last four years for three products.

  You need to display the total sales by quarter categorized by product. The visual must display trends in both total sales and individual product sales.

  Which type of visual should you use?

  A. area chart
  B. clustered column chart
  C. stacked area chart
  D. line chart
  C. stacked area chart

• Question 434:

  You need to create a calculated column to display the month based on the reporting requirements.

  Which DAX expression should you use?

  A. FORMAT('Date'[date], "MMM YYYY")
  B. FORMAT('Date' [date], "M YY")
  C. FORMAT('Date'[date_id], "MMM") & "" & FORMAT('Date'[year], "#")
  D. FORMAT('Date' [date_id], "MMM YYYY")
  A. FORMAT('Date'[date], "MMM YYYY")

  ---

  Explanation

  Scenario: In the Date table, the date_id column has a format of yyyymmdd. Users must be able to see the month in reports as shown in the following example: Feb 2020.

  Incorrect Answers:

  B: The output format should be "MMM YYYY" not "M YY"

  C, D: The data_id is an integer and not a Date datatype.

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

  https://dax.guide/format/

• Question 435:

  HOTSPOT

  You are creating a column chart visualization.

  You configure groups as shown in the Groups exhibit. {Click the Groups tab.)

  

  The visualization appears as shown in the Chart exhibit. (Click the Chart tab.)

  

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 436:

  You need to get data from the Microsoft SQL Server tables.

  What should you use to configure the connection?

  A. import that uses a Microsoft account
  B. DirectQuery that uses the end-user s credentials
  C. DirectQuery that uses a database credential
  D. Import that uses a database credential
  C. DirectQuery that uses a database credential

• Question 437:

  You plan to use Power Bl Desktop to create a bog tracking dashboard that will pull data from Analytics in Azure DevOps.

  From Power Bl Desktop, you need to configure a data connector to authenticate to Azure DevOps. The solution must meet the following requirements:

  1. Use Analytics views.

  2. Filter data from the cloud.

  Which connector should you use?

  A. OData queries
  B. Azure DevOps (Boards only)
  C. Azure DevOps Server (Boards only)
  D. OData feed
  B. Azure DevOps (Boards only)

• Question 438:

  HOTSPOT

  You are profiling data by using Power Query Editor.

  You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data m State is 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: 69

  69 distinct/different values.

  Note: Column Distribution allows you to get a sense for the overall distribution of values within a column in your data previews, including the count of distinct values (total number of different values found in a given column) and unique values (total number of values that only appear once in a given column).

  Box 2: 4

  https://systemmanagement.ro/2018/10/16/power-bi-data-profiling-distinct-vs-unique/

• Question 439:

  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 scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

  You have several reports and dashboards in a workspace.

  You need to grant all organizational users read access to a dashboard and several reports.

  Solution: You assign all the users the Viewer role to the workspace.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  "You have five reports and two dashboards in a workspace. You need to grant all organizational users read access to one dashboard and three reports"

• Question 440:

  You are building a Power BI report to analyze customer segments.

  You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort.

  Which type of visualization should you use?

  A. decomposition tree
  B. funnel chart
  C. Q&A
  D. key influencers
  D. key influencers

  ---

  Explanation

  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 affect churn more than long-term contracts?

  Note: 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. For example, suppose you want to figure out what influences employee turnover, which is also known as churn. One factor might be employment contract length, and another factor might be commute time.

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