Question 1

1. What is a primary function of data modeling in Power BI?

Accepted Answer

To structure data for easier analysis

Answer

To improve data entry speed

Answer

To increase data storage

Answer

To simplify programming tasks

Question 2

2. Which type of relationship is commonly used between fact and dimension tables in a star schema?

Accepted Answer

One-to-many

Answer

All-to-all

Answer

Many-to-many

Answer

One-to-one

Question 3

3. What does DAX stand for?

Accepted Answer

Data Analysis Expressions

Answer

Data Analytics Extensions

Answer

Direct Access XML

Answer

Data Access Express

Question 4

4. Which DAX function is used to calculate a running total?

Accepted Answer

CUMULATE

Answer

ACCUMULATE

Answer

TOTAL

Answer

SUM

Question 5

5. What is the best practice for handling a large dimension table in Power BI?

Accepted Answer

Creating aggregations

Answer

Using a flat file format

Answer

Splitting into multiple tables

Answer

Removing non-essential columns

Question 6

6. In a star schema, what role do dimension tables play?

Accepted Answer

Describing attributes of business entities

Answer

Logging changes over time

Answer

Storing transactional data

Answer

Aggregating metrics

Question 7

7. What is the significance of a snowflake schema?

Accepted Answer

Normalized form of a star schema to reduce redundancy

Answer

Flat data architecture

Answer

Denormalized form of a star schema

Answer

Unstructured data format

Question 8

8. Which function in DAX is used to retrieve the last non-empty value in a column?

Accepted Answer

LASTNONBLANK

Answer

LAST

Answer

LASTVALUE

Answer

END

Question 9

9. How do you improve query performance on a large dataset in Power BI?

Accepted Answer

Creating indexes on columns

Answer

Reducing the number of visuals

Answer

Storing data in a single table

Answer

Increasing the refresh rate

Question 10

10. Which of the following is not a type of filter in Power BI?

Accepted Answer

Document level filter

Answer

Page level filter

Answer

Report level filter

Answer

Visual level filter

Question 11

11. What is the purpose of the RELATED function in DAX?

Accepted Answer

To fetch related data from another table

Answer

To duplicate records

Answer

To perform calculations within a table

Answer

To check data validity

Question 12

12. How is data security typically implemented in Power BI?

Accepted Answer

Row-level security

Answer

Firewall settings

Answer

Data masking

Answer

Column encryption

Question 13

13. What role does a 'Date' dimension table play in a data model?

Accepted Answer

It provides context for trend analysis

Answer

Records time stamps of data entries

Answer

Stores actual transaction dates only

Answer

Calculates fiscal years

Question 14

14. What is the primary benefit of using a many-to-many relationship in Power BI?

Accepted Answer

It allows linking tables without a single unique key

Answer

Improves data load time

Answer

Simplifies the data model

Answer

Reduces the need for DAX formulas

Question 15

15. Which DAX function is crucial for creating calculated columns?

Accepted Answer

CALCULATE

Answer

DIVIDE

Answer

MULTIPLY

Answer

SUM

Question 16

16. What is typically used to implement hierarchical structures in data modeling?

Accepted Answer

Parent-child relationships

Answer

Linked lists

Answer

Stacked tables

Answer

Sequential IDs

Question 17

17. When setting up a data model, what is the key consideration for a fact table?

Accepted Answer

It should be large and contain transactional data

Answer

It should not be linked to dimension tables

Answer

It should only contain summary data

Answer

It should contain detailed attribute data

Question 18

18. What is a common method to handle different granularities of data in Power BI?

Accepted Answer

Creating bridge tables

Answer

Combining all data into one table

Answer

Using single granularity

Answer

Increasing refresh intervals

Question 19

19. How can you use DAX to create dynamic titles in Power BI reports?

Accepted Answer

Using the CONCATENATE function

Answer

Hard coding titles

Answer

Using basic text functions only

Answer

Ignoring context filters

Question 20

20. What is essential to ensure data integrity when designing a data model?

Accepted Answer

Consistent relationships and data types

Answer

Matching color schemes

Answer

Uniform visual layouts

Answer

Consistent font styles

Related quizzes

Related quizzes