PL-300 Practice Test

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

Question 51

You have a query that contains customer data in Power Query Editor as 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 52

You have a Power BI report named Report that contains the following tables. For the last three days, refresh in Power BI has failed, and you receive the following error message: “You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory.” You need to resolve the error and ensure that query response times are minimized for end users. What should you do?

  1. Merge the Sales person and invoice tables based on the SalesPersonId column.
  2. Change the invoice table to a DirectQuery table and read the data live from the source, retaining only the dimension tables as import tables.
  3. Reduce the size of the invoice table by summarizing sales by Product, Sales person, Calendar, and Customer.
  4. Change the invoice table to a composite table that contains historical data as a DirectQuery table and hot data as an import table, and then partition the table.

Question 53

You have a table named DIMCountries that contains a column named Country as shown in the following table. You plan to use DIMCountries as a dimension in a report. You need to ensure that the Country column in DIMCountries lists each country only once. Which two actions should you perform on the Country column? Each correct answer presents part of the solution. NOTE: Each correct answer is worth one point.

  1. Change Data category to Country.
  2. Remove duplicate values.
  3. Apply a clean transform.
  4. Replace the empty fields.
  5. Apply a Capitalize Each Word transform.

Question 54

You plan to use Power Query Editor to get data from an API. The API returns a JSON response. You have a username and password for the API. Which data source and authentication method should you use to connect to the API? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 55

You use Power Query Editor to create a query named Products. Products return the results shown in the following table. You need to shape the data to display a single combination of ProductCategory and ProductID on each row. How should you configure the ProductIDList column? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.