PL-300 Data Connectivity and Gateways 1 — Questions and Answers
Question 1: Which on-premises data gateway mode supports multiple users and multiple data sources in Power BI?
- Personal mode
- Standard mode (Correct answer)
- Enterprise cluster mode
- Shared mode
Correct answer: Standard mode
Standard mode (also called enterprise mode) supports multiple users and multiple data sources, making it suitable for organizational deployments.
Question 2: In Power BI, which connection mode sends a new query to the data source every time a user interacts with a visual?
- Import
- DirectQuery (Correct answer)
- Live Connection
- Composite
Correct answer: DirectQuery
DirectQuery sends queries directly to the underlying data source each time a visual is rendered or filtered, ensuring data is always current.
Question 3: What is the maximum number of scheduled dataset refreshes per day for a Power BI Pro workspace?
- 4
- 8 (Correct answer)
- 24
- 48
Correct answer: 8
Power BI Pro limits scheduled refresh to 8 times per day (approximately every 3 hours), while Power BI Premium allows up to 48 refreshes per day.
Question 4: Which type of on-premises data gateway requires the installing user to be signed in to Windows for the gateway to remain active?
- Standard mode gateway
- Personal mode gateway (Correct answer)
- Gateway cluster node
- Cloud gateway
Correct answer: Personal mode gateway
The personal mode gateway runs under the installing user's Windows session and stops working when that user signs out, unlike the standard mode which runs as a Windows service.
Question 5: In Power BI Import mode, when does the engine retrieve data from the source?
- Every time a visual is rendered
- Only during scheduled or manual refresh operations (Correct answer)
- Continuously in real time
- When a user first opens the report each day
Correct answer: Only during scheduled or manual refresh operations
Import mode loads data into Power BI's in-memory VertiPaq engine only during scheduled or on-demand refresh; visuals are served from the cached copy.
Question 6: What is required to allow Power BI Service to refresh a dataset sourced from an on-premises SQL Server database?
- A Power BI Premium license
- An on-premises data gateway (Correct answer)
- A DirectQuery-only connection
- An Azure SQL Database mirror
Correct answer: An on-premises data gateway
An on-premises data gateway bridges Power BI Service (cloud) with on-premises data sources like SQL Server, enabling scheduled refresh.
Question 7: Which Power BI connection mode allows a single model to combine data from both Import and DirectQuery sources?
- Live Connection
- Hybrid mode
- Composite model (Correct answer)
- Dual storage
Correct answer: Composite model
Composite models allow tables within a single Power BI model to use different storage modes (Import or DirectQuery), enabling flexibility across multiple data sources.
PL-300 Data Connectivity and Gateways 1
Which on-premises data gateway mode supports multiple users and multiple data sources in Power BI?