Question 1

What is the primary reason for creating a Calendar table in Power BI?

Accepted Answer

To ensure time-intelligence functions work correctly

Answer

To manage financial transactions

Answer

To store employee data

Answer

To track sales leads

Question 2

Which Power BI feature is used to create a Calendar table?

Accepted Answer

Power Query

Answer

Data Model

Answer

Power Automate

Answer

DAX Functions

Question 3

What type of column is essential in a Calendar table for enabling time-based calculations?

Accepted Answer

Date

Answer

Customer Name

Answer

Transaction Amount

Answer

Product ID

Question 4

How do you connect the Calendar table to your existing data model in Power BI?

Accepted Answer

By creating relationships

Answer

By creating a summary table

Answer

By using a visual

Answer

By importing as a CSV file

Question 5

Which function is used in Power Query to generate a list of dates for the Calendar table?

Accepted Answer

List.Dates

Answer

GENERATE()

Answer

DATE()

Answer

CALENDAR()

Question 6

What is a common use case for a Calendar table in business analytics?

Accepted Answer

Performing Year-to-Date (YTD) calculations

Answer

Storing historical financial transactions

Answer

Managing inventory levels

Answer

Tracking real-time data updates

Question 7

Which column in the Calendar table helps to sort months chronologically?

Accepted Answer

Month Number

Answer

Month Name

Answer

Week Number

Answer

Year

Question 8

How can you enhance analytics capabilities with a Calendar table in Power BI?

Accepted Answer

By enabling more accurate time-based calculations

Answer

By reducing the size of the data model

Answer

By increasing the number of data sources

Answer

By simplifying data entry

Question 9

What is the advantage of using Power Query for creating a Calendar table?

Accepted Answer

Flexibility to define custom date ranges

Answer

Automatic synchronization with external systems

Answer

Predefined templates for various industries

Answer

Ability to directly modify SQL databases

Question 10

Which DAX function can be used alternatively to create a simple Date table directly in the model?

Accepted Answer

CALENDAR()

Answer

SUMMARIZE()

Answer

FILTER()

Answer

DATEADD()

Related quizzes

Related quizzes