PL-300 Practice Test

PL-300 Practice Test practice questions, page 5 of 16, with answer review and explanations.

Question 21

You have the Azure SQL databases shown in the following table. You plan to build a single PBIX file to meet the following requirements: • Data must be consumed from the database that corresponds to each stage of the development lifecycle. • Power BI deployment pipelines must NOT be used. • The solution must minimize administrative effort. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 22

You are creating a query to be used as a Country dimension in a star schema. A snapshot of the source data is shown in the following table. You need to create the dimension. The dimension must contain a list of unique countries. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  1. Delete the Country column.
  2. Remove duplicates from the table.
  3. Remove duplicates from the City column.
  4. Delete the City column.
  5. Remove duplicates from the Country column.

Question 23

You use Power Query Editor to preview the data shown in the following exhibit. You need to clean and transform the query so that all the rows of data are maintained, and error values in the discount column are replaced with a discount of 0.05. The solution must minimize administrative 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.

Question 24

You attempt to use Power Query Editor to create a custom column and receive the error message 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.

Question 25

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.

  1. You do not have permissions to the file.
  2. An incorrect privacy level was used for the data source.
  3. The file is locked.
  4. The referenced file was moved to a new location.