 Which of the following is not a Power BI component?

 A) Power Query
 B) Power Pivot
 C) Power Apps
 D) Power View
 Answer: C) Power Apps

 Which language is primarily used for querying in Power BI?

 A) SQL
 B) M Language
 C) DAX
 D) Python
 Answer: C) DAX

 What is the primary function of Power Query?

 A) Data modeling
 B) Data import and transformation
 C) Data visualization
 D) Data storage
 Answer: B) Data import and transformation

 Which Power BI component is used for creating relationships between tables?

 A) Power Query
 B) Power View
 C) Data Model
 D) Query Editor
 Answer: C) Data Model

 What is the use of the Power BI service?

 A) To create data models

 B) To transform data
 C) To share and collaborate on reports
 D) To write DAX queries
 Answer: C) To share and collaborate on reports

 How can you refresh data in Power BI Desktop?

 A) Automatically every hour

 B) Using manual refresh
 C) Using scheduled refresh
 D) It cannot be refreshed
 Answer: B) Using manual refresh

 Which feature allows you to automate data refresh in Power BI Service?

1
  A) Manual refresh
 B) Data gateway
 C) Scheduled refresh
 D) DAX queries
 Answer: C) Scheduled refresh

 Which visual would be best for showing proportions of a whole?

 A) Line chart
 B) Bar chart
 C) Pie chart
 D) Scatter plot
 Answer: C) Pie chart

 What does DAX stand for?

 A) Data Analysis Expressions

 B) Data Aggregate Expressions
 C) Data Analytical Extensions
 D) Data Attribute Expressions
 Answer: A) Data Analysis Expressions

 Which Power BI feature allows for real-time data visualization?

 A) Power Query
 B) Streaming datasets
 C) Power View
 D) Dataflows
 Answer: B) Streaming datasets

 What is the purpose of the Power BI mobile app?

 A) To create dashboards
 B) To visualize data on mobile devices
 C) To import data
 D) To write DAX queries
 Answer: B) To visualize data on mobile devices

 Which of the following is not a data source supported by Power BI?

 A) SQL Server
 B) Oracle Database
 C) Microsoft Word
 D) Excel
 Answer: C) Microsoft Word

 What is the role of the Power BI Desktop?

 A) To share reports
 B) To create and publish reports

2
  C) To visualize data on mobile devices
 D) To manage dataflows
 Answer: B) To create and publish reports

 Which feature in Power BI allows users to drill down into data?

 A) Power Query
 B) Hierarchies
 C) Power Pivot
 D) Dataflows
 Answer: B) Hierarchies

 What is Power BI Gateway used for?

 A) To refresh data in Power BI Desktop

 B) To connect on-premises data sources with Power BI Service
 C) To write DAX queries
 D) To visualize data on mobile devices
 Answer: B) To connect on-premises data sources with Power BI Service

 Which visual is best for showing trends over time?

 A) Bar chart
 B) Pie chart
 C) Line chart
 D) Tree map
 Answer: C) Line chart

 What does a slicer in Power BI do?

 A) Filters data in reports

 B) Connects to data sources
 C) Models data
 D) Refreshes data
 Answer: A) Filters data in reports

 Which Power BI component is used to combine data from multiple sources?

 A) Power Query
 B) Power View
 C) Power Pivot
 D) Dataflows
 Answer: A) Power Query

 What type of chart is used to show the relationship between two numerical values?

 A) Pie chart
 B) Line chart
 C) Scatter plot
 D) Bar chart

3
  Answer: C) Scatter plot

 Which feature in Power BI helps to automatically detect relationships between

tables?

 A) Power Query
 B) Power Pivot
 C) Auto-relationship detection
 D) Data Model
 Answer: C) Auto-relationship detection

 What is the purpose of a dashboard in Power BI?

 A) To model data
 B) To visualize and interact with data
 C) To import data
 D) To refresh data
 Answer: B) To visualize and interact with data

 Which of the following can be used to apply row-level security in Power BI?

 A) Power Query
 B) DAX
 C) Power BI Service
 D) Power BI Desktop
 Answer: D) Power BI Desktop

 What is the use of the Power BI Report Server?

 A) To model data
 B) To visualize data on mobile devices
 C) To host and manage Power BI reports on-premises
 D) To refresh data
 Answer: C) To host and manage Power BI reports on-premises

 Which visual is used to display a single value that represents a KPI?

 A) Line chart
 B) Card
 C) Bar chart
 D) Table
 Answer: B) Card

 How can you publish a report from Power BI Desktop to Power BI Service?

 A) Export to PDF
 B) Save as a .pbix file
 C) Use the Publish button
 D) Export to Excel
 Answer: C) Use the Publish button

4
 What is a DAX measure in Power BI?

 A) A static value in a table

 B) A dynamic aggregation or calculation
 C) A column that stores data
 D) A visualization
 Answer: B) A dynamic aggregation or calculation

 Which type of chart is used to display hierarchical data in a tree structure?

 A) Line chart
 B) Pie chart
 C) Tree map
 D) Scatter plot
 Answer: C) Tree map

 What is the purpose of the Power BI Q&A feature?

 A) To create data models

 B) To transform data
 C) To allow users to ask natural language questions
 D) To write DAX queries
 Answer: C) To allow users to ask natural language questions

 Which of the following is a feature of Power BI Desktop but not Power BI Service?

 A) Creating reports
 B) Sharing dashboards
 C) Data modeling
 D) Viewing reports on mobile devices
 Answer: C) Data modeling

 What is the use of a calculated column in Power BI?

 A) To create a new table

 B) To perform calculations on existing columns
 C) To refresh data
 D) To share reports
 Answer: B) To perform calculations on existing columns

 Which Power BI feature allows for the customization of visual interactions in

reports?

 A) Power Query
 B) Edit Interactions
 C) Power Pivot
 D) Data Model
 Answer: B) Edit Interactions

 What is the purpose of the Power BI Marketplace?

5
  A) To buy and sell Power BI reports
 B) To publish Power BI dashboards
 C) To discover and use custom visuals
 D) To model data
 Answer: C) To discover and use custom visuals

 Which feature in Power BI allows for the scheduling of data refreshes?

 A) Power Query
 B) Dataflows
 C) Scheduled refresh
 D) Q&A
 Answer: C) Scheduled refresh

 What type of data source can be connected to Power BI using DirectQuery?

 A) Excel files
 B) CSV files
 C) SQL databases
 D) JSON files
 Answer: C) SQL databases

 Which visual is used to compare values across categories?

 A) Line chart
 B) Bar chart
 C) Pie chart
 D) Scatter plot
 Answer: B) Bar chart

 What is the purpose of a Power BI dataflow?

 A) To create visualizations
 B) To transform and prepare data
 C) To publish reports
 D) To schedule refreshes
 Answer: B) To transform and prepare data

 Which DAX function is used to calculate the total of a column?

 A) SUM
 B) AVERAGE
 C) COUNT
 D) MIN
 Answer: A) SUM

 Which Power BI feature allows users to collaborate on reports and dashboards?

 A) Power Query
 B) Power BI Service

6
  C) Power Pivot
 D) Data Model
 Answer: B) Power BI Service

 What is a Power BI workspace?

 A) A place to create data models

 B) A collaborative environment for reports and dashboards
 C) A visualization tool
 D) A data source
 Answer: B) A collaborative environment for reports and dashboards

 What type of chart is used to show part-to-whole relationships?

 A) Line chart
 B) Bar chart
 C) Pie chart
 D) Scatter plot
 Answer: C) Pie chart

 Which of the following is used to create a new column in Power Query?

 A) DAX
 B) M Language
 C) SQL
 D) Python
 Answer: B) M Language

 What is the purpose of the Power BI data gateway?

 A) To import data
 B) To refresh data
 C) To connect on-premises data sources with Power BI Service
 D) To create data models
 Answer: C) To connect on-premises data sources with Power BI Service

 Which feature allows for real-time updates in Power BI dashboards?

 A) Manual refresh
 B) Scheduled refresh
 C) Streaming datasets
 D) Dataflows
 Answer: C) Streaming datasets

 Which of the following can be used to create custom visuals in Power BI?

 A) SQL
 B) DAX
 C) R and Python
 D) M Language

7
  Answer: C) R and Python

 What is the purpose of the Power BI Report Server?

 A) To create reports
 B) To publish reports on-premises
 C) To visualize data on mobile devices
 D) To refresh data
 Answer: B) To publish reports on-premises

 Which Power BI feature allows for the use of natural language queries?

 A) DAX
 B) Power Query
 C) Q&A
 D) Dataflows
 Answer: C) Q&A

 Which visual would be best for showing a comparison of performance against a

target?

 A) Line chart
 B) Bar chart
 C) KPI visual
 D) Table
 Answer: C) KPI visual

 What is the purpose of a Power BI template?

 A) To create data models

 B) To share standardized reports
 C) To refresh data
 D) To model data
 Answer: B) To share standardized reports

 Which feature allows users to export Power BI reports to other formats?

 A) Publish
 B) Export
 C) Dataflows
 D) Edit Interactions
 Answer: B) Export

 What type of chart is used to display correlations between two variables?

 A) Line chart
 B) Bar chart
 C) Pie chart
 D) Scatter plot
 Answer: D) Scatter plot

8
 Which DAX function is used to calculate the average of a column?

 A) SUM
 B) AVERAGE
 C) COUNT
 D) MIN
 Answer: B) AVERAGE

 What is the use of the Power BI Data Model?

 A) To visualize data
 B) To import and transform data
 C) To create relationships between tables
 D) To refresh data
 Answer: C) To create relationships between tables

 Which visual is best for showing data distributions?

 A) Line chart
 B) Histogram
 C) Pie chart
 D) Bar chart
 Answer: B) Histogram

 What is the purpose of Power BI bookmarks?

 A) To import data
 B) To create data models
 C) To save report states
 D) To refresh data
 Answer: C) To save report states

 Which feature in Power BI allows for automated machine learning?

 A) Power Query
 B) Power BI Service
 C) Dataflows
 D) AI Insights
 Answer: D) AI Insights

 What is a custom visual in Power BI?

 A) A standard visual provided by Power BI

 B) A visual created by the user or a third party
 C) A data model
 D) A data source
 Answer: B) A visual created by the user or a third party

 Which feature allows users to interact with Power BI reports on mobile devices?

9
  A) Power Query
 B) Power BI Desktop
 C) Power BI Mobile App
 D) Power Pivot
 Answer: C) Power BI Mobile App

 What type of chart is used to show the progress towards a goal?

 A) Line chart
 B) Bar chart
 C) Gauge chart
 D) Pie chart
 Answer: C) Gauge chart

 Which of the following is a benefit of using Power BI Service?

 A) Data modeling
 B) Data transformation
 C) Collaboration and sharing
 D) Writing DAX queries
 Answer: C) Collaboration and sharing

 Which Power BI feature allows for the integration of R and Python scripts?

 A) Dataflows
 B) Power Query
 C) Custom visuals
 D) DAX
 Answer: B) Power Query

 Which DAX function is used to count the number of rows in a table?

 A) SUM
 B) COUNT
 C) AVERAGE
 D) MIN
 Answer: B) COUNT

 What is the purpose of the Power BI community?

 A) To create data models

 B) To import data
 C) To share knowledge and support
 D) To visualize data
 Answer: C) To share knowledge and support

 Which feature in Power BI allows for creating interactive reports?

 A) Dataflows
 B) Power Query

10
  C) Power BI Desktop
 D) DAX
 Answer: C) Power BI Desktop

 What is the purpose of Power BI paginated reports?

 A) To visualize data in a summarized format

 B) To create detailed, print-ready reports
 C) To model data
 D) To transform data
 Answer: B) To create detailed, print-ready reports

 Which feature allows users to set alerts for specific data points in Power BI?

 A) Dataflows
 B) Power Query
 C) Data Alerts
 D) DAX
 Answer: C) Data Alerts

 What is the purpose of Power BI tiles?

 A) To create data models

 B) To visualize and pin report elements to a dashboard
 C) To refresh data
 D) To import data
 Answer: B) To visualize and pin report elements to a dashboard

 Which Power BI feature allows for grouping and binning data?

 A) Power Query
 B) DAX
 C) Data Model
 D) Report View
 Answer: C) Data Model

 What type of chart is used to show data over time?

 A) Pie chart
 B) Bar chart
 C) Line chart
 D) Scatter plot
 Answer: C) Line chart

 Which feature allows users to write custom DAX expressions in Power BI?

 A) Power Query
 B) Power BI Service
 C) Power BI Desktop
 D) Dataflows

11
  Answer: C) Power BI Desktop

 What is the purpose of the Power BI Data Catalog?

 A) To create data models

 B) To share and manage data assets
 C) To visualize data
 D) To refresh data
 Answer: B) To share and manage data assets

 Which feature in Power BI allows for data segmentation?

 A) Power Query
 B) Slicers
 C) Dataflows
 D) Q&A
 Answer: B) Slicers

 What is the purpose of the Power BI data model view?

 A) To transform data
 B) To create and manage relationships between tables
 C) To visualize data
 D) To refresh data
 Answer: B) To create and manage relationships between tables

 Which feature in Power BI allows users to annotate and share insights?

 A) Power Query
 B) Dataflows
 C) Comments
 D) DAX
 Answer: C) Comments

 What type of visual is used to display key metrics in a summarized format?

 A) Line chart
 B) Card
 C) Bar chart
 D) Table
 Answer: B) Card

 Which feature allows for the combination of multiple visuals into a single view in
Power BI?

 A) Dataflows
 B) Power Query
 C) Reports
 D) Dashboard
 Answer: D) Dashboard

12
Which DAX function is used to remove filters from a column or table?

A) REMOVEFILTERS
B) CLEARFILTER
C) DELETEFILTER
D) FILTER
Answer: A) REMOVEFILTERS
What is the purpose of the Power BI "Quick Insights" feature?

A) To manually create data insights

B) To automatically generate insights from data
C) To refresh data
D) To create data models
Answer: B) To automatically generate insights from data
Which feature allows users to combine multiple queries into a single
query in Power BI?

A) Dataflows
B) Append Queries
C) Merge Queries
D) Power Query
Answer: B) Append Queries
What is the purpose of the Power BI "Field Parameters" feature?

A) To add new columns to a table

B) To define dynamic measures and dimensions
C) To create relationships between tables
D) To transform data
Answer: B) To define dynamic measures and dimensions
Which feature in Power BI allows users to customize tooltips for
visualizations?

A) Power Query

13
B) Custom Tooltips
C) Dataflows
D) DAX
Answer: B) Custom Tooltips
What is the purpose of the Power BI "Q&A Explorer" visual?

A) To create custom visuals

B) To visualize data using natural language queries
C) To refresh data
D) To write DAX queries
Answer: B) To visualize data using natural language queries
Which of the following can be used to format numbers and dates in
Power BI?

A) DAX
B) Power Query
C) Dataflows
D) Modeling Tab
Answer: D) Modeling Tab
What is the purpose of the Power BI "Bookmarks" feature?

A) To save data transformations

B) To save specific report states and filter configurations
C) To refresh data
D) To import data
Answer: B) To save specific report states and filter configurations
Which DAX function is used to return a table with a subset of columns
from another table?

A) SELECTCOLUMNS
B) FILTER
C) ADDCOLUMNS
D) VALUES

14
Answer: A) SELECTCOLUMNS
Which Power BI feature allows for creating dynamic titles in visuals?

A) DAX
B) Dataflows
C) Power Query
D) Expressions
Answer: D) Expressions
What is the purpose of the Power BI "Analyze in Excel" feature?

A) To export data to Excel for further analysis

B) To import Excel data into Power BI
C) To create Excel-like visuals in Power BI
D) To refresh data
Answer: A) To export data to Excel for further analysis
Which feature allows users to control the access and permissions for
reports in Power BI?

A) Power Query
B) Power BI Service
C) Dataflows
D) Security Tab
Answer: B) Power BI Service
Which DAX function is used to calculate the cumulative total?

A) CUMULATIVETOTAL
B) SUMX
C) RUNNINGTOTAL
D) TOTALYTD
Answer: D) TOTALYTD
Which Power BI feature allows for integration with Microsoft Teams?

15
A) Power Query
B) Power BI Service
C) Dataflows
D) Power BI App
Answer: D) Power BI App
What is the purpose of the Power BI "Drillthrough" feature?

A) To create new columns

B) To allow users to navigate to detailed report pages
C) To refresh data
D) To import data
Answer: B) To allow users to navigate to detailed report pages
Which of the following can be used to create calculated tables in Power
BI?

A) DAX
B) Power Query
C) Dataflows
D) Modeling Tab
Answer: A) DAX
What is the purpose of the Power BI "Aggregation" feature?

A) To transform data
B) To model data
C) To optimize performance by pre-aggregating data
D) To refresh data
Answer: C) To optimize performance by pre-aggregating data
Which Power BI feature allows for creating custom shapes and
backgrounds in reports?

A) Power Query
B) Dataflows
C) Power BI Service

16
D) Shape Map Visual
Answer: D) Shape Map Visual
Which DAX function is used to calculate the distinct count of values in a
column?

A) COUNT
B) COUNTROWS
C) DISTINCTCOUNT
D) SUM
Answer: C) DISTINCTCOUNT
What is the purpose of the Power BI "Power Automate" visual?

A) To automate data refreshes

B) To create and trigger workflows directly from Power BI reports
C) To import data
D) To model data
Answer: B) To create and trigger workflows directly from Power BI reports
Which feature allows users to create and share data stories in Power
BI?

A) Power Query
B) Dataflows
C) Power BI Service
D) Data Stories Gallery
Answer: D) Data Stories Gallery
Which of the following can be used to perform data profiling in Power
BI?

A) Power Query
B) DAX
C) Dataflows
D) Power BI Service
Answer: A) Power Query

17
What is the purpose of the Power BI "AI Insights" feature?

A) To create visualizations
B) To apply machine learning models to data
C) To refresh data
D) To import data
Answer: B) To apply machine learning models to data
Which visual is used to show key performance indicators in Power BI?

A) Line chart
B) Bar chart
C) KPI visual
D) Table
Answer: C) KPI visual
What is the purpose of the Power BI "Decomposition Tree" visual?
- A) To show hierarchical data
- B) To break down a measure into its contributing factors
- C) To visualize data over time
- D) To compare values across categories
- Answer: B) To break down a measure into its contributing factors

Which feature in Power BI allows for creating what-if scenarios?

- A) Dataflows
- B) Power Query
- C) Parameters
- D) DAX
- Answer: C) Parameters

What is the purpose of the Power BI "Line and Clustered Column Chart"
visual?
- A) To compare two measures with different scales
- B) To show data over time

18
- C) To display correlations between two variables
- D) To visualize hierarchical data
- Answer: A) To compare two measures with different scales

Which DAX function is used to create a new table from a specific set of
columns?
- A) ADDCOLUMNS
- B) SELECTCOLUMNS
- C) CALCULATETABLE
- D) FILTER
- Answer: B) SELECTCOLUMNS

What is the purpose of the Power BI "Tooltip Report Page" feature?

- A) To create detailed tooltips using report pages
- B) To model data
- C) To transform data
- D) To refresh data
- Answer: A) To create detailed tooltips using report pages

Which feature allows users to create and share custom themes in Power
BI?
- A) Power Query
- B) Dataflows
- C) Theme Gallery
- D) DAX
- Answer: C) Theme Gallery

Which Power BI visual allows for the display of geographical data?

- A) Pie chart
- B) Bar chart
- C) Map Visual
- D) Line chart
- Answer: C) Map Visual

19
What is the purpose of the Power BI "Drillthrough" feature?
- A) To create new columns
- B) To allow users to navigate to detailed report pages
- C) To refresh data
- D) To import data
- Answer: B) To allow users to navigate to detailed report pages

Which DAX function is used to calculate a running total?

- A) CUMULATIVETOTAL
- B) SUMX
- C) RUNNINGTOTAL
- D) TOTALMTD
- Answer: D) TOTALMTD

Which Power BI feature allows for integration with Microsoft Teams?

- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Power BI App
- Answer: D) Power BI App

What is the purpose of the Power BI "Drillthrough" feature?

- A) To create new columns
- B) To allow users to navigate to detailed report pages
- C) To refresh data
- D) To import data
- Answer: B) To allow users to navigate to detailed report pages

Which feature allows users to control the access and permissions for
reports in Power BI?
- A) Power Query

20
- B) Power BI Service
- C) Dataflows
- D) Security Tab
- Answer: B) Power BI Service

Which DAX function is used to return a specific value when the result is
empty?
- A) IF
- B) ISBLANK
- C) COALESCE
- D) BLANK
- Answer: C) COALESCE

What is the purpose of the Power BI "Drillthrough" feature?

- A) To create new columns
- B) To allow users to navigate to detailed report pages
- C) To refresh data
- D) To import data
- Answer: B) To allow users to navigate to detailed report pages

Which DAX function is used to filter a table based on a condition?

- A) CALCULATE
- B) FILTER
- C) SELECTCOLUMNS
- D) ADDCOLUMNS
- Answer: B) FILTER

What is the purpose of the Power BI "Line and Stacked Column Chart"
visual?
- A) To show trends over time
- B) To compare two measures with different scales
- C) To display correlations between two variables
- D) To visualize hierarchical data

21
- Answer: B) To compare two measures with different scales

Which Power BI feature allows for creating custom visuals?

- A) Power Query
- B) Dataflows
- C) Custom Visuals SDK
- D) DAX
- Answer: C) Custom Visuals SDK

Which feature in Power BI allows for creating and sharing reports with
specific users?
- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Sharing Tab
- Answer: B) Power BI Service

Which DAX function is used to calculate the difference between two

dates?
- A) DATEDIFF
- B) DATEADD
- C) CALENDAR
- D) TODAY
- Answer: A) DATEDIFF

What is the purpose of the Power BI "Forecasting" feature?

- A) To model data
- B) To predict future trends based on historical data
- C) To transform data
- D) To refresh data
- Answer: B) To predict future trends based on historical data

Which Power BI visual is used to show a distribution of data?

22
- A) Histogram
- B) Bar chart
- C) Line chart
- D) Pie chart
- Answer: A) Histogram

Which feature in Power BI allows users to analyze data using statistical

functions?
- A) Dataflows
- B) Power Query
- C) R and Python integration
- D) DAX
- Answer: C) R and Python integration

What is the purpose of the Power BI "Group By" feature in Power

Query?
- A) To create relationships between tables
- B) To aggregate data based on specific columns
- C) To visualize data
- D) To refresh data
- Answer: B) To aggregate data based on specific columns

Which DAX function is used to calculate the rank of a value in a column?

- A) RANKX
- B) RANK
- C) ROW_NUMBER
- D) [Link]
- Answer: A) RANKX

Which Power BI feature allows for creating interactive dashboards?

- A) Power Query
- B) Dataflows
- C) Dashboards

23
- D) DAX
- Answer: C) Dashboards

What is the purpose of the Power BI "Conditional Formatting" feature?

- A) To format data based on specific conditions
- B) To import data
- C) To refresh data
- D) To create data models
- Answer: A) To format data based on specific conditions

Which visual in Power BI is used to compare values across multiple

categories?
- A) Bar chart
- B) Line chart
- C) Pie chart
- D) Treemap
- Answer: D) Treemap

What is the purpose of the Power BI "Q&A" feature?

- A) To create data models
- B) To write DAX queries
- C) To ask natural language questions about data
- D) To refresh data
- Answer: C) To ask natural language questions about data

Which DAX function is used to calculate the sum of a column?

- A) SUMX
- B) SUM
- C) COUNT
- D) AVERAGE
- Answer: B) SUM

24
Which Power BI feature allows users to view reports on mobile devices?
- A) Power Query
- B) Power BI Service
- C) Power BI Mobile App
- D) Dataflows
- Answer: C) Power BI Mobile App

What is the purpose of the Power BI "Slicers" feature?

- A) To create new columns
- B) To filter data in a report
- C) To refresh data
- D) To import data
- Answer: B) To filter data in a report

Which visual in Power BI is best for showing relationships between data

points?
- A) Line chart
- B) Bar chart
- C) Scatter plot
- D) Pie chart
- Answer: C) Scatter plot

Which DAX function is used to return the last date in a column?

- A) LASTDATE
- B) MAX
- C) ENDDATE
- D) TODAY
- Answer: A) LASTDATE

What is the purpose of the Power BI "Field Parameters" feature?

- A) To add new columns to a table
- B) To define dynamic measures and dimensions

25
- C) To create relationships between tables
- D) To transform data
- Answer: B) To define dynamic measures and dimensions

Which feature in Power BI allows for creating interactive maps?

- A) Dataflows
- B) Power Query
- C) Map Visual
- D) DAX
- Answer: C) Map Visual

Which DAX function is used to return a value if a condition is true, and

another value if it is false?
- A) IF
- B) SWITCH
- C) COALESCE
- D) CHOOSE
- Answer: A) IF

What is the purpose of the Power BI "Quick Measures" feature?

- A) To create complex DAX expressions
- B) To create simple calculations without writing DAX
- C) To model data
- D) To transform data
- Answer: B) To create simple calculations without writing DAX

Which feature allows users to create data alerts in Power BI?

- A) Power Query
- B) Dataflows
- C) Data Alerts
- D) DAX
- Answer: C) Data Alerts

26
What is the purpose of the Power BI "Line and Clustered Column Chart"
visual?
- A) To compare two measures with different scales
- B) To show data over time
- C) To display correlations between two variables
- D) To visualize hierarchical data
- Answer: A) To compare two measures with different scales

Which DAX function is used to return the year from a date column?
- A) YEAR
- B) DATEPART
- C) YEARFRAC
- D) YEAROF
- Answer: A) YEAR

Which feature in Power BI allows users to explore data using a

conversational interface?
- A) Power Query
- B) Dataflows
- C) Q&A
- D) DAX
- Answer: C) Q&A

Which DAX function is used to count the number of rows in a table?

- A) COUNT
- B) COUNTROWS
- C) COUNTX
- D) SUM
- Answer: B) COUNTROWS

What is the purpose of the Power BI "Themes" feature?

- A) To create custom visuals

27
- B) To apply consistent formatting and color schemes across reports
- C) To refresh data
- D) To import data
- Answer: B) To apply consistent formatting and color schemes across reports

Which feature allows users to create and share dashboards in Power BI?
- A) Power Query
- B) Dataflows
- C) Power BI Service
- D) DAX
- Answer: C) Power BI Service

Which DAX function is used to return the minimum value in a column?

- A) MINX
- B) MIN
- C) MINIMUM
- D) LEAST
- Answer: B) MIN

Which Power BI feature allows for creating data alerts?

- A) Power Query
- B) Dataflows
- C) Power BI Service
- D) Data Alerts
- Answer: D) Data Alerts

What is the purpose of the Power BI "Parameters" feature?

- A) To create dynamic measures and dimensions
- B) To model data
- C) To transform data
- D) To refresh data
- Answer: A) To create dynamic measures and dimensions

28
Which DAX function is used to calculate the average of a column?
- A) AVERAGEX
- B) AVERAGE
- C) AVG
- D) MEAN
- Answer: B) AVERAGE

What is the purpose of the Power BI "Trend Line" feature?

- A) To show data over time
- B) To visualize trends and patterns in data
- C) To compare values across categories
- D) To create new columns
- Answer: B) To visualize trends and patterns in data

Which visual in Power BI is used to display hierarchical data?

- A) Line chart
- B) Bar chart
- C) Treemap
- D) Scatter plot
- Answer: C) Treemap

Which feature in Power BI allows users to create custom columns using

DAX?
- A) Power Query
- B) Dataflows
- C) Calculated Columns
- D) DAX Editor
- Answer: C) Calculated Columns

What is the purpose of the Power BI "Forecasting" feature?

- A) To model data

29
- B) To predict future trends based on historical data
- C) To transform data
- D) To refresh data
- Answer: B) To predict future trends based on historical data

Which visual in Power BI is best for showing part-to-whole

relationships?
- A) Pie chart
- B) Line chart
- C) Bar chart
- D) Scatter plot
- Answer: A) Pie chart

Which feature in Power BI allows for creating dynamic titles in visuals?

- A) DAX
- B) Dataflows
- C) Power Query
- D) Expressions
- Answer: D) Expressions

What is the purpose of the Power BI "Line and Stacked Column Chart"
visual?
- A) To compare two measures with different scales
- B) To show data over time
- C) To display correlations between two variables
- D) To visualize hierarchical data
- Answer: A) To compare two measures with different scales

Which feature allows users to control the access and permissions for
reports in Power BI?
- A) Power Query
- B) Power BI Service
- C) Dataflows

30
- D) Security Tab
- Answer: B) Power BI Service

Which DAX function is used to calculate a rolling average?

- A) ROLLINGAVERAGE
- B) AVERAGEX
- C) MOVINGAVERAGE
- D) MEAN
- Answer: B) AVERAGEX

Which Power BI feature allows for creating and sharing custom themes?
- A) Power Query
- B) Dataflows
- C) Theme Gallery
- D) DAX
- Answer: C) Theme Gallery

What is the purpose of the Power BI "Q&A Explorer" visual?

- A) To create custom visuals
- B) To visualize data using natural language queries
- C) To refresh data
- D) To write DAX queries
- Answer: B) To visualize data using natural language queries

Which visual is used to display key metrics in a summarized format?

- A) Line chart
- B) Card
- C) Bar chart
- D) Table
- Answer: B) Card

What is the purpose of the Power BI "Aggregation" feature?

31
- A) To transform data
- B) To model data
- C) To optimize performance by pre-aggregating data
- D) To refresh data
- Answer: C) To optimize performance by pre-aggregating data

Which feature in Power BI allows users to annotate and share insights?

- A) Power Query
- B) Dataflows
- C) Comments
- D) DAX
- Answer: C) Comments

Which DAX function is used to calculate the cumulative total?

- A) CUMULATIVETOTAL
- B) SUMX
- C) RUNNINGTOTAL
- D) TOTALYTD
- Answer: D) TOTALYTD

Which Power BI visual is used to show a distribution of data?

- A) Histogram
- B) Bar chart
- C) Line chart
- D) Pie chart
- Answer: A) Histogram

What is the purpose of the Power BI "Dataflows" feature?

- A) To transform data
- B) To create and manage data preparation processes
- C) To visualize data
- D) To refresh data

32
- Answer: B) To create and manage data preparation processes

Which feature in Power BI allows for creating what-if scenarios?

- A) Dataflows
- B) Power Query
- C) Parameters
- D) DAX
- Answer: C) Parameters

Which DAX function is used to return the first date in a column?

- A) FIRSTDATE
- B) MIN
- C) STARTDATE
- D) TODAY
- Answer: A) FIRSTDATE

Which feature in Power BI allows for creating interactive maps?

- A) Dataflows
- B) Power Query
- C) Map Visual
- D) DAX
- Answer: C) Map Visual

What is the purpose of the Power BI "Quick Measures" feature?

- A) To create complex DAX expressions
- B) To create simple calculations without writing DAX
- C) To model data
- D) To transform data
- Answer: B) To create simple calculations without writing DAX

Which visual in Power BI is best for showing relationships between data

points?

33
- A) Line chart
- B) Bar chart
- C) Scatter plot
- D) Pie chart
- Answer: C) Scatter plot

Which DAX function is used to calculate the rank of a value in a column?

- A) RANKX
- B) RANK
- C) ROW_NUMBER
- D) [Link]
- Answer: A) RANKX

Which feature in Power BI allows for creating and sharing custom

themes?
- A) Power Query
- B) Dataflows
- C) Theme Gallery
- D) DAX
- Answer: C) Theme Gallery

What is the purpose of the Power BI "Field Parameters" feature?

- A) To add new columns to a table
- B) To define dynamic measures and dimensions
- C) To create relationships between tables
- D) To transform data
- Answer: B) To define dynamic measures and dimensions

Which Power BI visual allows for the display of geographical data?

- A) Pie chart
- B) Bar chart
- C) Line chart

34
- D) Map Visual
- Answer: D) Map Visual

Which DAX function is used to return a specific value when the result is
empty?
- A) IF
- B) ISBLANK
- C) COALESCE
- D) BLANK
- Answer: C) COALESCE

Which feature in Power BI allows for creating interactive maps?

- A) Dataflows
- B) Power Query
- C) Map Visual
- D) DAX
- Answer: C) Map Visual

Which visual in Power BI is used to compare values across multiple

categories?
- A) Bar chart
- B) Line chart
- C) Pie chart
- D) Treemap
- Answer: A) Bar chart

What is the purpose of the Power BI "Grouping" feature?

- A) To create relationships between tables
- B) To visualize data
- C) To group data into categories
- D) To refresh data
- Answer: C) To group data into categories

35
Which feature allows users to control the access and permissions for
reports in Power BI?
- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Security Tab
- Answer: B) Power BI Service

Which DAX function is used to calculate the cumulative total?

- A) CUMULATIVETOTAL
- B) SUMX
- C) RUNNINGTOTAL
- D) TOTALYTD
- Answer: D) TOTALYTD

Which Power BI feature allows for integration with Microsoft Teams?

- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Power BI App
- Answer: D) Power BI App

Which visual in Power BI is used to show a distribution of data?

- A) Histogram
- B) Bar chart
- C) Line chart
- D) Pie chart
- Answer: A) Histogram

What is the purpose of the Power BI "Trend Line" feature?

- A) To show data over time
- B) To visualize trends and patterns in data

36
- C) To compare values across categories
- D) To create new columns
- Answer: B) To visualize trends and patterns in data

Which feature in Power BI allows users to create custom columns using

DAX?
- A) Power Query
- B) Dataflows
- C) Calculated Columns
- D) DAX Editor
- Answer: C) Calculated Columns

Which DAX function is used to calculate the average of a column?

- A) AVERAGEX
- B) AVERAGE
- C) AVG
- D) MEAN
- Answer: B) AVERAGE

Which feature in Power BI allows for creating and sharing dashboards?

- A) Power Query
- B) Dataflows
- C) Dashboards
- D) DAX
- Answer: C) Dashboards

Which visual in Power BI is used to display key metrics in a summarized

format?
- A) Line chart
- B) Card
- C) Bar chart
- D) Table
- Answer: B) Card

37
Which feature allows users to control the access and permissions for
reports in Power BI?
- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Security Tab
- Answer: B) Power BI Service

What is the purpose of the Power BI "Quick Measures" feature?

- A) To create complex DAX expressions
- B) To create simple calculations without writing DAX
- C) To model data
- D) To transform data
- Answer: B) To create simple calculations without writing DAX

Which DAX function is used to return the last date in a column?

- A) LASTDATE
- B) MAX
- C) ENDDATE
- D) TODAY
- Answer: A) LASTDATE

Which feature in Power BI allows users to annotate and share insights?

- A) Power Query
- B) Dataflows
- C) Comments
- D) DAX
- Answer: C) Comments

Which visual in Power BI is used to compare values across multiple

categories?
- A) Bar chart

38
- B) Line chart
- C) Pie chart
- D) Treemap
- Answer: A) Bar chart

What is the purpose of the Power BI "Grouping" feature?

- A) To create relationships between tables
- B) To visualize data
- C) To group data into categories
- D) To refresh data
- Answer: C) To group data into categories

Which feature in Power BI allows for creating what-if scenarios?

- A) Dataflows
- B) Power Query
- C) Parameters
- D) DAX
- Answer: C) Parameters

Which DAX function is used to return a specific value when the result is
empty?
- A) IF
- B) ISBLANK
- C) COALESCE
- D) BLANK
- Answer: C) COALESCE

Which Power BI visual allows for the display of geographical data?

- A) Pie chart
- B) Bar chart
- C) Line chart
- D) Map Visual

39
- Answer: D) Map Visual

Which feature in Power BI allows for creating interactive maps?

- A) Dataflows
- B) Power Query
- C) Map Visual
- D) DAX
- Answer: C) Map Visual

Which DAX function is used to calculate the rank of a value in a column?

- A) RANKX
- B) RANK
- C) ROW_NUMBER
- D) [Link]
- Answer: A) RANKX

Which feature in Power BI allows for creating and sharing dashboards?

- A) Power Query
- B) Dataflows
- C) Dashboards
- D) DAX
- Answer: C) Dashboards

Which visual in Power BI is best for showing relationships between data

points?
- A) Line chart
- B) Bar chart
- C) Scatter plot
- D) Pie chart
- Answer: C) Scatter plot

What is the purpose of the Power BI "Aggregation" feature?

40
- A) To transform data
- B) To model data
- C) To optimize performance by pre-aggregating data
- D) To refresh data
- Answer: C) To optimize performance by pre-aggregating data

Which feature allows users to control the access and permissions for
reports in Power BI?
- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Security Tab
- Answer: B) Power BI Service

Which DAX function is used to calculate a rolling average?

- A) ROLLINGAVERAGE
- B) AVERAGEX
- C) MOVINGAVERAGE
- D) MEAN
- Answer: B) AVERAGEX

Which Power BI feature allows for creating and sharing custom themes?
- A) Power Query
- B) Dataflows
- C) Theme Gallery
- D) DAX
- Answer: C) Theme Gallery

What is the purpose of the Power BI "Q&A Explorer" visual?

- A) To create custom visuals
- B) To visualize data using natural language queries
- C) To refresh data

41
- D) To write DAX queries
- Answer: B) To visualize data using natural language queries

Which visual in Power BI is used to display key metrics in a summarized

format?
- A) Line chart
- B) Card
- C) Bar chart
- D) Table
- Answer: B) Card

What is the purpose of the Power BI "Field Parameters" feature?

- A) To add new columns to a table
- B) To define dynamic measures and dimensions
- C) To create relationships between tables
- D) To transform data
- Answer: B) To define dynamic measures and dimensions

Which feature in Power BI allows for creating interactive maps?

- A) Dataflows
- B) Power Query
- C) Map Visual
- D) DAX
- Answer: C) Map Visual

Which DAX function is used to return the last date in a column?

- A) LASTDATE
- B) MAX
- C) ENDDATE
- D) TODAY
- Answer: A) LASTDATE

42
Which feature in Power BI allows users to annotate and share insights?
- A) Power Query
- B) Dataflows
- C) Comments
- D) DAX
- Answer: C) Comments

Which visual in Power BI is used to compare values across multiple

categories?
- A) Bar chart
- B) Line chart
- C) Pie chart
- D) Treemap
- Answer: A) Bar chart

Which DAX function is used to calculate the cumulative total?

- A) CUMULATIVETOTAL
- B) SUMX
- C) RUNNINGTOTAL
- D) TOTALYTD
- Answer: D) TOTALYTD

Which feature in Power BI allows users to create custom columns using

DAX?
- A) Power Query
- B) Dataflows
- C) Calculated Columns
- D) DAX Editor
- Answer: C) Calculated Columns

Which Power BI visual is used to show a distribution of data?

- A) Histogram
- B) Bar chart

43
- C) Line chart
- D) Pie chart
- Answer: A) Histogram

Which visual in Power BI is best for showing relationships between data

points?
- A) Line chart
- B) Bar chart
- C) Scatter plot
- D) Pie chart
- Answer: C) Scatter plot

Which feature in Power BI allows for creating what-if scenarios?

- A) Dataflows
- B) Power Query
- C) Parameters
- D) DAX
- Answer: C) Parameters

What is the purpose of the Power BI "Grouping" feature?

- A) To create relationships between tables
- B) To visualize data
- C) To group data into categories
- D) To refresh data
- Answer: C) To group data into categories

Which visual in Power BI is used to display key metrics in a summarized

format?
- A) Line chart
- B) Card
- C) Bar chart
- D) Table
- Answer: B) Card

44
Which feature in Power BI allows for creating and sharing custom
themes?
- A) Power Query
- B) Dataflows
- C) Theme Gallery
- D) DAX
- Answer: C) Theme Gallery

What is the purpose of the Power BI "Aggregation" feature?

- A) To transform data
- B) To model data
- C) To optimize performance by pre-aggregating data
- D) To refresh data
- Answer: C) To optimize performance by pre-aggregating data

Which Power BI feature allows for integration with Microsoft Teams?

- A) Power Query
- B) Power BI Service
- C) Dataflows
- D) Power BI App
- **Answer: D) Power BI App

45