PL - 300 Microsoft Power BI Data Analyst Practice Questions
and answers 2026\2027 A+ Grade
You plan to get data for a Power BI dataset from flat files. You need to select a location for the files. The
location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365
credentials.
Which two location types should you recommend? Each correct answer presents a complete solution.
Select all answers that apply.
a. local file
b. OneDrive for Business
c. Personal OneDrive account
d. SharePoint - Team Sites
- correct answer b. OneDrive for Business
d. SharePoint - Team Sites
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you
should use the DirectQuery storage mode or the Import storage mode.
What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete
solution.
Select all answers that apply.
a. full support for the Q&A Power BI service
b. full support for the Quick Insights Power BI service
c. minimized local disk space usage
d. minimized need for data refresh
- correct answer c. minimized local disk space usage
d. minimized need for data refresh
You have designed a star schema to simplify your data.
,You need to understand the relationship between the tables in the star schema.
What is the relationship between the fact table and dimension tables?
Select only one answer.
a. many-to-many
b. many-to-one
c. one-to-many
d. one-to-one
- correct answer b. many-to-one
You create a Power BI Desktop dataset by importing and transforming a data source based on multiple
tables in a SQL Server database.
You need to modify the relationship between the tables.
Which interface should you use in the Power BI Desktop?
Select only one answer.
a. Data view
b. Model view
c. Page view
d. Report view
- correct answer b. Model view
You are designing a data model in Power BI.
You need to avoid introducing ambiguity into your data model design.
Which type of cardinality should you avoid?
Select only one answer.
a. many-to-many
b. many-to-one
c. one-to-many
,d. one-to-one
- correct answer a. many-to-many
You need to create a Power BI dashboard.
Which tool should you use?
Select only one answer.
a. Power BI Desktop
b. Power Query Editor
c. the Power BI mobile app
d. the Power BI service
- correct answer d. the Power BI service
You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in Power BI?
Select only one answer.
a. You need to add filters.
b. You need to add slicers.
c. You need to display visuals on multiple pages.
d. You need to display visuals that use different datasets.
- correct answer d. You need to display visuals that use different datasets.
You need to create a dashboard from a published report in Power BI.
Which option in the report should you use?
Select only one answer.
a. Copy visual as image
b. Export data
c. Pin visual
, d. Spotlight
- correct answer c. Pin visual
You upload reports to the Power BI service and pin several visuals to a dashboard.
You plan to create alerts rules for several visuals.
What are two locations you can view the alerts? Each correct answer presents a complete solution.
Select all answers that apply.
a. a report
b. an email
c. Microsoft Teams
d. the Notification Center
- correct answer b. an email
d. the Notification Center
Your company has a SharePoint server located in a datacentre in Montreal.
You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the
SharePoint server.
You need to recommend a solution to ensure that the dataset for the report can automatically refresh
daily.
What should you include in the recommendation?
Select only one answer.
a. a Point to Site virtual private network (VPN)
b. a Site-to-Site virtual private network (VPN)
c. an on-premises data gateway
d. Azure Data Box
- correct answer c. an on-premises data gateway
You have a row level security role (RLS) in a dataset called User Security Group. This role needs to filter a
RLS table that contains a column with the emails of users in the following format:
and answers 2026\2027 A+ Grade
You plan to get data for a Power BI dataset from flat files. You need to select a location for the files. The
location must provide the ability to configure scheduled refresh for the dataset by using Microsoft 365
credentials.
Which two location types should you recommend? Each correct answer presents a complete solution.
Select all answers that apply.
a. local file
b. OneDrive for Business
c. Personal OneDrive account
d. SharePoint - Team Sites
- correct answer b. OneDrive for Business
d. SharePoint - Team Sites
You plan to add data to Power BI Desktop from a new data source. You are evaluating whether you
should use the DirectQuery storage mode or the Import storage mode.
What are two benefits of using DirectQuery instead of Import? Each correct answer presents a complete
solution.
Select all answers that apply.
a. full support for the Q&A Power BI service
b. full support for the Quick Insights Power BI service
c. minimized local disk space usage
d. minimized need for data refresh
- correct answer c. minimized local disk space usage
d. minimized need for data refresh
You have designed a star schema to simplify your data.
,You need to understand the relationship between the tables in the star schema.
What is the relationship between the fact table and dimension tables?
Select only one answer.
a. many-to-many
b. many-to-one
c. one-to-many
d. one-to-one
- correct answer b. many-to-one
You create a Power BI Desktop dataset by importing and transforming a data source based on multiple
tables in a SQL Server database.
You need to modify the relationship between the tables.
Which interface should you use in the Power BI Desktop?
Select only one answer.
a. Data view
b. Model view
c. Page view
d. Report view
- correct answer b. Model view
You are designing a data model in Power BI.
You need to avoid introducing ambiguity into your data model design.
Which type of cardinality should you avoid?
Select only one answer.
a. many-to-many
b. many-to-one
c. one-to-many
,d. one-to-one
- correct answer a. many-to-many
You need to create a Power BI dashboard.
Which tool should you use?
Select only one answer.
a. Power BI Desktop
b. Power Query Editor
c. the Power BI mobile app
d. the Power BI service
- correct answer d. the Power BI service
You are evaluating whether you need to create a dashboard in Power BI.
In which scenario do you need a dashboard instead of a report in Power BI?
Select only one answer.
a. You need to add filters.
b. You need to add slicers.
c. You need to display visuals on multiple pages.
d. You need to display visuals that use different datasets.
- correct answer d. You need to display visuals that use different datasets.
You need to create a dashboard from a published report in Power BI.
Which option in the report should you use?
Select only one answer.
a. Copy visual as image
b. Export data
c. Pin visual
, d. Spotlight
- correct answer c. Pin visual
You upload reports to the Power BI service and pin several visuals to a dashboard.
You plan to create alerts rules for several visuals.
What are two locations you can view the alerts? Each correct answer presents a complete solution.
Select all answers that apply.
a. a report
b. an email
c. Microsoft Teams
d. the Notification Center
- correct answer b. an email
d. the Notification Center
Your company has a SharePoint server located in a datacentre in Montreal.
You plan to create a report in the Power BI service that will use Microsoft Excel files stored on the
SharePoint server.
You need to recommend a solution to ensure that the dataset for the report can automatically refresh
daily.
What should you include in the recommendation?
Select only one answer.
a. a Point to Site virtual private network (VPN)
b. a Site-to-Site virtual private network (VPN)
c. an on-premises data gateway
d. Azure Data Box
- correct answer c. an on-premises data gateway
You have a row level security role (RLS) in a dataset called User Security Group. This role needs to filter a
RLS table that contains a column with the emails of users in the following format:
