Question 1

What does DAX stand for?

Accepted Answer

Data Analysis Expressions

Answer

Data Application Extensions

Answer

Data Aggregation Expressions

Answer

Data Analytical Extracts

Question 2

In which tools can you write DAX expressions?

Accepted Answer

Power BI Desktop, SQL Server Data Tools, Excel

Answer

Tableau, Power BI Desktop, Notepad

Answer

PowerPoint, Word, Excel

Answer

SQL Server Management Studio, Word, Excel

Question 3

When should you use a calculated column in Power BI?

Accepted Answer

When you need a new data field calculated row-by-row

Answer

When you need to create a new report page

Answer

When you need to aggregate data dynamically

Answer

When you need to filter data interactively

Question 4

Where are calculated columns stored in Power BI?

Accepted Answer

In the data model

Answer

In the report file

Answer

In the Power BI cloud service

Answer

In a separate database

Question 5

What is a measure in Power BI?

Accepted Answer

A dynamic calculation responding to report context

Answer

A type of chart in Power BI

Answer

A fixed data value stored in a table

Answer

A static calculation independent of report context

Question 6

How are measures calculated in Power BI?

Accepted Answer

On-the-fly when queried

Answer

When the Power BI report is exported

Answer

When the Power BI service is refreshed

Answer

When the data model is processed

Question 7

Which DAX function would you use to sum a column of values?

Accepted Answer

SUM

Answer

TOTAL

Answer

ADD

Answer

COMBINE

Question 8

What type of data does DAX work with?

Accepted Answer

Relational data

Answer

Unstructured data

Answer

Graph databases

Answer

Flat files

Question 9

Why is DAX important for Power BI users?

Accepted Answer

It enables custom calculations and data modeling

Answer

It automates data refreshes

Answer

It stores Power BI reports

Answer

It provides templates for reports

Question 10

Which of the following is not a common DAX function?

Accepted Answer

MERGE

Answer

COUNTROWS

Answer

MAX

Answer

AVERAGE

Question 11

How does DAX compare to Excel formulas?

Accepted Answer

DAX is designed for relational data and dynamic aggregations

Answer

DAX can only be used in Power BI

Answer

DAX is primarily for text manipulation

Answer

DAX is easier to use and requires no coding knowledge

Question 12

What is the main use of DAX in Power BI?

Accepted Answer

Creating custom calculations on data

Answer

Designing the visual layout of reports

Answer

Scheduling data refreshes

Answer

Managing user permissions

Question 13

Which tool is not commonly used for writing DAX expressions?

Accepted Answer

PowerPoint

Answer

SQL Server Data Tools

Answer

Excel

Answer

Power BI Desktop

Question 14

When are DAX measures recalculated?

Accepted Answer

When queried in the report context

Answer

During data model processing

Answer

When Power BI is opened

Answer

When the dataset is refreshed

Question 15

Can DAX be used in SQL Server Analysis Services?

Accepted Answer

Yes

Answer

Only in limited scenarios

Answer

No

Answer

Only with specific extensions

Question 16

What type of calculation is a calculated column best suited for?

Accepted Answer

Row-by-row calculations

Answer

Dynamic report context calculations

Answer

Filtering data interactively

Answer

Aggregating data across tables

Question 17

Is DAX case-sensitive?

Accepted Answer

No

Answer

Only for function names

Answer

Yes

Answer

Only for column names

Question 18

Which of the following is a DAX function?

Accepted Answer

COUNTROWS

Answer

ADD

Answer

FILTERBY

Answer

SUMX

Question 19

What is a typical scenario for using DAX in Power BI?

Accepted Answer

Customizing data calculations for business reports

Answer

Formatting visual elements

Answer

Scheduling report emails

Answer

Creating data connections

Question 20

Which of the following tools is not a primary environment for DAX?

Accepted Answer

Google Sheets

Answer

Excel

Answer

SQL Server Data Tools

Answer

Power BI Desktop

Related quizzes

Related quizzes