Which of the following is a valid use of the on-premises data gateway in Power BI?

Designing a report layout in Power BI Desktop.

Refreshing a semantic model that imports data from an on-premises SQL Server.

Creating a new workspace in the Power BI service.

Sending email subscriptions for a report.

You have a semantic model that uses an on-premises data source. You need to configure scheduled refresh, but you also need to ensure that the refresh does not overload the on-premises server during business hours. You have a gateway installed. What should you do?

Configure scheduled refresh to run during off-peak hours, such as 2:00 AM.

Configure multiple refresh times throughout the day to ensure freshness.

Use a data alert to trigger refresh when data changes.

Disable scheduled refresh and rely on manual refresh.

You have a semantic model in a workspace that imports data from an on-premises Oracle database. You need to configure scheduled refresh. You have installed an on-premises data gateway and added the Oracle data source to the gateway. However, the refresh fails with a 'credential not found' error. What is the most likely cause?

The credentials for the Oracle data source were not entered when adding the data source to the gateway.

The gateway is not running on the same server as the Oracle database.

The semantic model uses a live connection instead of import mode.

The scheduled refresh frequency is set to a time that conflicts with the gateway's maintenance window.

What is the purpose of configuring scheduled refresh for a Power BI semantic model?

To automatically update the data in the semantic model at specified intervals.

To create a backup of the semantic model.

To change the data source of the semantic model.

To share the semantic model with other users.

Microsoft Certified:Power BI Data Analyst Associate

Domain 4Objective 1

Create and Manage Workspaces and Assets PL-300 Practice Questions (Page 7)

Part of the Manage and secure Power BI domain, which accounts for 15–20% of the PL-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 3–7 from this objective — we provide 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

11concepts

15–20%of the exam

Questions 31–35

31foundation · easy
Which of the following is a valid use of the on-premises data gateway in Power BI?
Select an answer first
32expert · hard
You have a semantic model that uses an on-premises data source. You need to configure scheduled refresh, but you also need to ensure that the refresh does not overload the on-premises server during business hours. You have a gateway installed. What should you do?
Select an answer first
33foundation · easy
On which type of Power BI item can you set a data alert?
Select an answer first
34expert · hard
You have a semantic model in a workspace that imports data from an on-premises Oracle database. You need to configure scheduled refresh. You have installed an on-premises data gateway and added the Oracle data source to the gateway. However, the refresh fails with a 'credential not found' error. What is the most likely cause?
Select an answer first
35foundation · easy
What is the purpose of configuring scheduled refresh for a Power BI semantic model?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PL-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “PL-300” is a trademark of its owner, used for identification only.