Question 1

What is the primary purpose of using Power Query in Power BI?

Accepted Answer

To extract, transform, and load data

Answer

To manage user permissions

Answer

To create visualizations

Answer

To write DAX formulas

Question 2

Which visual would you use to display the distribution of a single variable?

Accepted Answer

Histogram

Answer

Pie Chart

Answer

Scatter Plot

Answer

Line Chart

Question 3

How can you create a relationship between two tables in Power BI?

Accepted Answer

By using a common column (key)

Answer

By using similar data types

Answer

By using calculated columns

Answer

By matching table names

Question 4

What does DAX stand for?

Accepted Answer

Data Analysis Expressions

Answer

Data Aggregation Expressions

Answer

Dynamic Analysis Expressions

Answer

Data Analytics Extensions

Question 5

Which function is used in DAX to create a calculated column that concatenates two text columns?

Accepted Answer

CONCATENATE

Answer

JOIN

Answer

MERGE

Answer

COMBINE

Question 6

What is the use of a slicer in Power BI?

Accepted Answer

To filter data in reports

Answer

To join multiple datasets

Answer

To aggregate data

Answer

To create new data columns

Question 7

Which Power BI feature allows you to see the data behind a visual?

Accepted Answer

Drillthrough

Answer

Tooltip

Answer

Bookmark

Answer

Filter

Question 8

How do you create a measure in Power BI?

Accepted Answer

By using DAX formulas

Answer

By using relationships

Answer

By using Power Query

Answer

By using visualizations

Question 9

What is the purpose of the CALCULATE function in DAX?

Accepted Answer

To modify the filter context of a calculation

Answer

To change data types

Answer

To join tables

Answer

To create a new table

Question 10

Which feature in Power BI allows for natural language querying?

Accepted Answer

Q&A

Answer

Power Query

Answer

DAX Studio

Answer

Quick Insights

Question 11

How can you improve the performance of a Power BI report?

Accepted Answer

By optimizing data models and using aggregations

Answer

By using larger datasets

Answer

By adding more visuals

Answer

By increasing data refresh frequency

Question 12

Which Power BI feature helps in tracking changes over time?

Accepted Answer

Time Intelligence functions

Answer

Bookmarks

Answer

Drillthrough

Answer

Trend Lines

Question 13

What is a Power BI Dataflow?

Accepted Answer

A collection of data transformation steps stored in the cloud

Answer

A DAX function

Answer

A visualization template

Answer

A type of report

Question 14

Which DAX function returns the last date in the current context?

Accepted Answer

LASTDATE

Answer

FINALDATE

Answer

ENDDATE

Answer

MAXDATE

Question 15

How can you create hierarchies in Power BI?

Accepted Answer

By dragging and dropping columns into a hierarchy field

Answer

By using Power Query

Answer

By using slicers

Answer

By writing DAX functions

Question 16

What is the purpose of Power BI Service?

Accepted Answer

To share and collaborate on Power BI reports and dashboards online

Answer

To install Power BI Desktop

Answer

To write DAX formulas

Answer

To create data models

Question 17

Which feature allows you to embed Power BI reports into other applications?

Accepted Answer

Power BI Embedded

Answer

Power BI Service

Answer

Power BI Desktop

Answer

Power BI Gateway

Question 18

What is the role of Power BI Gateway?

Accepted Answer

To connect on-premises data sources to Power BI Service

Answer

To design visualizations

Answer

To build data models

Answer

To create DAX formulas

Question 19

Which Power BI feature allows users to create reports with predefined templates?

Accepted Answer

Power BI Template Apps

Answer

Power BI Gateway

Answer

Power BI Service

Answer

Power BI Embedded

Question 20

How can you restrict access to sensitive data in Power BI reports?

Accepted Answer

By using Row-Level Security (RLS)

Answer

By using bookmarks

Answer

By using themes

Answer

By using slicers

Related quizzes

Related quizzes