Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 201:

  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 Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

  1. Due Date

  2. Order Date

  3. Delivery Date

  You need to support the analysis of sales over time based on all the date foreign keys.

  Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  You can reference an inactive relationship whit DAX function USERELATIONSHIP(), but using DAX is not mentioned here.

  So follow this refactory methodology: Create a copy of the role-playing table, providing it with a name that reflects its role. If it's an Import table, we recommend defining a calculated table. If it's a DirectQuery table, you can duplicate the Power Query query.

  Source:

  https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

• Question 202:

  HOTSPOT

  You are creating a Microsoft Power Bl imported data model to perform basket analysis. The goal of the analysis is to identify which products are usually bought together in the same transaction across and within sales territories.

  You import a fact table named Sales as shown in the exhibit. (Click the Exhibit tab.)

  

  The related dimension tables are imported into the model.

  Sales contains the data shown in the following table.

  

  

• Question 203:

  You have a Microsoft Power BI data model that contains three tables named Orders, Date, and City. There is a one-to-many relationship between Date and Orders and between City and Orders.

  The model contains two row-level security (RLS) roles named Role1 and Role2. Role1 contains the following filter.

  City[State Province] = "Kentucky"

  Role2 contains the following filter.

  Date[Calendar Year] = 2020

  If a user is a member of both Role1 and Role2, what data will they see in a report that uses the model?

  A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.
  B. The user will receive an error and will not be able to see the data in the report.
  C. The user will only see data for which the State Province value is Kentucky.
  D. The user will only see data for which the State Province value is Kentucky and the Calendar Year is 2020.
  A. The user will see data for which the State Province value is Kentucky or where the Calendar Year is 2020.

• Question 204:

  DRAG DROP

  You have a Power BI model that contains a table named Sales. Sales has the following three measures:

  A measure named Total Sales Last Year that displays the sales from the previous calendar year. The current value is 32.89 million. A measure named Total Sales.

  This Year that displays the sales from the current calendar year. The current value is 11.69 million. A measure named Total Sales Difference that uses a DAX formula of Sales[Last Year] ?Sales[This Year].

  You need to create the following visualization.

  

  How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

  NOTE: Each correct selection is worth one point.

  Select and Place:

  

  

  ---

  References:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

• Question 205:

  You have a Power B1 report that contains three pages named Page1, Page2, and Page3.

  All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only.

  What should you do?

  A. Sync the slicers on Page1 and Page3
  B. On each page, modify the interactions of the slicer.
  C. Enable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.
  A. Sync the slicers on Page1 and Page3

• Question 206:

  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 an on-premises data gateway.

  You need to reduce the amount of data sent through the gateway by semantic models that run in Import storage mode.

  Solution: You create aggregations to summarize results.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 207:

  HOTSPOT

  You have a Power Bl report that contains the visual shown in the following exhibit.

  

  

• Question 208:

  You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization.

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

  NOTE: Each correct selection is worth one point.

  A. Add the same slicer to each page and configure Sync slicers.
  B. Edit the interactions of the KPI visualization.
  C. Configure a page-level filter.
  D. Edit the interactions of the slicer that is on the same page as the KPI visualization.
  E. Configure a report-level filter.
  A. Add the same slicer to each page and configure Sync slicers.
  D. Edit the interactions of the slicer that is on the same page as the KPI visualization.

  ---

  Explanation

  Slicers are another way of filtering. They narrow the portion of the dataset that is shown in the other report visualizations.

  By default, slicers on report pages affect all the other visualizations on that page, including each other. Use visual interactions to exclude some page visualizations from being affected by others.

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

• Question 209:

  You have data in a Microsoft Excel worksheet as shown in the following table.

  

  You need to use Power Query to clean and transform the dataset. The solution must meet the following requirements:

  1. If the discount column returns an error, a discount of 0.05 must be used.

  2. All the rows of data must be maintained.

  3. Administrative effort must be minimized.

  What should you do in Power Query Editor?

  A. Select Keep Errors
  B. Edit the query in the Query Errors group.
  C. Select Replace Errors
  D. Select Remove Errors.
  C. Select Replace Errors

• Question 210:

  HOTSPOT

  You have a column named UnitslnStock as shown in the following exhibit

  

  UnitsInStock has 75 non-null values, of which 51 are unique.

  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: 75 rows

  Is nullable allows NULL values in the column.

  Box 2: reduce

  https://blog.crossjoin.co.uk/2019/01/20/is-nullable-column-property-power-bi/