EXAM PL-300: MICROSOFT POWER BI DATA ANALYST
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
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. Ans✓✓✓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
B. Contributor
,C. Member
D. Viewer Ans✓✓✓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 Ans✓✓✓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.
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 Ans✓✓✓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.
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 Ans✓✓✓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.
Select all answers that apply.
A. adding a column
B. clearing permissions
C. editing permissions
D. modifying the file path
E. renaming a column Ans✓✓✓B. clearing permissions
C. editing permissions
D. modifying the file path
Any structural changes to a file, such as adding, removing, or renaming
columns are not supported by the Data Source Settings in the Power
Query interface.
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.
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+||BRAND NEW
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. Ans✓✓✓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
B. Contributor
,C. Member
D. Viewer Ans✓✓✓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 Ans✓✓✓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.
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 Ans✓✓✓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.
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 Ans✓✓✓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.
Select all answers that apply.
A. adding a column
B. clearing permissions
C. editing permissions
D. modifying the file path
E. renaming a column Ans✓✓✓B. clearing permissions
C. editing permissions
D. modifying the file path
Any structural changes to a file, such as adding, removing, or renaming
columns are not supported by the Data Source Settings in the Power
Query interface.
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.
