Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 161:

  HOTSPOT

  You have a report page that contains the visuals 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: cross-filter

  By default, selecting a data point in one visual on a report page will cross-filter or cross- highlight the other visuals on the page.

  Box 2: cross-highlight

  Example:

  By default, selecting a data point in one visual on a report page will cross-filter or cross- highlight the other visuals on the page.

  

  1. Let's see what happens when we select Moderation.

  

  2. Cross-filtering removes data that doesn't apply. Selecting Moderation in the doughnut chart cross-filters the line chart. The line chart now only displays data points for the Moderation segment.

  3. Cross-highlighting retains all the original data points but dims the portion that does not apply to your selection. Selecting Moderation in the doughnut chart cross-highlights the column chart. The column chart dims all the data that applies to the Convenience segment and highlights all the data that applies to the Moderation segment.

• Question 162:

  You have a Power BI dashboard that monitors the quality of manufacturing processes. The dashboard contains the following elements:

  A line chart that shows the number of defective products manufactured by day. A KPI visual that shows the current daily percentage of defective products manufactured.

  You need to be notified when the daily percentage of defective products manufactured exceeds 3%.

  What should you create?

  A. a Q&A visual
  B. a subscription
  C. a smart narrative visual
  D. an alert
  D. an alert

  ---

  Explanation

  Set alerts in the Power BI service to notify you when data on a dashboard changes above or below limits you set. Alerts can be set on tiles pinned from report visuals or from Power BI Q&A, and only on gauges, KPIs, and cards.

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

• Question 163:

  DRAG DROP

  You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2.

  Sheet1 contains the following table named Table1.

  

  Sheet2 contains the following table named Table2.

  

  You need to use Power Query Editor to combine the products from Table1 and Table2 into the following table that has one column containing no duplicate values.

  

  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:

  

  

  ---

  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

• Question 164:

  You have the Power BI data model shown in the following exhibit.

  

  The Sales table contains records of sales by day from the last five years up until today's date.

  You plan to create a measure to return the total sales Of March 2021 when March 2022 is selected.

  Which DAX expression should you use?

  A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
  B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
  C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
  D. SUM(Sales[Sales])
  C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))

• Question 165:

  You need to create the semantic model.

  Which storage mode should you use for the tables in the semantic model?

  A. live connection
  B. Dual
  C. Import
  D. DirectQuery
  C. Import

• Question 166:

  HOTSPOT

  You have a Power BI report.

  You need to create a calculated table to return the 100 highest spending customers.

  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.

  

  

  ---

  Box 1: TOPN

  TOPN returns the top N rows of the specified table.

  Box 2: SUMMARIZE

  SUMMARIZE returns a summary table for the requested totals over a set of groups.

  Box 3: DESC

  Sort in descending order.

  It is last in the TOPN command.

  TOPN syntax:

  TOPN(<n_value>, <table>, <orderBy_expression>, [<order>[, <orderBy_expression>, [<order>]]...])

• Question 167:

  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 a data source that contains a column. The column contains case sensitive data.

  You have a Power BI semantic model in DirectQuery mode.

  You connect to the model and discover that it contains undefined values and errors.

  You need to resolve the issue.

  Solution: You change the semantic model mode.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 168:

  You have the following table named Location.

  

  The GeoCode column represents the country where each customer is located.

  You create a map visualization as shown in the exhibit. (Click the Exhibit tab.)

  

  You need to ensure that the map displays the country locations.

  What should you do?

  A. Replace the values in the GeoCode column with postal codes or zip codes.
  B. Change the name of the GeoCode column to Country.
  C. Change the name of the Location table to Country.
  D. Change the Default Summarization of the GeoCode column.
  E. Add a Geoportal column to the Location table.
  F. Change the Data Type of the GeoCode column.
  B. Change the name of the GeoCode column to Country.

  ---

  Explanation

  References:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

• Question 169:

  HOTSPOT

  You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements.

  For each of the following statement, select Yes if the statement is true, Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  

  

  ---

  1) NO - CustomerID in Orders is text ("VINET") while CustomerID in Customer Details is number ("1"). 2) YES - Relationship between Orders and Customer Details will be via column CustomerCRMID in Customer Details and CustomerID in Orders, which are both text. 3) NO - the Orders table only contains shipping address, which is different from the billing address which should be used for sales region. Thus, it should come from Customer Details table.

• Question 170:

  You have a Power BI semantic model that connects to a streaming data source. The data source is updated frequently.

  You need to create a Power BI report that meets the following requirements:

  1. Supports real-time analytics

  2. Minimizes performance impact on the data source

  3. Displays the most recent data without performing a data refresh

  Which connectivity mode should you use for the dataset?

  A. DirectQuery mode
  B. import mode
  C. LiveConnect mode
  D. push mode
  D. push mode