Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 231:

  HOTSPOT

  You have a Power Bl report that contains a measure named Total Sales.

  You need to create a new measure that will return the sum of Total Sates for a year up to a selected date. 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: TOTALYTD

  TOTALYTD evaluates the specified expression over the interval which begins on the first day of the year and ends with the last date in the specified date column after applying specified filters.

  Syntax: TOTALYTD ( <Expression>, <Dates> [, <Filter>] [, <YearEndDate>] Expression - The expression to be evaluated. Dates - The name of a column containing dates or a one column table containing dates.

  Example:

  TOTALYTD ( -- 2007-01-01 : 2007-05-12 [Sales Amount], 'Date'[Date] Box 2: 'Date'[Date]

  https://dax.guide/totalytd/

• Question 232:

  You open a query in Power Query Editor.

  You need to identify the percentage of empty values in each column as quickly as possible.

  Which Data Preview option should you select?

  A. Show whitespace
  B. Column profile
  C. Column distribution
  D. Column quality
  D. Column quality

  ---

  Explanation

  Column quality: In this section, we can easily see valid, Error and Empty percentage of data values associated with the Selected table.

  Note: In Power Query Editor, Under View tab in Data Preview Section we can see the following data profiling functionalities:

  Column quality

  Column distribution

  Column profile Reference:

  https://community.powerbi.com/t5/Community-Blog/Data-Profiling-in-Power-BI-Power-BI-Update-April-2019/ba-p/674555

• Question 233:

  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 of following two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

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

  ---

  
  

• Question 234:

  DRAG DROP

  You have a Power Bl report that contains three pages. The pages are used to analyze sales across various countries.

  You add a sheer named Country to each page of the report.

  You need to configure the report to meet the following requirements:

  1. When a user selects a country on the first page, the report must filter the other pages.

  2. The second and third pages must display only the filtered results.

  Which task should you perform for each requirement? To answer, drag the appropriate task to the correct requirement. Each task 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:

  

  

• Question 235:

  You have a Power BI semantic model that has the tables and relationships shown in the following exhibit.

  

  Which type of dimension is represented by Dim Address?

  A. Type 2 slowly changing dimension (SCD)
  B. junk dimension
  C. role-playing dimension
  D. degenerate dimension
  C. role-playing dimension

• Question 236:

  What should you create to meet the reporting requirements of the sales department?

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

• Question 237:

  HOTSPOT

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

  

  You plan to modify the visual by changing the column spacing and adding percent change labels as shown in the following exhibit.

  

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

  NOTE: Each correct selection is worth one point.

  

  

• Question 238:

  You are creating a Power BI report that will contain multiple visuals.

  You need to ensure that the report is accessible to users who use a screen reader.

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

  NOTE: Each correct selection is worth one point.

  A. alt text for each visual
  B. the tab order for each page
  C. consistent colors for each visual
  D. Play Axis for each page
  E. consistent fonts for each visual
  A. alt text for each visual
  B. the tab order for each page

• Question 239:

  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 are modeling data by using Microsoft Power BI. Part of the data model is a large Microsoft SQL Server table named Order that has more than 100 million records. During the development process, you need to import a sample of the data from the Order table.

  Solution: You add a WHERE clause to the SQL statement.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

  ---

  Explanation

  The WHERE clause has its effects before the data is imported.

  https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

• Question 240:

  HOTSPOT

  You import a Microsoft Excel spreadsheet into Power Query Editor and name the query Sales_Spreadsheet.

  Sales_Spreadsheet contains the following columns:

  1. Customer ID

  2. Customer Name

  3. Date

  4. Total Sales Amount

  You plan to use the Sales Spreadsheet query to load two tables named Customer and Sales into the associated semantic model. The tables relate to each other on the Customer ID column of each query. The solution must meet the following requirements:

  1. The Customer query must contain the Customer ID and Customer Name columns.

  2. The Sales query must contain the Customer ID, Date, and Total Sales Amount columns.

  3. Power Query logic must be consolidated to avoid the duplication of logic across the queries and ensure that only one location is used to update the logic.

  You need to identify how to create the Sales query, and what to do to the Sales_Spreadsheet query before loading the model.

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

  NOTE: Each correct selection is worth one point.