PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
sensitivity labels -
correct answer ✅You have a Power BI tenant.
You have reports that use financial datasets and are exported as
PDF files.
You need to ensure that the reports are encrypted.
What should you implement?
dataset certifications
row-level security (RLS)
sensitivity labels
Microsoft Intune policies
an On-premises data gateway
When you've created dynamic reports in Power BI Desktop, you can
share them by publishing to your Power BI site. When you publish a
Power BI Desktop file with a live connection to a tabular model to
your Power BI site, an on-premises data gateway must be installed
and configured by an administrator. -
,PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
correct answer ✅You create a report by using Microsoft Power BI
Desktop.
The report uses data from a Microsoft SQL Server Analysis Services
(SSAS) cube located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement to ensure that users who consume the
report from the Power BI Service have the most up-to-date data
from the cube?
a subscription
a scheduled refresh of the dataset
an OData feed
an On-premises data gateway
Configure the dataset to use the existing On-premises data
gateway.
Set the refresh frequency to Daily.
,PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
"The dataset appends data from an on-premises Oracle database..."
-
correct answer ✅You publish a Microsoft Power BI dataset to
powerbi.com. The dataset appends data from an on-premises
Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an
existing On-premises data gateway for which the Oracle data source
is already configured.
You need to ensure that the data is updated every morning. The
solution must minimize configuration effort.
Which two actions should you perform when you configure
scheduled refresh?
Configure the dataset to use the existing On-premises data
gateway.
Deploy an On-premises data gateway in personal mode.
Set the refresh frequency to Daily.
Configure the dataset to use the personal gateway.
, PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
Query folding is not occurring.
"The dataset uses incremental refresh."
Query folding cannot take place when using incremental refresh. -
correct answer ✅You create a dataset sourced from dozens of flat
files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related
reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out
of resources.
What is a possible cause of the issue?
Query folding is not occurring.
You selected Only refresh complete periods.
The data type of the column used to partition the data changed.
A filter is missing on the report.
part 4 Exam Questions & Answers
(Grade A+)
sensitivity labels -
correct answer ✅You have a Power BI tenant.
You have reports that use financial datasets and are exported as
PDF files.
You need to ensure that the reports are encrypted.
What should you implement?
dataset certifications
row-level security (RLS)
sensitivity labels
Microsoft Intune policies
an On-premises data gateway
When you've created dynamic reports in Power BI Desktop, you can
share them by publishing to your Power BI site. When you publish a
Power BI Desktop file with a live connection to a tabular model to
your Power BI site, an on-premises data gateway must be installed
and configured by an administrator. -
,PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
correct answer ✅You create a report by using Microsoft Power BI
Desktop.
The report uses data from a Microsoft SQL Server Analysis Services
(SSAS) cube located on your company's internal network.
You plan to publish the report to the Power BI Service.
What should you implement to ensure that users who consume the
report from the Power BI Service have the most up-to-date data
from the cube?
a subscription
a scheduled refresh of the dataset
an OData feed
an On-premises data gateway
Configure the dataset to use the existing On-premises data
gateway.
Set the refresh frequency to Daily.
,PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
"The dataset appends data from an on-premises Oracle database..."
-
correct answer ✅You publish a Microsoft Power BI dataset to
powerbi.com. The dataset appends data from an on-premises
Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an
existing On-premises data gateway for which the Oracle data source
is already configured.
You need to ensure that the data is updated every morning. The
solution must minimize configuration effort.
Which two actions should you perform when you configure
scheduled refresh?
Configure the dataset to use the existing On-premises data
gateway.
Deploy an On-premises data gateway in personal mode.
Set the refresh frequency to Daily.
Configure the dataset to use the personal gateway.
, PL-300: Microsoft Power BI Data Analyst
part 4 Exam Questions & Answers
(Grade A+)
Query folding is not occurring.
"The dataset uses incremental refresh."
Query folding cannot take place when using incremental refresh. -
correct answer ✅You create a dataset sourced from dozens of flat
files in Azure Blob storage. The dataset uses incremental refresh.
From powerbi.com, you deploy the dataset and several related
reports to Microsoft Power BI Premium capacity.
You discover that the dataset refresh fails after the refresh runs out
of resources.
What is a possible cause of the issue?
Query folding is not occurring.
You selected Only refresh complete periods.
The data type of the column used to partition the data changed.
A filter is missing on the report.
