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

Question

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?

Options

• ADeploy an on-premises data gateway (personal mode). Import the data by using the Import Data
• BDeploy an on-premises data gateway. Import the data by using the Import Data Connectivity
• CDeploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity
• DDeploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery

Explanation

To ensure users always see current/live data from an on-premises SQL Server, DirectQuery mode is required - it queries the source database in real time on every interaction instead of caching a snapshot. A standard on-premises data gateway (not personal mode) is also required because personal mode gateways only support a single user and cannot be shared across an organization. Options A and B use Import mode, which stores a cached copy of the data that only updates on a scheduled refresh, meaning users may see stale data between refreshes. Option D uses personal mode, which cannot be shared with other users in the organization.

No community discussion yet for this question.