PL-300: Microsoft Power BI Data Analyst Questions and Answers 2026/2027 | A+ Grade Certification

PL-300: Microsoft Power BI Data Analyst questions and
answers 2026\2027 A+ Grade

Question #14Topic 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?

A. Add a SQL statement.

B. Set the Command timeout in minutes setting.

C. Set Data Connectivity mode to Import.

D. Set Data Connectivity mode to DirectQuery.
- correct answer D. Set Data Connectivity mode to DirectQuery.



Reference:https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery



Question #16Topic 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. TheEnhanced 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?



A. Create a dataflows connection that has DirectQuery mode selected.

,B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway
connection for the dataset.

C. Create a dataflows connection that has Import mode selected and schedule a daily refresh.

D. Create a dataflows connection that has Import mode selected and create a Microsoft Power
Automate solution to refres
- correct answer C. Create a dataflows connection that has Import mode selected and schedule a daily
refresh.



2.3

For the sales department at your company, you publish a Power BI report that imports data from a
Microsoft Excel file located in a Microsoft SharePoint folder.

The data model contains several measures.



You need to create a Power BI report from the existing data. The solution must minimize development
effort.



Which type of data source should you use?



A. Power BI dataset

B. a SharePoint folder

C. Power BI dataflows

D. an Excel workbook
- correct answer A. Power BI dataset



You are building a Power BI report that uses data from an Azure SQL database named erp1.You import
the following tables.

You need to perform the following analyses:

✑ Orders sold over time that include a measure of the total order value

Orders by attributes of products sold

The solution must minimize update times when interacting with visuals in the report.What should you
do first?

,A. From Power Query, merge the Order Line Items query and the Products query.

B. Create a calculated column that adds a list of product categories to the Orders table by using a DAX
function.

C. Calculate the count of orders per product by using a DAX function.

D. From Power Query, merge the Orders query and the Order Line Items query.
- correct answer D. From Power Query, merge the Orders query and the Order Line Items query.



2.5

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?



A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type
of the new column to Date.

B. Change the data type of the Logged column to Date.

C. Split the Logged column by using at as the delimiter.

D. Apply a transformation to extract the first 11 characters of the Logged column.
- correct answer D. Apply a transformation to extract the first 11 characters of the Logged column.



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

, A. Excel Workbook

B. Text/CSV

C. Folder

D. SharePoint folder

E. Web
- correct answer A. Excel Workbook

D. SharePoint folder



A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access
tables from an on-premises Microsoft SQL server. TheEnhanced 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?



A. Create a dataflows connection that has DirectQuery mode selected.

B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway
connection for the dataset.

C. Create a dataflows connection that has Import mode selected and schedule a daily refresh.

D. Create a dataflows connection that has Import mode selected and create a Microsoft Power
Automate solution to refresh the data hourly.
- correct answer C. Create a dataflows connection that has Import mode selected and schedule a daily
refresh.



4.4

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