Microsoft PL-300 Online Practice Questions and Exam Preparation

Microsoft PL-300 Online Questions & Answers

• Question 341:

  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 ID columns are unique to each row in query.

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

  Solution: You create a custom column that concatenates the 10T GUID column and the IoT ID column and then delete the IoT GUID and IoT ID columns.

  Does this meet the goal?

  A. Yes
  B. No
  B. No

• Question 342:

  You have a Power Bi report for the procurement department. The report contains data from the following tables.

  

  There is a one-to-many relationship from Suppliers to Lineitems that uses the ID and Supplier ID columns. The report contains the visuals shown in the following table.

  

  You need to minimize the size of the dataset without affecting the visuals.

  What should you do?

  A. Remove the rows from Lineitems where LineItems[invoice Date] is before the beginning of last month
  B. Merge Suppliers and Uneltems.
  C. Group Lineltems by Lineitems[ invoice id) and Lineitems[invoice Date) with a sum of Lineitems(price).
  D. Remove the Lineitems[Description] column.
  D. Remove the Lineitems[Description] column.

• Question 343:

  DRAG DROP

  You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

  

  Each file contains deltas of any new or modified rows from each load to the data lake.

  Multiple files can have the same customer ID.

  You need to keep only the last modified row for each customer ID.

  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:

  

  

  ---

  1) Duplicate Customer query 2) Group by CustId by Max ModifiedDate (only 2 columns to keep) 3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)

• Question 344:

  In Power BI Desktop, you are creating a report that will contain three pages.

  You need to create a custom tooltip page and prepare the page for use.

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

  A. For the tooltip page, set Allow use as tooltip to On.
  B. For the target page, set Allow use as tooltip to On.
  C. Configure filters on the target visual.
  D. For the tooltip page, configure filters.
  E. Add and configure visuals on the tooltip page.
  A. For the tooltip page, set Allow use as tooltip to On.
  D. For the tooltip page, configure filters.
  E. Add and configure visuals on the tooltip page.

• Question 345:

  HOTSPOT

  You need to create a relationship in the dataset for RLS.

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

  NOTE: Each correct selection is worth one point.

  

  

  ---

  Box 1: many-to-one

  Each employee in the Sales Employees table is assigned to one sales region. Multiple employees can be assigned to each region.

  The Suppliers table has a Region column.

  Box 2: Suppliers table

• Question 346:

  You have a Power BI report that contains a table visual. The visual contains a column.

  The column contains whole numbers ranging from of 1 to 20.

  You need to use conditional formatting to meet the following requirements:

  1. Visually compare the values without having to read the text containing the number.

  2. Show a different format for each distinct value.

  3. Hide the numeric value of ColumnA.

  4. Minimize development effort.

  Which formatting should you use?

  A. font color
  B. icons
  C. data bars
  D. background color
  C. data bars

• Question 347:

  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 create a parameter named DataSourceExcel that holds the file name and location of a Microsoft Excel data source.

  You need to update the query to reference the parameter instead of multiple hard-coded copies of the location within each query definition.

  Solution: You add a Power Apps custom visual to the report.

  Does this meet the goal?

  A. Yes
  B. No
  A. Yes

• Question 348:

  HOTSPOT

  You have two CSV files named Products and Categories. The Products file contains the following columns:

  1. ProductID

  2. ProduetName

  3. SupplierID

  4. CategoryID

  The Categories file contains the following columns:

  1. CategoryID

  2. CategoryName

  3. CategoryDescription

  From Power Bl Desktop, you import the files into Power Query Editor.

  You need to create a Power Bl dataset that will contain a single table named Product. The Product will table includes the following columns:

  1. ProductID

  2. ProductName

  3. SupplierID

  4. CategoryID

  5. CategoryName

  6. CategoryDescription

  How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  

  

• Question 349:

  From Power Query Editor, you attempt to execute a query and receive the following error message.

  Datasource.Error: could not find file.

  What are two possible causes of the error? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. The file is locked
  B. An incorrect privacy level was used for the data source.
  C. The referenced file was moved to a new location
  D. You do not have permissions to the file.
  B. An incorrect privacy level was used for the data source.
  D. You do not have permissions to the file.

• Question 350:

  You use Power BI Desktop to load data from a Microsoft SQL Server database.

  While waiting for the data to load, you receive the following error.

  

  You need to resolve the error.

  What are two ways to achieve the goal? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Split long running queries into subsets Of columns and use power Query to the queries
  B. Disable query folding on long running queries
  C. Reduce number of rows and columns returned by each query.
  D. Use Power Query to combine long running queries into one query.
  A. Split long running queries into subsets Of columns and use power Query to the queries
  C. Reduce number of rows and columns returned by each query.