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. What is the primary purpose of a gateway cluster in Power BI?

    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.

  2. Which Power BI Premium feature partitions a large table by date so that only new or changed data is loaded during each refresh?

    Answer: Incremental refresh

    Incremental refresh defines date-based partitions and refreshes only the recent partition window, dramatically reducing refresh duration and resource usage.

  3. When connecting Power BI Service to Azure SQL Database, which statement is correct regarding gateway requirements?

    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.

  4. What is the maximum compressed dataset size allowed in a Power BI Pro workspace when using Import mode?

    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.

  5. Which authentication methods can be configured for a data source on an on-premises data gateway?

    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.

  6. In Power BI Service, where are credentials for an on-premises gateway data source configured?

    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.

  7. Which Power BI dataset storage mode provides the best compatibility with the Q&A natural language feature?

    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.