Power Bi (Expert)

Welcome to your Power Bi (Expert)

1.

What does DAX stand for in Power BI?

Deselect Answer

Data Analysis Expressions

Data Access Extensions

Dynamic Analysis Extensions

Data Aggregation Expressions

2.

Which visualization type in Power BI is used to display hierarchical data in a tree-like structure?

Deselect Answer

Line chart

Treemap

Gauge

Funnel

3.

What is the purpose of the Power Query Editor in Power BI?

Deselect Answer

To create calculated columns

To import and transform data

To create relationships between tables

To design report visuals

4.

Which DAX function is used to calculate the difference between two dates in Power BI?

Deselect Answer

DATEDIFF

DATEADD

DATEDIFFERENCE

DATEDELTA

5.

What is the maximum number of rows that can be exported to Excel from a Power BI report?

Deselect Answer

10,000

150,000

100,000

200,000

6.

Which Power BI feature is used to create calculated tables based on DAX expressions?

Deselect Answer

Measures

Calculated columns

Calculatetables

Slicers

7.

Which visualization type in Power BI is used to display the distribution of values in a dataset?

Deselect Answer

Scatter chart

Histogram

KPI

Waterfall chart

8.

What is the purpose of the Power BI Gateway?

Deselect Answer

To import data from cloud sources

To connect on-premises data sources to Power BI

To schedule data refreshes in Power BI

To share reports with external users

9.

Which DAX function is used to calculate the rank of values in a column?

Deselect Answer

RANKX

RANK

RANK.EQ

RANK.AVG

10.

What is the purpose of the Power BI Data Model?

Deselect Answer

To create visualizations

To import and transform data

To define relationships between tables

To publish reports to the Power BI Service

11.

Which visualization type in Power BI is used to display the progression of values over time?

Deselect Answer

Donut chart

Line chart

Radar chart

Matrix

12.

What is the purpose of the Power BI Q&A feature?

Deselect Answer

To create calculated measures

To import data from external sources

To visualize data using natural language queries

To schedule data refreshes

13.

Which DAX function is used to calculate the cumulative total of a column?

Deselect Answer

TOTALYTD

TOTALMTD

TOTALQTD

CUMULATIVETOTAL

14.

What is the purpose of the Power BI Performance Analyzer?

Deselect Answer

To monitor report performance

To create calculated columns

To import data from external sources

To share reports with external users

15.

Which visualization type in Power BI is used to compare values across categories and display the data distribution?

Deselect Answer

Box and whisker plot

Stacked bar chart

Area chart

Ribbon chart

16.

What is the purpose of the Power BI Dataflows feature?

Deselect Answer

To create calculated tables

To import and transform data

To connect to on-premises data sources

To publish reports to the Power BI Service

17.

Which DAX function is used to calculate the difference between the current row and the previous row in a column?

Deselect Answer

DIFF

DELTA

18.

What is the purpose of the Power BI Drillthrough feature?

Deselect Answer

To visualize data using natural language queries

To drill down into hierarchical data

To share reports with external users

To import data from external sources

19.

Which visualization type in Power BI is used to display values as part of a whole and show the percentage breakdown?

Deselect Answer

Pie chart

Gauge

Donut chart

Stacked area chart

20.

What is the purpose of the Power BI App Workspaces feature?

Deselect Answer

To import and transform data

To create and share dashboards and reports

To connect on-premises data sources

To monitor report performance

Please fill in the comment box below.

Leave a Reply Cancel reply