PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
You manage a Power BI workspace in shared capacity. The
workspace contains a report that uses a dataset named DS1.
You need to implement an incremental refresh of DS1.
What should you do first?
A. In Power BI Desktop, define filter parameters.
B. In Power BI Desktop, define the incremental refresh policy.
C. Publish the dataset to the Power BI service.
D. Upgrade the Power BI workspace to the Premium SKU. -
correct answer ✅A. In Power BI Desktop, define filter parameters;
To implement an incremental refresh of the dataset, you first need
to define an incremental refresh policy, which, in turn, requires
defining filter parameters.
You manage a Power BI workspace.
You need to delegate the task to schedule data refreshes. The
solution must use the principle of least privilege.
Which role should you use?
Select only one answer.
A. Admin
, PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
B. Contributor
C. Member
D. Viewer -
correct answer ✅B. The Contributor role is the least privileged role
that grants permissions to schedule data refreshes. The Viewer role
does not grant the permissions to schedule data refreshes.
You need to assign an app workspace role for users who consume
reports.
Users should only have permissions to examine the report.
Which role should you assign to users?
Select only one answer.
A. Admin role
B. Contributor role
C. Member role
D. Viewer role -
correct answer ✅D. The Viewer role only has reader access to view
reports and dashboards. The Contributor role can create, update, or
publish content. The Member role has many edit permissions in a
workspace, similar to an admin. The Admin role has all the edit
permission in a workspace.
, PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
Select only one answer.
A. OneDrive for Business
B. Personal OneDrive account
C. SharePoint Online Team Sites
D. Shared folder on a local network -
correct answer ✅D. The shared folder on a local network will
require a gateway as it is not available to the internet. SharePoint
Online, OneDrive, and OneDrive for Business all can be refreshed as
cloud data sources without a gateway.
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.
, PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
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. and D.: A personal OneDrive account provides
the ability to automatically synchronize flat files residing in a user's
OneDrive and Power BI datasets. Since it relies on OneDrive access,
it requires the user's credentials of the corresponding Microsoft
account. The OneDrive - Business option uses Azure Active
Directory credentials. The SharePoint - Team Sites option uses the
same Azure Active Directory credentials as the ones used to access
SharePoint Online.
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in
the Power Query interface? Each
correct answer presents a complete solution.
Analyst Exam Questions & Answers
You manage a Power BI workspace in shared capacity. The
workspace contains a report that uses a dataset named DS1.
You need to implement an incremental refresh of DS1.
What should you do first?
A. In Power BI Desktop, define filter parameters.
B. In Power BI Desktop, define the incremental refresh policy.
C. Publish the dataset to the Power BI service.
D. Upgrade the Power BI workspace to the Premium SKU. -
correct answer ✅A. In Power BI Desktop, define filter parameters;
To implement an incremental refresh of the dataset, you first need
to define an incremental refresh policy, which, in turn, requires
defining filter parameters.
You manage a Power BI workspace.
You need to delegate the task to schedule data refreshes. The
solution must use the principle of least privilege.
Which role should you use?
Select only one answer.
A. Admin
, PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
B. Contributor
C. Member
D. Viewer -
correct answer ✅B. The Contributor role is the least privileged role
that grants permissions to schedule data refreshes. The Viewer role
does not grant the permissions to schedule data refreshes.
You need to assign an app workspace role for users who consume
reports.
Users should only have permissions to examine the report.
Which role should you assign to users?
Select only one answer.
A. Admin role
B. Contributor role
C. Member role
D. Viewer role -
correct answer ✅D. The Viewer role only has reader access to view
reports and dashboards. The Contributor role can create, update, or
publish content. The Member role has many edit permissions in a
workspace, similar to an admin. The Admin role has all the edit
permission in a workspace.
, PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
You plan to get data from flat files for a Power BI dataset.
You need to select a location to store the files.
Which location requires an on-premises data gateway?
Select only one answer.
A. OneDrive for Business
B. Personal OneDrive account
C. SharePoint Online Team Sites
D. Shared folder on a local network -
correct answer ✅D. The shared folder on a local network will
require a gateway as it is not available to the internet. SharePoint
Online, OneDrive, and OneDrive for Business all can be refreshed as
cloud data sources without a gateway.
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.
, PL-300: Microsoft Power BI Data
Analyst Exam Questions & Answers
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. and D.: A personal OneDrive account provides
the ability to automatically synchronize flat files residing in a user's
OneDrive and Power BI datasets. Since it relies on OneDrive access,
it requires the user's credentials of the corresponding Microsoft
account. The OneDrive - Business option uses Azure Active
Directory credentials. The SharePoint - Team Sites option uses the
same Azure Active Directory credentials as the ones used to access
SharePoint Online.
You need to make changes to your data sources.
Which three changes are supported by the Data Source Settings in
the Power Query interface? Each
correct answer presents a complete solution.
