PL-300 practice test

1. Question 1 · 1

   You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

   Choose one answer.

   • Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
   • Change the data type of the Logged column to Date.
   • Split the Logged column by using at as the delimiter.
   • Apply a transformation to extract the first 11 characters of the Logged column.

2. Question 2 · 1

   You have a Microsoft Excel file in a Microsoft OneDrive folder. The file must be imported to a Power BI dataset. You need to ensure that the dataset can be refreshed in powerbi.com. Which two connectors can you use to connect to the file? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   Choose all answers that apply.

   • Excel Workbook
   • Text/CSV
   • Folder
   • SharePoint folder
   • Web

3. Question 3 · 1

   You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

   Choose one answer.

   • Add a SQL statement.
   • Set the Command timeout in minutes setting.
   • Set Data Connectivity mode to Import.
   • Set Data Connectivity mode to DirectQuery.

4. Question 4 · 1

   DRAG DROP - You have a folder that contains 100 CSV files. You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files. 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:

   Arrange the options in the correct order.

   

   • From Power BI Desktop, select Get Data, and then select Folder.
   • From Power Query Editor, expand the Attributes column.
   • From Power Query Editor, remove the Content column.
   • From Power Query Editor, remove the Attributes column.
   • From Power BI Desktop, select Get Data, and then select Text/CSV.
   • From Power Query Editor, combine the Content column.

5. Question 5 · 1

   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?

   Choose one answer.

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

6. Question 6 · 1

   DRAG DROP - 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.

   Arrange the options in the correct order.

   

   • Configure an on-premises data gateway.
   • Add a data source.
   • Add the dataset owner to the data source.
   • Configure a scheduled refresh.

7. Question 7 · 1

   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?

   Choose one answer.

   • Microsoft SQL Server database
   • ODBC
   • OLE DB
   • OData

8. Question 8 · 1

   DRAG DROP - 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.

   Arrange the options in the correct order.

   

   

   • Select the Month and MonthNumber columns.
   • Select Unpivot other columns.
   • Rename the Attribute column as Year and the Value column as Sales.
   • Select the 2019, 2020, and 2021 columns.
   • Select Transpose.

9. Question 9 · 1

   You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps. You need to create a Power BI report that connects to the project management app. Which connector should you select?

   Choose one answer.

   • Microsoft Teams Personal Analytics
   • SQL Server database
   • Dataverse
   • Dataflows

10. Question 10 · 1

    HOTSPOT - 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.

    Choose an option for each prompt.

    

    

    default timeout

    • • unlimited
    • • one minute
    • • 10 minutes

    Navigator display

    • • all the tables
    • • only tables that contain data
    • • only tables that contain hierarchies

11. Question 11 · 1

    HOTSPOT - 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.

    Choose an option for each prompt.

    

    

    Create

    • • One parameter
    • • Two parameters
    • • Three parameters

    Parameter type

    • • Text
    • • True/False
    • • Decimal number

12. Question 12 · 1

    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.

    Choose all answers that apply.

    

    • Delete the Country column.
    • Remove duplicates from the table.
    • Remove duplicates from the City column.
    • Delete the City column.
    • Remove duplicates from the Country column.

13. Question 13 · 1

    DRAG DROP - 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.

    Arrange the options in the correct order.

    

    

    • Select the discount column.
    • Select the price column.
    • For the discount column, change Data Type to Decimal Number.
    • For the discount column, change Data Type to Whole Number.
    • Select Replace Errors to replace each error value with 0.05.

14. Question 14 · 1

    HOTSPOT - 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.

    Choose an option for each prompt.

    

    

    cause

    • • error values in the source data
    • • mismatched data types
    • • NULL values

    desired outcome

    • • 1A
    • • A&1
    • • A1

15. Question 15 · 1

    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.

    Choose all answers that apply.

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

Paid access to all 338 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.