Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 31:

  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 an on-premises data gateway.

  You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

  Solution: You configure incremental refresh.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 32:

  You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.

  What should you recommend?

  A. Create a shared dataset for each standardized entity.
  B. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.
  C. For every report, create and use a single shared dataset that contains the standardized data.
  D. For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.
  B. Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

• Question 33:

  HOTSPOT

  You have a Power B1 report that contains the table visual shown in the following exhibit.

  

  You need to modify the visual to display as shown in the following exhibit.

  

  How should you configure the visual? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 34:

  You have a Power Bi report. The report contains a visual that snows gross sales by date.

  The visual has anomaly detection enabled.

  No anomalies ate detected

  You need to increase the likelihood that anomaly detection will identify anomalies in the report.

  What should you do?

  A. Add a data field to the Secondary values field weft
  B. Increase the Sensitivity setting.
  C. Increase the Expected range transparency setting,
  D. Add a data field to the Legend field well
  B. Increase the Sensitivity setting.

  ---

  Explanation

  If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly.

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

• Question 35:

  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 a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as numerical amount representing US dollars.

  You need to create a reference line to show which employees are above the median salary.

  Solution: You create a constant line and set the value to .5.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  Instead create a percentile line by using the Salary measure and set the percentile to 50%.

  Note: The 50th percentile is also known as the median or middle value where 50 percent of observations fall below.

  https://dash-intel.com/powerbi/statistical_functions_percentile.php

• Question 36:

  DRAG DROP

  You have a Microsoft Power BI data model that contains three tables named Sales, Product, and Date.

  The Sales table has an existing measure named [Total Sales] that sums the total sales from the Sales table.

  You need to write a calculation that returns the percentage of total sales that a selected ProductCategoryName value represents. The calculation must respect any slicers on ProductCategoryName and must show the percentage of visible total sales. For example, if there are four ProductCategoryName values, and a user filters one out, a table showing ProductCategoryName and the calculation must sum up to 100 percent.

  How should you complete the calculation? 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:

  

  

  ---

  Box 1: DIVIDE

  As a data modeler, when you write a DAX expression to divide a numerator by a denominator, you can choose to use the DIVIDE function or the divide operator (/ - forward slash). When using the DIVIDE function, you must pass in numerator and denominator expressions.

  Box 2: CALCULATE

  CALCULATE rvaluates an expression in a modified filter context.

  Box 3: ALLSELECTED

  ALLSELECTED removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

  The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries.

  Example:

  measure 'Reseller Sales'[Reseller Visual Total]=calculate(sum('Reseller Sales'[Sales Amount]), ALLSELECTED())

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

• Question 37:

  Your organization has a team of power users who recently created 20 Power BI dashboards.

  The power users share the dashboards with other users in the organization.

  When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

  

  You need to ensure that all the users can access the dashboards.

  What should you do first?

  A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.
  B. From the Power BI Admin portal, modify the Privacy Settings.
  C. From the properties of each dashboard, modify the Share dashboard settings.
  D. Instruct each user to install Microsoft Office 2016.
  A. From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

  ---

  Explanation

  References:

  http://www.nubo.eu/en/blog/2016/12/Enable-PowerBI-On-Office-365/

• Question 38:

  You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.

  You need to create a Power BI report that connects to the project management app.

  Which connector should you select?

  A. Microsoft Teams Personal Analytics
  B. SQL Server database
  C. Dataverse
  D. Dataflows
  C. Dataverse

• Question 39:

  HOTSPOT

  You have a Power BI semantic model that contains the following tables.

  

  All the tables use the same data source.

  You need to reduce the number of limited relationships in the model by changing the storage mode of certain tables. The solution must NOT affect the latency of the data.

  Which storage mode should you select for the Customer and Geography tables? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 40:

  You have a Microsoft Power Bl dashboard.

  You need to ensure that consumers of the dashboard can give you feedback that will be visible to the other consumers of the dashboard.

  What should you use?

  A. Feedback
  B. Subscribe
  C. Comments
  D. Mark as favorite
  C. Comments

  ---

  Explanation

  https://docs.microsoft.com/en-us/power-bi/consumer/end-user-comment