PL-300 Data Connectivity and Gateways 2

Question 1

What is the primary purpose of a gateway cluster in Power BI?

Accepted Answer

To provide high availability and load balancing for gateway connections

Answer

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?

Accepted Answer

Incremental refresh

Answer

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?

Accepted Answer

No gateway is required because both services are cloud-based

Answer

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?

Accepted Answer

1 GB

Answer

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?

Accepted Answer

Windows, Basic, or OAuth2 depending on the data source

Answer

The on-premises data gateway supports Windows, Basic, and OAuth2 authentication methods, with the available options depending on what the specific data source supports.

PL-300 Power BI Practice Test

PL-300 Power BI Practice Test

PL-300 Data Connectivity and Gateways 2