Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 321:

  HOTSPOT

  You have the Power BI data model 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 322:

  You have a Power BI workspace named BI Data that contains a dataset named BI Finance.

  You have the Build permission for the 81 Finance dataset but you do NOT have permissions for the workspace,

  You need to connect to BI Finance and create a report.

  Which actions should you perform? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. From the Power BI service, create a dataflow to the dataset by using DirectQuery.
  B. From Power BI Desktop, connect to a Dataverse data source.
  C. From the Power BI service, create a new report and select a published dataset
  D. From Power Bl Desktop, connect to a shared dataset
  C. From the Power BI service, create a new report and select a published dataset
  D. From Power Bl Desktop, connect to a shared dataset

• Question 323:

  You have two Power Bl reports named ReportA and ReportB that each uses a distinct color palette.

  You are creating a Power Bl dashboard that will include two visuals from each report

  You need to use a consistent dark theme for the dashboard. The solution must preserve the original colors of the reports.

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

  NOTE: Each correct selection is worth one point.

  A. Upload a snapshot.
  B. Select the dark dashboard theme.
  C. Turn on tile flow.
  D. When pinning visuals to the dashboard, select Use destination theme.
  E. For the browser, set the color preference to dark mode.
  B. Select the dark dashboard theme.
  D. When pinning visuals to the dashboard, select Use destination theme.

  ---

  Explanation

  With dashboard themes you can apply a color theme to your entire dashboard, such as corporate colors, seasonal coloring, or any other color theme you might want to apply. When you apply a dashboard theme, all visuals on your dashboard use the colors from your selected theme.

  In the dashboard pane that appears, select one of the pre-built themes. In the example below, we've selected Dark.

  

  Reports and dashboards with different themes

  If your report uses a different theme from the dashboard theme, in most cases you can control whether the visual retains the current report theme or uses the dashboard theme.

  * Try re-pinning the tile and selecting Use dashboard theme.

  

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-themes

• Question 324:

  DRAG DROP

  You use Power Query Editor to preview the data shown in the following exhibit

  

  You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative effort.

  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:

  

  

• Question 325:

  You have a Microsoft Power Bl Desktop report named Report! that uses an Azure SQL database as a data source.

  A user named User1 plans to create a report by using the same data source as Report1.

  You need to simplify the connection to the data source for User1.

  Which type of file should you create?

  A. PBIDS
  B. PBIT
  C. XLSX
  D. PBIX
  A. PBIDS

• Question 326:

  HOTSPOT

  You use Power Query Editor to create a query named Products. Products returns the results shown in the following table.

  

  You need to shape the data to display a single combination of ProductCategory and ProductID on each row.

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 327:

  You need to minimize the size of the semantic model. The solution must meet the report requirements.

  What should you do?

  A. Filter out discontinued products while importing the Products table.
  B. Group the Categories table by the CategorylD column.
  C. Change the OrderlD column in the Orders table to the Text data type.
  D. Remove the QuantityPerUnit column from the Products table.
  D. Remove the QuantityPerUnit column from the Products table.

• Question 328:

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

  

  

  You need to define a relationship from FactSales to DimProduct. The solution must ensure the fastest DAX query performance.

  Which cardinality should you use?

  A. one-to-many
  B. one-to-one
  C. many-to-many
  D. many-to-one
  D. many-to-one

• Question 329:

  HOTSPOT

  You need to create a solution to meet the notification requirements of the warehouse shipping department.

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

  NOTE: Each correct select is worth one point:

  

  

  ---

  Box 1: dashboard

  The warehouse shipping department must be notified if the percentage of late orders within the current month exceeds 5%.

  You can set alerts to notify you when data in your dashboards changes beyond limits you set.

  Box 2: data alert

  https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

• Question 330:

  You need to create a visualization that compares revenue and cost over time.

  Which type of visualization should you use?

  A. stacked area chart
  B. donut chart
  C. line chart
  D. waterfall chart
  C. line chart

  ---

  Explanation

  A line chart or line graph displays the evolution of one or several numeric variables. Data points are connected by straight line segments. A line chart is often used to visualize a trend in data over intervals of time ?a time series ?thus the line is often drawn chronologically.

  Example:

  

  https://www.data-to-viz.com/graph/line.html