Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 401:

  You have a Power B1 report that contains a card. The card displays the value for year-to- date revenue.

  You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed.

  What should you do?

  A. Populate the alt text by using conditional formatting with a DAX measure.
  B. Add the value to the chart title text.
  C. Convert the card into a text box.
  D. Populate the alt text with a static value.
  A. Populate the alt text by using conditional formatting with a DAX measure.

• Question 402:

  You have a Power BI model that contains a table named Employees. The table contains the following columns:

  1. Employee ID

  2. First Name

  3. Last Name

  4. Department

  5. Salary

  Each employee is uniquely identified by using Employee ID.

  You need to create a DAX measure that will calculate the average salary of all the employees in the sales department.

  Which DAX expression should you use?

  A. DISTINCTCOUNT(`Employees'[Salary])
  B. CALCULATE(DISTINCTCOUNT(`Employees'[Salary]), `Employees'[Department] = "Sales")
  C. CALCULATE(AVERAGE(`Employees'[Salary]), `Employees'[Department] = "Sales")
  D. AVERAGE(`Employees'[Salary])
  C. CALCULATE(AVERAGE(`Employees'[Salary]), `Employees'[Department] = "Sales")

• Question 403:

  HOTSPOT

  You use Microsoft Power BI Desktop to review the data 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 404:

  You have a Power BI report that contains four pages.

  All the pages contain a slicer for a field named Country,

  You need to ensure that when a user selects a county on page l, the selection is retained on page 2 and page 3.

  The solution must prevent page 4 from being affected by selections on the other pages, What should you do?

  A. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the report-level filters.
  B. Remove the Country slicer from page 1, page 2, and page 3. Add the Country field to the page-level filters.
  C. Sync the Country slicer on page 1, page 2, and page 3,
  D. Move the Country slicer from page 2 and page 3 to page 1.
  C. Sync the Country slicer on page 1, page 2, and page 3,

• Question 405:

  DRAG DROP

  You have a Power Bl workspace that contains a single-page report named Sales.

  You need to add all the visuals from Sales to a dashboard. The solution must ensure that additional visuals added to the page are added automatically to the dashboard.

  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:

  

  

  ---

  An entire report page can be pinned to a dashboard, which is called pinning a live tile. It's called a live tile because you can interact with the tile on the dashboard.

  Unlike with individual visualization tiles, changes made in the report are automatically synced with the dashboard.

  Step 2: Open the Sales report -

  Step 3: Pin the page.

  1. Open a report in Editing view.

  2. With no visualizations selected, from the menu bar, select Pin to a dashboard.

  3. Pin the tile to an existing dashboard or to a new dashboard. Notice the highlighted text: Pin live page enables changes to reports to appear in the dashboard tile when the page is refreshed.

  

  4. Select Pin live. A Success message (near the top right corner) lets you know the page was added, as a tile, to your dashboard.

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

• Question 406:

  You are creating a dashboard by using the Power Bl service.

  You have an existing report page that contains three charts.

  You need to add the charts to the dashboard while maintaining the interactivity between the charts.

  What should you do?

  A. Pin each chart as a tile.
  B. Edit interactions in the report and set all interactions to Filter
  C. Edit the dashboard theme and pin each chart as a file.
  D. Pin the report page as a live tile.
  D. Pin the report page as a live tile.

• Question 407:

  You have a Power Bl query named Sates that imports the columns shown in the following table.

  

  Usees only use the dale part of the Sales.Date field. Only rows with a Status of Finished are used in analysis.

  You need to reduce the load times of the query without affecting the analysis.

  Which two actions achieve this goal? Each correct answer presents a complete solution.

  NOTL Each correct selection is worth one pant.

  A. Remove the rows in which sales [status] has a value of Canceled.
  B. Change the data type of sale [Delivery_Time] to Integer
  C. Removes (Canceled Date).
  D. Split Sales [Sale_Date] into separate date and time columns.
  E. Remove sales [Sales_Date].
  A. Remove the rows in which sales [status] has a value of Canceled.
  E. Remove sales [Sales_Date].

  ---

  Explanation

  It says: You need to reduce the LOAD times of the query without affecting the analysis. Only answers A and E can reduce the load times. D may reduce only the time needed to process the data. Someone said that E is not the answer because: "All the cancelled rows are already deleted with A and when a order is not cancelled it will contain a null value". You must read again the decription cause it says " Each answer presents a COMPLETE solutiuon" not part of a solution.

• Question 408:

  HOTSPOT

  You have the Azure SQL databases shown in the following table.

  

  You plan to build a single PBIX file to meet the following requirements:

  1. Data must be consumed from the database that corresponds to each stage of the development lifecycle.

  2. Power Bl deployment pipelines must NOT be used.

  3. The solution must minimize administrative effort.

  What should you do? To answer, select the appropriate options in the answer area.

  

  

• Question 409:

  You have an app workspace named Retail Analysis in the Power BI service.

  You need manage the members that have access to the app workspace.

  What should you do?

  A. From the Power BI Admin portal, click Usage metrics.
  B. From the Office 365 Admin center, click Users.
  C. From the Office 365 Admin center, click Groups.
  D. From the Power BI Admin portal, click Tenant settings.
  C. From the Office 365 Admin center, click Groups.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/service-manage-app-workspace-in-power-bi-and-office-365

• Question 410:

  You have a Power Bl workspace that contains a dataset. a report, and a dashboard. The following groups have access:

  1. External users can access the dashboard.

  2. Managers can access the dashboard and a manager-specific report.

  3. Employees can access the dashboard and a row-level security (RLS) constrained report.

  You need all users, including the external users, to be able to tag workspace administrators if they identify an issue with the dashboard. The solution must ensure that other users see the issues that were raised.

  What should you use?

  A. subscriptions
  B. comments
  C. alerts
  D. chat in Microsoft Teams
  B. comments

  ---

  Explanation

  Add a personal comment or start a conversation about a dashboard or report with your colleagues. The comment feature is just one of the ways a business user can collaborate with others.

  Note: Comments can be added to an entire dashboard, to individual visuals on a dashboard, to a report page, to a paginated report, and to individual visuals on a report page. Add a general comment or add a comment targeted at specific colleagues.

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