Question 1
What is Power BI?
A data visualization tool
A data modeling tool
A data transformation tool
All of the above
Question 2
Which of the following is the default file format for Power BI Desktop files?
.xlsx
.pbi
.pbix
.csv
Question 3
Which of the following data sources Power BI cannot connect to?
Excel
SQL Server
CSV files
Paper Documents
Question 4
What is Power Query in Power BI?
A tool for creating visualizations
A tool for modeling data
A data connection and transformation tool
A tool for sharing reports
Question 5
Which type of visualization is best for showing trends over time?
Pie chart
Line chart
Bar chart
Scatter plot
Question 6
What type of chart is displayed below?

Line chart
Clustered Bar Chart
Column Chart
Stacked Bar Chart
Question 7
What type of chart is displayed below?

Stacked Column Chart
Scatter plot
Combo Chart
Clustered column chart
Question 8
Which M Language function is used to remove duplicates from a table in Power Query?
Table.Distinct
Table.Remove
Table.Clean
Table.Filter
Question 9
What is the primary purpose of the Unpivot Columns feature in Power Query Editor?
To combine multiple columns into one
To transform columns into rows
To aggregate data
To filter data
Question 10
Which feature in Power Query Editor allows you to combine multiple queries into one?
Merge Queries
Group By
Group By
Append Queries
There are 30 questions to complete.