PL-300 Microsoft Power BI Data Analyst Pre-
Assessment Exam
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 - 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 - 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 - 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 - 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 - 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 - 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. - 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 - 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 - 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 - 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:
Which function should be used in the code for the RLS role to match the users Microsoft
Entra ID login credentials with the emails contained in the RLS table column?
Select only one answer.
a. NAMEOF
b. TREATAS
c. USEROBJECTID
d. USERPRINCIPALNAME - ANSWER-d. USERPRINCIPALNAME
You have a Power BI dataset.
You need to set the dataset as discoverable.
Which two configurations will allow the dataset to be marked as discoverable? Each
correct answer presents a complete solution.
Select all answers that apply.
a. Certify the dataset.
b. Enable RLS on the dataset.
c. Promote the dataset.
d. Publish dataset to a Premium workspace. - ANSWER-a. Certify the dataset.
Assessment Exam
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 - 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 - 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 - 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 - 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 - 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 - 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. - 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 - 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 - 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 - 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:
Which function should be used in the code for the RLS role to match the users Microsoft
Entra ID login credentials with the emails contained in the RLS table column?
Select only one answer.
a. NAMEOF
b. TREATAS
c. USEROBJECTID
d. USERPRINCIPALNAME - ANSWER-d. USERPRINCIPALNAME
You have a Power BI dataset.
You need to set the dataset as discoverable.
Which two configurations will allow the dataset to be marked as discoverable? Each
correct answer presents a complete solution.
Select all answers that apply.
a. Certify the dataset.
b. Enable RLS on the dataset.
c. Promote the dataset.
d. Publish dataset to a Premium workspace. - ANSWER-a. Certify the dataset.
