Microsoft Power BI Power BI Data Connectivity and Data Sources

Question 1

What connection mode allows Power BI to query data directly from the source without importing it into the data model?

Accepted Answer

DirectQuery mode

Answer

Import mode

Answer

Live Connection mode

Answer

Push mode

Question 2

Which of the following data sources supports Live Connection in Power BI Desktop?

Accepted Answer

SQL Server Analysis Services (SSAS)

Answer

SQL Server database (import)

Answer

Excel workbook

Answer

SharePoint list

Question 3

In Power BI Desktop's Import mode, what limits how many rows can be loaded from a data source?

Accepted Answer

Available system memory — there is no fixed row cap

Answer

A hard limit of 1 million rows

Answer

A hard limit of 100 million rows

Answer

A hard limit of 10 million rows

Question 4

Which connectors in Power BI can be used to retrieve data from REST APIs?

Accepted Answer

Both the OData Feed connector and the Web connector

Answer

Only the OData Feed connector

Answer

Only the Web connector

Answer

Only the SQL Server connector

Question 5

What is the primary purpose of the On-premises Data Gateway in Power BI?

Accepted Answer

To enable Power BI Service to securely access on-premises data sources

Answer

To increase scheduled refresh frequency in Power BI Service

Answer

To compress datasets before uploading them to the cloud

Answer

To automatically create table relationships in imported data

Question 6

Which of the following is NOT a valid storage mode in Power BI Desktop?

Accepted Answer

Hybrid Query

Answer

Import

Answer

DirectQuery

Answer

Live Connection

Question 7

When connecting Power BI to an Excel file, which structural elements can be loaded as individual tables?

Accepted Answer

Excel Tables, named ranges, and entire worksheets

Answer

Only named ranges

Answer

Only Excel Tables (ListObjects)

Answer

Only entire worksheets