Question 1

Which of the following statements is NOT a core functionality of Power BI?

Accepted Answer

Creating interactive data visualizations.

Answer

Performing data analysis and manipulation.

Answer

Creating and managing data warehouses.

Answer

Extracting data from various sources.

Question 2

Power BI utilizes a data modeling technique known as:

Accepted Answer

In-memory BI.

Answer

Relational database model.

Answer

Object-oriented programming model.

Answer

Cloud-based data model.

Question 3

What is the primary file format used for saving reports and dashboards in Power BI Desktop?

Accepted Answer

.pbix

Answer

.pptx

Answer

.docx

Answer

.xlsx

Question 4

Power BI integrates seamlessly with which of the following Microsoft products?

Accepted Answer

Microsoft Excel

Answer

Microsoft Visio

Answer

Microsoft Access

Answer

Microsoft Project

Question 5

DAX (Data Analysis Expressions) is a formula language used in Power BI for:

Accepted Answer

Creating calculated columns and measures.

Answer

Scheduling report refreshes.

Answer

Formatting data visualizations.

Answer

Managing user permissions.

Question 6

Which of the following is NOT a visualization type available in Power BI?

Accepted Answer

Scatter charts

Answer

Funnel charts

Answer

Treemaps

Answer

Gauge charts

Question 7

What is the role of a slicer in a Power BI report?

Accepted Answer

Interactively filter data based on specific selections.

Answer

Display additional data fields.

Answer

Format the visual appearance of charts.

Answer

Create hierarchies within datasets.

Question 8

Connecting to live data sources in Power BI allows for:

Accepted Answer

Real-time data visualization and analysis.

Answer

Improving data processing speed.

Answer

Enhancing data security measures.

Answer

Maintaining separate data copies.

Question 9

What is the benefit of using Power BI gateways when working with on-premises data sources?

Accepted Answer

Securely connect to data sources that are not publicly accessible.

Answer

Share reports and dashboards with external users.

Answer

Optimize data refresh schedules.

Answer

Enable collaboration among report creators.

Question 10

Azure Analysis Services (AAS) is a cloud-based analytical service that can be used with Power BI to:

Accepted Answer

Scale data storage and processing capabilities.

Answer

Implement role-based access control.

Answer

Enhance data visualization aesthetics

Answer

Automate report distribution workflows.

Related quizzes

Related quizzes