Module quiz: Data sources in Power BI :Extract, Transform and Load Data in Power BI (Microsoft Power BI Data Analyst Professional Certificate) Answers 2025

Question 1

Structured Data can be easily analyzed and stored in __________ databases.

✅ SQL
❌ Azure Data Lake
❌ NoSQL databases

Explanation:
Structured data fits well into relational (SQL) databases because it follows a fixed schema with rows and columns.

Question 2

True or False: Power BI can connect to custom codes such as R script, Python script or providers like ODBC or OLE DB inside the Other section in the Get Data window.

✅ True
❌ False

Explanation:
Power BI supports connections to R scripts, Python scripts, ODBC, and OLE DB under the Other data sources section.

Question 3

True or False: When you create reports in Power BI, the named tables and columns in the Fields pane make it much easier to visualize your data.

✅ True
❌ False

Explanation:
Clear table and column names in the Fields pane help users quickly understand and build accurate visualizations.

Question 4

Which file types do Microsoft Excel workbooks in Power BI support?

✅ .xlsx and .xlsm
❌ .doc and .docx
❌ .pdf and .jpg

Explanation:
Power BI supports Excel workbook formats such as .xlsx and .xlsm for data import.

Question 5

As a data analyst, what should you do if your Excel workbook contains multiple sheets with sales data (date, product, quantity, revenue)?

❌ Convert them into charts
❌ Leave them as simple worksheets
✅ Format them as tables

Explanation:
Formatting data as tables makes it easier for Power BI to recognize structure and relationships.

Question 6

What is the benefit of setting up an Excel data source for Power BI?

✅ To work more efficiently with data, collaborate better, and gain insights
❌ To create a backup copy of the data
❌ To export the data to another format

Explanation:
Power BI enhances collaboration, efficiency, and insight generation from Excel data sources.

Question 7

True or False: Configuring incremental refresh requires defining an incremental refresh policy only.

❌ True
✅ False

Explanation:
Incremental refresh also requires parameters, filters, and proper data source configuration, not just the policy.

Question 8

What type of dataset requires a source data refresh in Power BI?

❌ DirectQuery datasets
❌ LiveConnect mode datasets
✅ Import mode datasets

Explanation:
Import mode datasets store data in Power BI and therefore require scheduled or manual refresh.

Question 9

Which of the following is a limitation of data sources used in Power BI service and Power BI Desktop?

❌ Maximum 500 data sources per user
✅ Several connectors require Internet Explorer 10 or newer for authentication
❌ Dataset limited to 10,000 total columns

Explanation:
Some Power BI connectors rely on Internet Explorer–based authentication, which is a known limitation.

Question 10

Which action cannot be undertaken once you set the storage mode of a table to Import?

✅ It cannot be switched to DirectQuery mode.
❌ It cannot be modified to Upload mode.
❌ It cannot be changed to Publish mode.

Explanation:
Once a table is set to Import mode, it cannot be directly switched to DirectQuery.

🧾 Summary Table