PL - 300 MICROSOFT POWER BI DATA ANALYST
PRACTICE QUESTIONS |NEW AND UPDATED 2026
|WITH VERIFIED QUESTIONS AND ANSWERS!!!
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
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
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
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
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
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
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.
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
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.
PRACTICE QUESTIONS |NEW AND UPDATED 2026
|WITH VERIFIED QUESTIONS AND ANSWERS!!!
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
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
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
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
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
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
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.
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
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.
