Power BI Quiz

What is the DAX function used to calculate the running total of a measure?

• SUMX

• TOTALYTD

• RUNNINGTOTAL

• CUMULATE

What is the purpose of the Power BI Service Gateway?

• To manage dataflows

• To schedule data refresh

• To create custom visuals

• To manage security

How can you create a custom hierarchy in Power BI?

• Using the Hierarchy slicer

• Using the Drillthrough feature

• Using the Manage Relationships dialog

• Using the Manage Hierarchies dialog

What is the maximum number of columns allowed in a Power BI table?

• 256

• 512

• 1024

• Unlimited

What is the purpose of the Power BI Dataflows feature?

• To create custom visuals

• To create calculated columns

• To transform and clean data

• To create custom connectors

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

• To create custom visuals

• To transform and clean data

• To create calculated columns

• To create measures

What is the maximum number of rows allowed in a Power BI dataset?

• 1 million

• 10 million

• 100 million

• Unlimited

What is the difference between calculated columns and measures in Power BI?

• Calculated columns are computed at query time, measures are computed at visualization time

• Calculated columns are computed at visualization time, measures are computed at query time

• Calculated columns are used for filtering, measures are used for sorting

• Calculated columns are used for sorting, measures are used for filtering

How can you create a custom theme in Power BI?

• Using the Theme Gallery

• Editing the JSON file

• Using the Color Picker

• Creating a custom CSS

How can you create a custom connector in Power BI?

• Using the Power Query Editor

• Using the Power BI Service

• Using the Power BI Desktop

• Using the Power BI Gateway