PL-300 Practice Test

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

Question 46

You have a Microsoft Power BI Desktop report named Report1 that uses an Azure SQL database as a data source. A user named User1 plans to create a report by using the same data source as Report1. You need to simplify the connection to the data source for User1. Which type of file should you create?

  1. PBIDS
  2. XLSX
  3. PBIT
  4. PBIX

Question 47

You have a Power BI semantic model. You discover that the semantic model contains values that display as errors. You need to use data profiling features in Power Query to preview the data and identify the issues. What should you select to gain insight into the number of errors in the model, and what should you select to resolve the errors? To answer, select the appropriate options in the answer area. NOTE: Each correct answer is worth one point.

Question 48

You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1. Model1 must show updated data within two minutes of the data being updated in DB1. You need to select a connectivity mode for the connection to DB1. What should you choose?

  1. DirectQuery
  2. live connection
  3. import

Question 49

You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements: • The model must contain a table named Orders that has one row per order. Each row will contain the total amount per order. • The orders must be filtered to the selected CustomerID value. • Users must select the CustomerID value from a list. • The list of customers must come from an OData source. Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  1. an Orders query that has a filter on CustomerID
  2. a Customers query that has a filter on CustomerID
  3. an Orders query that has a single column containing a list of customers
  4. a Customers query that has a single column containing a list of customer IDs
  5. a parameter for CustomerID that uses a query to populate the suggested values
  6. a parameter for CustomerID that uses manually entered values to populate the suggested values

Question 50

You use Power BI Desktop to create a report named RPT1 that loads data from a Microsoft Excel file named File1. File1 is located in a network share. File1 is moved to a different folder. When you open RPT1 in Power BI Desktop, you discover that the report displays outdated data. You need to ensure that the data in File1 refreshes properly. What should you do?

  1. Change the data source.
  2. Clear the permissions of File1.
  3. Export a PBIDS file.
  4. Modify the permissions for File1.