Practice Test GeeksPL-300 Power BI Practice Test
← All PL-300 Flashcard Decks

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

  1. Which on-premises data gateway mode supports multiple users and multiple data sources in Power BI?

    Answer: Standard mode

    Standard mode (also called enterprise mode) supports multiple users and multiple data sources, making it suitable for organizational deployments.

  2. In Power BI, which connection mode sends a new query to the data source every time a user interacts with a visual?

    Answer: DirectQuery

    DirectQuery sends queries directly to the underlying data source each time a visual is rendered or filtered, ensuring data is always current.

  3. What is the maximum number of scheduled dataset refreshes per day for a Power BI Pro workspace?

    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.

  4. Which type of on-premises data gateway requires the installing user to be signed in to Windows for the gateway to remain active?

    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.

  5. In Power BI Import mode, when does the engine retrieve data from the source?

    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.

  6. What is required to allow Power BI Service to refresh a dataset sourced from an on-premises SQL Server database?

    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.

  7. Which Power BI connection mode allows a single model to combine data from both Import and DirectQuery sources?

    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.