Microsoft Power BI Power BI Data Connectivity and Data Sources 3

Question 1

Which Power BI refresh strategy updates only the newly added or changed data partitions rather than reloading the entire dataset?

Accepted Answer

Incremental refresh

Answer

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.

Question 2

How many scheduled dataset refreshes per day does Power BI Pro allow?

Accepted Answer

8

Answer

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.

Question 3

Which authentication method does Power BI use when connecting to Azure SQL Database with organizational credentials?

Accepted Answer

OAuth2 / Microsoft account (Azure AD)

Answer

Azure SQL Database in Power BI supports OAuth2 authentication via Azure Active Directory, allowing users to sign in with their organizational Microsoft account.

Question 4

What does 'Query Folding' mean in Power BI's Power Query?

Accepted Answer

Pushing data transformation steps back to the data source as native queries

Answer

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.

Question 5

Which On-premises Data Gateway type is installed for a single user and cannot be shared across an organization?

Accepted Answer

Personal gateway

Answer

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.

Microsoft Power BI Practice Test

Microsoft Power BI Practice Test

Microsoft Power BI Power BI Data Connectivity and Data Sources 3