Power BI Certification

1. Which of the following is a key feature of Power BI?

Data visualization

Web development

Mobile app development

Game development

2. Which of the following is a component of Power BI?

Power BI Desktop

PowerPoint

Excel

Word

3. Which language is primarily used to create custom visuals in Power BI?

TypeScript

Python

Java

C#

4. Which of the following is used to create reports and dashboards in Power BI?

Power BI Service

PowerPoint

Excel

Word

5. Which of the following is used to schedule data refreshes in Power BI?

Power BI Gateway

PowerPoint

Excel

Word

6. Which of the following is used to create calculated columns and measures in Power BI?

DAX (Data Analysis Expressions)

M Language

SQL

R

7. Which of the following DAX functions is used to create a calculated table?

GENERATE

ADDCOLUMNS

SUMMARIZE

DATATABLE

8. What is the purpose of Power Query in Power BI?

To connect, combine, and transform data from various sources

To create visualizations

To write DAX formulas

To schedule data refreshes

9. Which of the following is a feature of Power BI Mobile?

Access to reports and dashboards on mobile devices

Developing mobile applications

Creating data models

Writing DAX formulas

10. Which of the following is a feature of Power BI Desktop?

Data modeling and transformation

Developing mobile applications

Creating presentations

Writing SQL queries

11. Which of the following is a feature of Power BI Service?

Sharing and collaboration

Developing mobile applications

Creating presentations

Writing SQL queries

12. Which of the following is used to create relationships between tables in Power BI?

Manage Relationships

Data Gateway

Power Query

DAX

13. What is the purpose of the Power BI Gateway?

To connect on-premises data sources to Power BI

To create visualizations

To write DAX formulas

To schedule data refreshes

14. Which of the following is used to create calculated columns and measures in Power BI?

DAX (Data Analysis Expressions)

M Language

SQL

R

15. In Power BI, what is the primary difference between DirectQuery and Import mode?

DirectQuery allows data storage in Power BI, while Import retrieves live data.

Import mode supports real-time dashboards, while DirectQuery does not.

Import mode stores data in Power BI, while DirectQuery queries the data source directly.

Both modes store data locally but use different refresh rates.

16. What is the function of the CALCULATE function in DAX?

Perform aggregation without modifying filters

Filter a table but cannot modify values

Modify or override filter context in calculations

Display related data from another table

17. Which DAX function can be used to calculate the cumulative total of a column?

SUMMARIZE

TOTALYTD

RANKX

CALCULATE

18. In Power BI, what happens when you join two tables using a many-to-many relationship?

The data model ignores duplicate records in both tables.

The data model creates an intermediary table to manage the relationship.

Filters applied to one table will not affect the other table.

Both tables are treated as one table with shared columns.

19. What does the "Expand/Collapse All" feature in Power BI allow you to do?

Expand or collapse visuals across all report pages.

Expand or collapse all fields in a matrix or table visual.

Expand or collapse relationships between datasets.

Expand or collapse all bookmarks in a report.