Power BI Fundamentals Quiz Quiz

Test your foundational understanding of Power BI concepts, components, and key terminologies commonly encountered in basic interviews.

1. Purpose of Power BI

   What is Power BI primarily used for in data analytics?

   1. To visualize and share insights from data
   2. To build websites for analytics
   3. To write mobile applications
   4. To manage computer networks
   5. To create SQL databases

2. Power BI Components

   Which of the following is a main component of Power BI used to create reports on a desktop computer?

   1. Power BI Desktop
   2. Power Tablet
   3. Power Gateway
   4. Power BI Web
   5. Power BI Mobile

3. Using Power BI Service

   What is the main purpose of Power BI Service when compared to Power BI Desktop?

   1. To share and collaborate reports online
   2. To develop mobile games
   3. To install new operating systems
   4. To design hardware circuits
   5. To create spreadsheets only

4. Understanding DAX

   In Power BI, what does DAX stand for?

   1. Data Analysis Expressions
   2. Dynamic Analytics Excel
   3. Direct Analysis Export
   4. Data Access Exchange
   5. Data Activated Extension

5. Calculated Column vs Measure

   Which statement correctly differentiates a measure from a calculated column in Power BI?

   1. A calculated column is for charts, and a measure is only for maps.
   2. A measure is calculated on-the-fly when visualizing data, while a calculated column is stored in the table.
   3. A calculated column can only sum values, while a measure cannot aggregate data.
   4. A measure does not use DAX, while a calculated column does.
   5. A measure is always visible in table view, while a calculated column is hidden.

6. Role of Power Query

   What function does Power Query provide in Power BI?

   1. Managing firewall settings
   2. Sending automated emails
   3. Building PowerPoint presentations
   4. Encrypting entire data models
   5. Connecting, cleaning, and transforming data

7. Types of Relationships

   Which relationship type allows multiple records in one table to relate to multiple records in another within Power BI?

   1. Two-to-Two
   2. Multi-to-One
   3. One-to-Two
   4. Many-to-Many
   5. Single-to-Single

8. Available Visualizations

   Which of the following is a common visualization type available in Power BI?

   1. Text editor
   2. Spell checker
   3. Music player
   4. Bar chart
   5. Firewall monitor

9. Handling Missing Data

   What is one way to handle missing or null values in Power BI using Power Query?

   1. Automatically hide rows without asking
   2. Lock the workbook
   3. Replace null values with specific values
   4. Encrypt the null values
   5. Export nulls to other applications

10. Role of Relationships Pane

    What is the main function of the 'Relationships' pane in Power BI?

    1. To define and manage connections between tables
    2. To schedule email notifications
    3. To update software drivers
    4. To select report themes only
    5. To monitor system performance