PL-300 Data Connectivity and Gateways 2 — Questions and Answers
Question 1: What is the primary purpose of a gateway cluster in Power BI?
- To increase dataset storage capacity beyond 1 GB
- To provide high availability and load balancing for gateway connections (Correct answer)
- To connect multiple Power BI workspaces to a single dataset
- To enable row-level security across multiple gateways
Correct answer: To provide high availability and load balancing for gateway connections
A gateway cluster groups multiple gateway machines together so that if one fails, another handles requests, providing high availability and distributing load.
Question 2: Which Power BI Premium feature partitions a large table by date so that only new or changed data is loaded during each refresh?
- DirectQuery refresh
- Live refresh
- Incremental refresh (Correct answer)
- Differential refresh
Correct answer: Incremental refresh
Incremental refresh defines date-based partitions and refreshes only the recent partition window, dramatically reducing refresh duration and resource usage.
Question 3: When connecting Power BI Service to Azure SQL Database, which statement is correct regarding gateway requirements?
- An on-premises gateway is always required
- No gateway is required because both services are cloud-based (Correct answer)
- A personal mode gateway must be used
- A VPN connection must be established instead
Correct answer: No gateway is required because both services are cloud-based
Because Azure SQL Database is a cloud service, Power BI Service can connect to it directly without a gateway; gateways are only needed for on-premises data sources.
Question 4: What is the maximum compressed dataset size allowed in a Power BI Pro workspace when using Import mode?
- 100 MB
- 1 GB (Correct answer)
- 10 GB
- 100 GB
Correct answer: 1 GB
Power BI Pro enforces a 1 GB compressed dataset size limit; larger datasets require Power BI Premium or Premium Per User capacity.
Question 5: Which authentication methods can be configured for a data source on an on-premises data gateway?
- OAuth 2.0 only
- Windows authentication only
- Windows, Basic, or OAuth2 depending on the data source (Correct answer)
- API key authentication only
Correct answer: Windows, Basic, or OAuth2 depending on the data source
The on-premises data gateway supports Windows, Basic, and OAuth2 authentication methods, with the available options depending on what the specific data source supports.
Question 6: In Power BI Service, where are credentials for an on-premises gateway data source configured?
- In the Power BI Desktop connection dialog before publishing
- In gateway management under Settings > Manage gateways (Correct answer)
- In the Azure portal resource group for the gateway
- In the Power BI Admin portal under tenant settings
Correct answer: In gateway management under Settings > Manage gateways
Data source credentials are set in the gateway management section (Settings > Manage gateways) in Power BI Service, where administrators define and secure each data source.
Question 7: Which Power BI dataset storage mode provides the best compatibility with the Q&A natural language feature?
- DirectQuery only
- Import mode (Correct answer)
- Live Connection to Analysis Services only
- Composite models only
Correct answer: Import mode
Power BI's Q&A feature works natively and most effectively with Import mode datasets because all data is available in memory for fast query generation.
PL-300 Data Connectivity and Gateways 2
What is the primary purpose of a gateway cluster in Power BI?