Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 481:

  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:

  

  

  ---

  References:

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

• Question 482:

  You have a Power B1 report that contains one visual You need to provide users with the ability to change the visual type without affecting the view for other users.

  What should you do?

  A. From Tabular Editor, create a new perspective.
  B. From Report settings, select Personalize visuals
  C. From the Bookmarks pane, select Focus mode and then select Add
  D. From Visual options in Report settings, select Use the modem visual header with updated styling options
  B. From Report settings, select Personalize visuals

• Question 483:

  You plan to create a Power BI report that will be connected to multiple data sources. One of the data sources contains tax records.

  You need to ensure that other queries cannot access the tax record information.

  To what should you set Privacy Level for the data source?

  A. Public
  B. Organizational
  C. Private
  D. None
  C. Private

• Question 484:

  HOTSPOT

  You have a Power BI semantic model that contains two tables named Sales and Forecast. Both tables contain a date column.

  You need to create a calculated table that will cover the range of dates in both tables.

  How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 485:

  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. Use a live function lot the file.
  B. From the Power BI service, apply a sensitivity label.
  C. Certify the semantic model and the report.
  D. From Microsoft Power BI Desktop, apply a sensitivity label.
  D. From Microsoft Power BI Desktop, apply a sensitivity label.

• Question 486:

  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 median line by using the Salary measure.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  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_median.php

• Question 487:

  HOTSPOT

  You have a Power BI semantic model that contains two tables as 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.

  

  

• Question 488:

  You have a Power BI report that contains one page. The page contains two line charts and one bar chart.

  You need to ensure that users can perform the following tasks for all three visuals:

  1. Switch the measures used in the visuals.

  2. Change the visualization type.

  3. Add a legend.

  The solution must minimize development effort.

  What should you do?

  A. Enable personalization for each Visual.
  B. Create a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart
  C. Edit the interactions between the three visuals.
  D. Enable personalization for the report
  D. Enable personalization for the report

• Question 489:

  HOTSPOT

  You use Power Query Editor to preview the data in a column named Resource Location.

  The column statistics and value distributions of Resource Location appear as 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.

  

  

• Question 490:

  You need to update the Power BI model to ensure that the analysts can quickly build drill-downs from business unit to product in a visual.

  What should you create?

  A. a group
  B. a calculated table
  C. a hierarchy
  D. a calculated column
  C. a hierarchy