Exam PL-300: Microsoft Power BI Data
Analyst questions and answers 2026\2027
A+ Grade
The data has the following refresh requirements:
✑ Customer must be refreshed daily.
✑ Date must be refreshed once every three years.
✑ Sales must be refreshed in near real time.
✑ SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following
requirements:
✑ Minimize the load times of visuals.
✑ Ensure that the data is loaded to the model based on the refresh requirements.
Which storage mode should you select for each table?
To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- correct answer Correct Answer:
Box 1: Dual -
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the
query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In
other cases, you fulfill queries by executing an on-demand query to the data source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.
, Box 2: Dual -
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of
limited relationships in the dataset, and improve performance.
Box 3: DirectQuery -
Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI
dataset"ג€for example, DAX queries"ג€and that return data from
DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that
you submit to the data source use the query language for that data source, for example, SQL.
Box 4: Import -
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that
return data from Import tables can be fulfilled only from cached data.
Question #2 Topic 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?
A. Microsoft Teams Personal Analytics
B. SQL Server database
C. Dataverse
D. Dataflows
- correct answer Correct Answer: C
Question #3 Topic 1
Analyst questions and answers 2026\2027
A+ Grade
The data has the following refresh requirements:
✑ Customer must be refreshed daily.
✑ Date must be refreshed once every three years.
✑ Sales must be refreshed in near real time.
✑ SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following
requirements:
✑ Minimize the load times of visuals.
✑ Ensure that the data is loaded to the model based on the refresh requirements.
Which storage mode should you select for each table?
To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
- correct answer Correct Answer:
Box 1: Dual -
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the
query that's submitted to the Power BI dataset. In some cases, you fulfill queries from cached data. In
other cases, you fulfill queries by executing an on-demand query to the data source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.
, Box 2: Dual -
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of
limited relationships in the dataset, and improve performance.
Box 3: DirectQuery -
Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI
dataset"ג€for example, DAX queries"ג€and that return data from
DirectQuery tables can be fulfilled only by executing on-demand queries to the data source. Queries that
you submit to the data source use the query language for that data source, for example, SQL.
Box 4: Import -
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that
return data from Import tables can be fulfilled only from cached data.
Question #2 Topic 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?
A. Microsoft Teams Personal Analytics
B. SQL Server database
C. Dataverse
D. Dataflows
- correct answer Correct Answer: C
Question #3 Topic 1
