PL-300 Question #110: Real Exam Question with Answer & Explanation

Question

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? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

• AConfigure the dataset to use the existing On-premises data gateway.
• BDeploy an On-premises data gateway in personal mode.
• CSet the refresh frequency to Daily.
• DConfigure the dataset to use the personal gateway.

Explanation

The dataset combines data from an on-premises Oracle database (requiring a gateway) and an Azure SQL database. An enterprise On-premises data gateway is already installed and configured with the Oracle data source. To minimize configuration effort, you should (A) configure the dataset to use the existing gateway rather than deploying a new one-the Oracle source is already registered on it. You should also (C) set the refresh frequency to Daily so the data updates every morning. Deploying a personal mode gateway (choice B) would be redundant and personal gateways cannot be shared across workspace members, making them unsuitable for enterprise use. Configuring the dataset to use a personal gateway (choice D) would conflict with using the existing enterprise gateway and would not leverage the already-configured Oracle data source.

No community discussion yet for this question.