Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 491:

  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.

  From Power Query Editor, you profile the data shown in the following exhibit.

  

  The IoT GUID and IoT ID columns are unique to each row in query.

  You need to analyze IoT events by the hour and day of the year. The solution must improve dataset performance.

  Solution: You remove the loT GUID column and retain the loT ID column.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 492:

  DRAG DROP

  You use Power Bi Desktop to create a Power Bl data model and a blank report You need to add the Word Cloud visual shown in the following exhibit to the report.

  

  The solution must minimize development 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 493:

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

  A. a measure that uses a formula of COUNTROWS(Sales)
  B. a calculated column that use a formula of COUNTA(Sales[sales_id])
  C. a calculated column that uses a formula of SUM(Sales[sales_id])
  D. a measure that uses a formula of SUM(Sales[sales_id])
  A. a measure that uses a formula of COUNTROWS(Sales)

  ---

  Explanation

  The sales department requires reports that contain the number of sales transactions.

  The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

  Incorrect:

  The COUNTA function counts the number of cells in a column that are not empty.

  https://docs.microsoft.com/en-us/dax/countrows-function-dax

• Question 494:

  Vow have a Power 81 semantic model named Modell that runs in Import storage mode.

  You need to reduce the size of Model 1.

  The solution must NOT increase report query response times.

  What should you do?

  A. Unpivot unnecessary columns.
  B. Rename unnecessary columns.
  C. Change Model1 to DirectQuery storage mode.
  D. Remove unnecessary columns.
  D. Remove unnecessary columns.

• Question 495:

  HOTSPOT

  You use Power Query Editor to pull data from a Microsoft SharePoint Online list.

  You plan to use Advanced Editor to build a Power Query M formula language query.

  You need to create a query that loads the data, expands a column named location, and hides a column named CountryOrRegion from the dataset.

  How should you complete the query? To answer, select the appropriate options in the answer area.

  NOTE: Each correct answer is worth one point.

  

  

• Question 496:

  You have more than 100 published datasets.

  Ten of the datasets were verified to meet your corporate quality standards.

  You need to ensure that the 10 verified datasets appear at the top of the list of published datasets whenever users search for existing datasets.

  What should you do?

  A. Publish the datasets in an app.
  B. Promote the datasets.
  C. Feature the dataset on the home page.
  D. Certify the datasets.
  D. Certify the datasets.

• Question 497:

  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 Bl. 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 report-level filter that filters based on the order date.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

  ---

  Explanation

  The filter is applied after the data is imported.

  Instead add a WHERE clause to the SQL statement.

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

• Question 498:

  HOTSPOT

  You have a semantic model named Model1 that contains the following tables.

  

  There is an active relationship between SaleDate and Date.

  There is an inactive relationship between ShippingDate and Date.

  You need to create a new measure that will display the total amount of sales and support slicing by ShippingDate.

  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.

  

  

• Question 499:

  You have a Power Bl report that contains a page. The page contains the following:

  1. A shape named Shape 1

  2. A card named Sales Summary

  3. A clustered bar chart named Sales by Region

  You need to ensure that Sales Summary renders on top of Shape 1.

  What should you modify?

  A. Tab order in the Selection pane
  B. Layer order in the Selection pane
  C. Maintain layer order in the General visual settings
  D. Vertical alignment in the Canvas settings
  B. Layer order in the Selection pane

  ---

  Explanation

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

  You confirm that the data will always start on row 3, and row 3 will always contain the column names.

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

  

• Question 500:

  DRAG DROP

  You have a Power Bl table named Customer that contains a field named Email Address.

  You discover that multiple records contain the same email address.

  You need to create a calculated column to identify which records have duplicate email addresses.

  How should you complete the OAX expression for the calculated column? To answer, drag the appropriate values to the correct targets. 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:

  

  

  ---

  You are to count the number of rows having same email address.

  1. Declare a variable and call it any name you prefer 2. Calculate the row count on the table

  3. Apply filter to ALL of the values in the table under the column name email address and equate it to the variable.

  You may need to read up filter functions for a proper understanding of how it works.