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

Full refresh

Answer

Scheduled refresh

Answer

Manual refresh

Question 2

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

Accepted Answer

8

Answer

4

Answer

24

Answer

48

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

Basic (username/password) authentication

Answer

Windows authentication (Kerberos)

Answer

Anonymous authentication

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

Merging multiple queries into a single query step

Answer

Collapsing query results into fewer output rows

Answer

Automatically converting M code transformations into DAX measures

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

Standard (Enterprise) gateway

Answer

VNet Data Gateway

Answer

Cloud gateway

Question 6

In Power BI Service, what are 'data source credentials' used for?

Accepted Answer

Authentication details stored in the Service so that scheduled refresh can connect to underlying data sources

Answer

Credentials that Power BI admins use to log into the admin portal

Answer

The login credentials required by end users to view a published report

Answer

Encryption keys used to secure dataset files at rest

Question 7

Which of the following best describes a 'Push dataset' in Power BI?

Accepted Answer

A dataset that receives data sent programmatically via the Power BI REST API for real-time updates

Answer

A dataset that automatically exports data to external systems

Answer

A dataset published from Power BI Desktop to the Power BI Service

Answer

A dataset pushed from Power BI Service to a SharePoint document library