PL-300 Practice Test

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

Question 16

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day. What should you do?

  1. Create a dataflows connection that has DirectQuery mode selected.
  2. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.
  3. Create a dataflows connection that has Import mode selected and schedule a daily refresh.
  4. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

Question 17

You publish a dataset that contains data from an on-premises Microsoft SQL Server database. The dataset must be refreshed daily. You need to ensure that the Power BI service can connect to the database and refresh the dataset. Which four 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 18

You attempt to connect Power BI Desktop to a Cassandra database. From the Get Data connector list, you discover that there is no specific connector for the Cassandra database. You need to select an alternate data connector that will connect to the database. Which type of connector should you choose?

  1. Microsoft SQL Server database
  2. ODBC
  3. OLE DB
  4. OData

Question 19

You receive annual sales data that must be included in Power BI reports. From Power Query Editor, you connect to the Microsoft Excel source shown in the following exhibit. You need to create a report that meets the following requirements: • Visualizes the Sales value over a period of years and months • Adds a slicer for the month • Adds a slicer for the year 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 20

You are using Power BI Desktop to connect to an Azure SQL database. The connection is configured 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 solution is worth one point.