Question 1

1. What is the main purpose of creating a calendar table in Power BI?

Accepted Answer

To enable time-intelligence functions

Answer

To create visualizations

Answer

To store raw data

Answer

To manage user roles

Question 2

2. Which DAX function is used to automatically generate a date range for a calendar table?

Accepted Answer

CALENDARAUTO()

Answer

DATEDIFF()

Answer

DATEVALUE()

Answer

DATEADD()

Question 3

3. Which of the following is NOT a column typically included in a calendar table?

Accepted Answer

Product Name

Answer

Month

Answer

Quarter

Answer

Year

Question 4

4. What is the correct DAX code to add a Year column in a calendar table?

Accepted Answer

"Year", YEAR([Date])

Answer

"Year", FORMAT([Date], "YYYY")

Answer

"Year", DATE([Date])

Answer

"Year", YEAR([Year])

Question 5

5. In the DAX code, what does the WEEKDAY([Date],2) function return?

Accepted Answer

Weekday number (1-Mon..7-Sun)

Answer

Week number

Answer

Weekday name

Answer

Weekday number (1-Sun..7-Sat)

Question 6

6. What is a primary benefit of using time-intelligence functions in Power BI?

Accepted Answer

Simplified date-based calculations

Answer

Faster data import

Answer

Improved data storage

Answer

Enhanced security

Question 7

7. Which of the following is an example of a basic DAX measure?

Accepted Answer

SUM(Sales[Amount])

Answer

All of the above

Answer

MAX(Sales[Date])

Answer

COUNTROWS(Sales)

Question 8

8. How can you create a calculated column in Power BI using DAX?

Accepted Answer

By using the New Column feature in the Fields pane

Answer

By using the Power Query Editor

Answer

By importing a new dataset

Answer

By changing data types

Question 9

9. What does the FORMAT([Date], "MMM") function return in DAX?

Accepted Answer

Abbreviated month name

Answer

Abbreviated day name

Answer

Full month name

Answer

Month number

Question 10

10. Which function can be used to calculate the difference in years between two dates in DAX?

Accepted Answer

DATEDIFF([StartDate], [EndDate], YEAR)

Answer

YEARFRAC([StartDate], [EndDate])

Answer

DATEADD([StartDate], [EndDate])

Answer

DATEVALUE([StartDate], [EndDate])

Related quizzes

Related quizzes