PL-300 Data Connectivity and Gateways 3

Question 1

In a Power BI composite model, which storage mode setting allows a table to be queried from either the in-memory cache or sent directly to the source?

Accepted Answer

Dual storage mode

Answer

Dual storage mode stores a cached copy of the table and also allows DirectQuery access to the source, giving Power BI flexibility to choose the fastest query path.

Question 2

Which Power BI feature allows a DirectQuery-based report page to refresh its visuals automatically at a configured time interval?

Accepted Answer

Automatic page refresh

Answer

Automatic page refresh enables visuals on DirectQuery and Live Connection reports to update at set intervals (seconds or minutes) without any user action.

Question 3

Which of the following is a known limitation of DirectQuery mode compared to Import mode in Power BI?

Accepted Answer

DirectQuery restricts certain DAX functions and may result in slower report performance

Answer

DirectQuery prohibits time-intelligence and certain other DAX functions and relies on source query performance, often resulting in slower visual rendering than Import mode.

Question 4

What is the maximum number of scheduled refreshes per day available on a Power BI Premium capacity?

Accepted Answer

48

Answer

Power BI Premium supports up to 48 scheduled dataset refreshes per day, compared to the 8-per-day limit in Power BI Pro.

Question 5

Which gateway mode is supported when configuring an on-premises data source for Power BI Dataflows?

Accepted Answer

Standard (enterprise) mode gateway only

Answer

Power BI Dataflows require the standard (enterprise) on-premises data gateway for connecting to on-premises sources; personal mode is not supported for service-level features.

PL-300 Power BI Practice Test

PL-300 Power BI Practice Test

PL-300 Data Connectivity and Gateways 3