Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 241:

  You have a Power Bl workspace named Inventory that contains a dataset a report and a dashboard.

  You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.

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

  NOTE: Each correct selection is worth one point.

  A. Use quick insights on the dashboard.
  B. Hide the report page.
  C. Ask a question by using Q&A.
  D. Add the visual to the report.
  E. Pin the visual to the dashboard.
  A. Use quick insights on the dashboard.
  C. Ask a question by using Q&A.

• Question 242:

  DRAG DROP

  You build a report about warehouse inventory data. The dataset has more than 10 million product records from 200 warehouses worldwide.

  You have a table named Products that contains the columns shown in the following table.

  

  Warehouse managers report that it is difficult to use the report because the report uses only the product name in tables and visuals. The product name is contained within the ProductDescription column and is always the fourth value.

  You need to modify the report to support the warehouse managers requirement to explore inventory levels at different levels of the product hierarchy. The solution must minimize the model size.

  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:

  

  

  ---

  Power BI Desktop supports the use of inline hierarchy labels. With inline hierarchy labels, you can see hierarchy labels as you expand visuals using the Expand All feature.

  https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-inline-hierarchy-labels

• Question 243:

  You have a Fabric workspace named Workspace1 that contains two Power BI reports named Report1 and Report2.

  You create a workspace app that contains both reports.

  You need to ensure that the app meets the following requirements:

  1. Report1 must be visible to all the users in your organization.

  2. Report2 must be visible to only a security group named Group1.

  What should you do next?

  A. Assign Group1 the Viewer role for Workspace1.
  B. Create an audience and assign Group1 to the audience.
  C. Allow access to the hidden content of the app.
  D. Share Report1 with the built-in All users security group.
  B. Create an audience and assign Group1 to the audience.

• Question 244:

  You need to create a visual that compares profit across 10 product categories for a selected quarter.

  What is the best visual to use to achieve the goal? More than one answer choice may achieve the goal Select the BEST answer.

  A. an area chart
  B. a clustered bar chart
  C. a line chart
  D. a funnel chart
  B. a clustered bar chart

• Question 245:

  HOTSPOT

  You have a power BI tenant that hosts the datasets shown in the following table.

  

  You have the following requirements:

  1. The export of reports that contain Personally Identifiable Information (Pll) must be prevented.

  2. Data used for financial decisions must be reviewed and approved before use.

  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 246:

  What should you do to address the existing environment data concerns?

  A. a calculated column that uses the following formula: ABS(Sales[sales_amount])
  B. a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])
  C. a measure that uses the following formula: SUM(Sales[sales_amount])
  D. a calculated column that uses the following formula: IF(ISBLANK(Sales[sales_amount]),0, (Sales[sales_amount]))
  B. a measure that uses the following formula: SUMX(FILTER('Sales', 'Sales'[sales_amount] > 0)),[sales_amount])

• Question 247:

  You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month.

  Which visual should you use?

  A. a line chart
  B. a stacked bar chart
  C. a 100% stacked bar chart
  D. a waterfall chart
  B. a stacked bar chart

• Question 248:

  HOTSPOT

  You have a Power BI semantic model named Model1 that will be used to support reports viewed in the Power BI service.

  Model1 contains data from the following sources:

  1. An Azure SQL database that is accessible only via a private endpoint

  2. A Microsoft Excel file stored in Microsoft SharePoint Online

  3. A Microsoft SQL Server database in a private datacenter

  You need to publish Model1 and schedule the model to refresh 12 times a day.

  How many data sources require a data gateway, and which license mode will the workspace require to support the scheduled refresh? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 249:

  You are configuring a Power BI report for accessibility as shown in the following table.

  

  You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency.

  Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. First-level elements colors
  B. Theme colors
  C. Divergent colors
  D. Sentiment colors
  B. Theme colors
  C. Divergent colors

• Question 250:

  HOTSPOT

  You have a Power Bl visual that uses indicators to show values that are out of range 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.

  

  

  ---

  Box 1: a line -

  Incorrect: * not line and clustered column

  The Line and Clustered Column Chart is a combo charts that combines the Line chart and Column chart together in one visual. By combining these two visuals together, you can make a very quick comparison between two sets of measures.

  

  Box 2: anomaly detection - Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis. With just a couple of clicks, you can easily find insights without slicing and dicing the data.

  Example:

  

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