Question 1

Which DAX function is used to calculate the cumulative total in Power BI?

Accepted Answer

TOTALYTD

Answer

RUNNINGTOTAL

Answer

SUM

Answer

CUMULATIVESUM

Question 2

In Power BI, what is the primary purpose of the 'Edit Interactions' feature?

Accepted Answer

To control how visuals interact with each other

Answer

To modify data source settings

Answer

To create new calculated columns

Answer

To export data to Excel

Question 3

When would you use the 'ALLEXCEPT' DAX function?

Accepted Answer

To remove filters from all columns in a table except specified ones

Answer

To remove all filters from a table

Answer

To keep all filters in a table

Answer

To apply filters to specific columns

Question 4

What is the main use of the 'UserPrincipalName' function in Power BI?

Accepted Answer

To get the user identity for dynamic security

Answer

To get the department of the user

Answer

To get the role of the user

Answer

To get the last login time of the user

Question 5

In Power BI, how can you optimize performance when dealing with large datasets?

Accepted Answer

Use aggregations and reduce the number of visuals on the report page

Answer

Increase the number of data imports

Answer

Load data more frequently

Answer

Use more visuals on the report page

Question 6

How can you create a dynamic measure that changes based on slicer selection?

Accepted Answer

Using a disconnected table and SWITCH function

Answer

Using conditional formatting

Answer

Using a calculated column

Answer

Using a filter condition

Question 7

Which feature in Power BI allows you to drill through to a detailed report from a summary report?

Accepted Answer

Drillthrough

Answer

Page Navigation

Answer

Cross-Report

Answer

Hierarchy

Question 8

What is the main advantage of using DirectQuery mode over Import mode?

Accepted Answer

Live connection to data, no data is stored in Power BI

Answer

Data is stored in Power BI for faster performance

Answer

Requires less storage in Power BI

Answer

Allows for better compression of data

Question 9

Which Power BI component would you use to share reports with other users within an organization?

Accepted Answer

Workspaces

Answer

Dashboards

Answer

Reports

Answer

Apps

Question 10

How can you perform a many-to-many relationship in Power BI?

Accepted Answer

By using a bridge table

Answer

By creating multiple relationships

Answer

By using direct query

Answer

By creating a calculated column

Question 11

What is the purpose of using 'CALCULATE' function in DAX?

Accepted Answer

To modify the filter context of a measure

Answer

To summarize data

Answer

To join two tables

Answer

To create a new table

Question 12

In Power BI, what is the 'What If' parameter used for?

Accepted Answer

To perform sensitivity analysis

Answer

To apply data validation rules

Answer

To validate data entries

Answer

To create what-if scenarios

Question 13

How do you implement row-level security (RLS) in Power BI?

Accepted Answer

Define roles and apply them to user groups

Answer

Using bookmarks

Answer

Using R scripts

Answer

Using gateways

Question 14

What is the use of 'Bookmarks' in Power BI?

Accepted Answer

To capture the current state of a report page

Answer

To create multiple versions of a report

Answer

To create a report template

Answer

To manage report page layouts

Question 15

How can you schedule data refreshes in Power BI Service?

Accepted Answer

Using the dataset refresh settings in Power BI Service

Answer

Using Azure Data Factory

Answer

Using Excel scheduler

Answer

Using Power BI Desktop

Question 16

What is the main purpose of 'Quick Measures' in Power BI?

Accepted Answer

To create commonly used calculations quickly

Answer

To automate data refresh

Answer

To build visual relationships

Answer

To manage data sources

Question 17

How do you handle circular dependencies in Power BI relationships?

Accepted Answer

By using bi-directional filtering carefully

Answer

By creating more calculated columns

Answer

By using complex DAX expressions

Answer

By avoiding relationships

Question 18

Which visualization would you use to show the relationship between two quantitative variables in Power BI?

Accepted Answer

Scatter Chart

Answer

Pie Chart

Answer

Bar Chart

Answer

Line Chart

Question 19

What is the purpose of 'Publish to web' feature in Power BI?

Accepted Answer

To share reports publicly on the web

Answer

To publish reports to Power BI Service

Answer

To export reports to PDF

Answer

To publish reports to SharePoint

Question 20

How can you create a custom tooltip in Power BI?

Accepted Answer

By creating a separate page with the desired tooltip visuals

Answer

By configuring report settings

Answer

By modifying page interactions

Answer

By adding custom fields to a report page

Related quizzes

Related quizzes