Question 1

1. What is the main function of Power BI?

Accepted Answer

Data visualization and analysis

Answer

Spreadsheet management

Answer

Project management

Answer

Email automation

Question 2

2. Which file format is used to save Power BI Desktop projects?

Accepted Answer

.pbix

Answer

.docx

Answer

.xlsx

Answer

.pptx

Question 3

3. What is DAX in Power BI?

Accepted Answer

Data Analysis Expressions

Answer

Digital Asset Exchange

Answer

Detailed Analysis XML

Answer

Data Annotation Xtreme

Question 4

4. How do you import data into Power BI?

Accepted Answer

Get Data menu

Answer

File > Open

Answer

Import Data button

Answer

Data > New Query

Question 5

5. Which of the following is NOT a data source for Power BI?

Accepted Answer

Adobe Photoshop

Answer

Excel

Answer

Web

Answer

SQL Server

Question 6

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

Accepted Answer

To transform data

Answer

To create charts

Answer

To manage user access

Answer

To write reports

Question 7

7. What is a measure in Power BI?

Accepted Answer

A calculation used in reports

Answer

A data storage method

Answer

A data type

Answer

A visualization type

Question 8

8. How can you publish reports in Power BI?

Accepted Answer

By using the Publish button

Answer

By emailing as attachment

Answer

By printing

Answer

By saving as PDF

Question 9

9. What does a slicer do in Power BI?

Accepted Answer

Filters data in a report

Answer

Integrates data from multiple sources

Answer

Cuts data off the report

Answer

Slices data into smaller tables

Question 10

10. Which visualization allows you to see data over time?

Accepted Answer

Line chart

Answer

Donut chart

Answer

Scatter chart

Answer

Pie chart

Question 11

11. What type of relationship can you define in Power BI?

Accepted Answer

One-to-one, one-to-many, many-to-many

Answer

Many-to-many only

Answer

One-to-one only

Answer

None of the above

Question 12

12. In DAX, what function is used for looking up a value in a related table?

Accepted Answer

RELATED()

Answer

LOOKUP()

Answer

GETRELATED()

Answer

FINDVALUE()

Question 13

13. What layer in Power BI allows you to set data security?

Accepted Answer

Model layer

Answer

Visualization layer

Answer

Report layer

Answer

Data access layer

Question 14

14. How would you best describe a Power BI dashboard?

Accepted Answer

A single page visualization

Answer

An Excel spreadsheet

Answer

A data model

Answer

A multi-page report

Question 15

15. What component in Power BI assists with cleaning and preparing data?

Accepted Answer

Power Query Editor

Answer

Power Map

Answer

Power Apps

Answer

Power Automate

Question 16

16. What is the maximum number of data points for a Power BI scatter chart by default?

Accepted Answer

10000

Answer

50000

Answer

1000

Answer

5000

Question 17

17. Which Power BI component provides AI capabilities?

Accepted Answer

AI visuals

Answer

Standard visuals

Answer

Basic visuals

Answer

Custom visuals

Question 18

18. What is a common use of parameters in Power BI?

Accepted Answer

To dynamically control data inputs

Answer

To set page layouts

Answer

To manage user permissions

Answer

To change visualization colors

Question 19

19. What kind of data model is recommended for large datasets in Power BI?

Accepted Answer

Star schema

Answer

Triangle schema

Answer

Linear schema

Answer

Circular schema

Question 20

20. In Power BI, what is the use of the 'Drillthrough' feature?

Accepted Answer

To explore detailed data about a particular item

Answer

To add annotations to data

Answer

To remove data from the report

Answer

To link different reports

Related quizzes

Related quizzes