Power BI Data Connectivity and Data Sources Flashcards
7 cards from real Microsoft Power BI practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Power BI Data Connectivity and Data Sources flashcards as text
Which Power BI refresh strategy updates only the newly added or changed data partitions rather than reloading the entire dataset?
Answer: Incremental refresh
Incremental refresh in Power BI defines date-based partitions and refreshes only the most recent range, dramatically reducing refresh duration and resource consumption for large datasets.
How many scheduled dataset refreshes per day does Power BI Pro allow?
Answer: 8
Power BI Pro allows up to 8 scheduled refreshes per day per dataset, compared to up to 48 per day for Power BI Premium capacity.
Which authentication method does Power BI use when connecting to Azure SQL Database with organizational credentials?
Answer: OAuth2 / Microsoft account (Azure AD)
Azure SQL Database in Power BI supports OAuth2 authentication via Azure Active Directory, allowing users to sign in with their organizational Microsoft account.
What does 'Query Folding' mean in Power BI's Power Query?
Answer: Pushing data transformation steps back to the data source as native queries
Query folding translates Power Query transformation steps into native source queries (e.g., SQL), so processing happens at the source rather than in Power BI, improving performance.
Which On-premises Data Gateway type is installed for a single user and cannot be shared across an organization?
Answer: Personal gateway
The Personal gateway is designed for individual use only; it cannot be shared with other users or used for datasets owned by others in the organization.
In Power BI Service, what are 'data source credentials' used for?
Answer: Authentication details stored in the Service so that scheduled refresh can connect to underlying data sources
Data source credentials in Power BI Service store the authentication information (username/password, OAuth token, etc.) that the Service uses to connect to data sources during scheduled refresh.
Which of the following best describes a 'Push dataset' in Power BI?
Answer: A dataset that receives data sent programmatically via the Power BI REST API for real-time updates
A Push dataset accepts data sent via the Power BI REST API, enabling real-time ingestion that immediately updates pinned dashboard tiles without a scheduled refresh.