PowerBI Test 2

1. What is a Power BI Desktop file extension?

• xlsx

• pbix

• pptx

• docx

2. What is the purpose of Power BI Service?

• Creating reports and dashboards

• Sharing and collaborating on reports online

• Importing data from external sources

• Designing data models

3. How can you create relationships between tables in Power BI?

• Dragging and dropping fields onto each other

• Using SQL queries

• Copy-pasting data between table

• Importing external relationships

4. How do you create a calculated column in Power BI?

• Using Power Query

• Dragging and dropping fields in the report view

• Writing a DAX formula in the Data Model view

• Importing a pre-built template

5. How can you schedule data refresh in Power BI Service?

• Manually refreshing data before sharing the report

• Automatically refreshing data at specific intervals

• Refreshing data only in Power BI Desktop

• Refreshing data using Power Query

6. What is the purpose of the 'Filter' pane in Power BI?

• Changing the theme of the report

• Sorting data in tables

• Controlling the visibility of report elements

• Defining relationships between tables

7. In Power BI, what is a measure?

• A calculated column

• A field from the data source

• A visual representation of data

• A calculated value based on DAX expressions

8. What is the purpose of the 'Card' visualization in Power BI?

• Displaying a single value or KPI

• Showing geographical data on a mapl

• Representing trends over time

• Comparing multiple categories in a single visual

9. How can you create a calculated table in Power BI?

• Using Power Query

• Dragging and dropping fields in the report view

• Writing a DAX formula in the Data Model view

• Importing a pre-built template

10. How can you share a Power BI report with others?

• Exporting the report to Excel

• Saving the report as a PDF

• Publishing the report to the Power BI Service

• Attaching the PBIX file to an email