Data Connectivity and Gateways Flashcards
7 cards from real PL-300 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Data Connectivity and Gateways flashcards as text
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?
Answer: Dual storage mode
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.
Which Power BI feature allows a DirectQuery-based report page to refresh its visuals automatically at a configured time interval?
Answer: Automatic page refresh
Automatic page refresh enables visuals on DirectQuery and Live Connection reports to update at set intervals (seconds or minutes) without any user action.
Which of the following is a known limitation of DirectQuery mode compared to Import mode in Power BI?
Answer: DirectQuery restricts certain DAX functions and may result in slower report performance
DirectQuery prohibits time-intelligence and certain other DAX functions and relies on source query performance, often resulting in slower visual rendering than Import mode.
What is the maximum number of scheduled refreshes per day available on a Power BI Premium capacity?
Answer: 48
Power BI Premium supports up to 48 scheduled dataset refreshes per day, compared to the 8-per-day limit in Power BI Pro.
Which gateway mode is supported when configuring an on-premises data source for Power BI Dataflows?
Answer: Standard (enterprise) mode gateway only
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.
What happens to a DirectQuery Power BI report in Power BI Service when its underlying data source becomes unavailable?
Answer: The report fails to load visuals and displays a connection error
Because DirectQuery has no local data cache, any source outage immediately causes report visuals to fail with a connection error rather than falling back to cached data.
Which connection feature in Power BI Desktop allows you to build a composite model on top of an existing published Power BI dataset in Power BI Service?
Answer: DirectQuery for Power BI datasets
DirectQuery for Power BI datasets allows Desktop to connect to a published dataset and add new tables or relationships on top of it, enabling composite models from shared datasets.