Power BI Quiz

Which of the following is a common data source in Power BI?

• Microsoft Excel

• SQL Server

• Azure Data Lake

• All of the above

Answer explanation

All of the options listed—Microsoft Excel, SQL Server, and Azure Data Lake—are common data sources in Power BI, making 'All of the above' the correct answer.

What is the role of Power Query in Power BI?

• To create dashboards

• To clean and transform data

• To visualize data

• To manage user permissions

Answer explanation

Power Query is essential in Power BI for cleaning and transforming data before analysis. It allows users to prepare their data by removing errors, changing formats, and combining sources, making it the correct choice.

How can you connect Power BI to a SQL Server database?

• By using the "Get Data" feature

• By importing data from an Excel file

• By writing SQL queries directly

• Power BI cannot connect to SQL Server

Answer explanation

You can connect Power BI to a SQL Server database by using the 'Get Data' feature, which allows you to select SQL Server as a data source and establish a connection to retrieve data.

What is DirectQuery mode in Power BI?

• A mode where data is stored in Power BI

• A mode where Power BI connects to data sources directly without importing data

• A mode where only metadata is imported

• A mode where data is manually entered

Answer explanation

DirectQuery mode in Power BI allows for real-time data access by connecting directly to data sources without importing the data. This enables users to work with the most current data available.

Which of the following is not a valid data source for Power BI?

• Microsoft Word

• Excel

• Oracle Database

• Google Analytics

Answer explanation

Microsoft Word is primarily a word processing application and does not serve as a valid data source for Power BI. In contrast, Excel, Oracle Database, and Google Analytics are all compatible data sources.

How often can Power BI datasets be refreshed in the Power BI Service?

• Once a week

• Up to 8 times per day

• Up to 48 times per day

• It depends on the Power BI subscription

Answer explanation

Power BI datasets can be refreshed up to 48 times per day in the Power BI Service, allowing for frequent updates to data. This flexibility is beneficial for real-time reporting and analytics.

What is the purpose of the Power BI Desktop application?

• To create dashboards

• To design and create reports

• To manage datasets

• To share reports with others

Answer explanation

The primary purpose of Power BI Desktop is to design and create reports. While it can also manage datasets and create dashboards, its core functionality focuses on report design.

What is a primary key in Power BI data modeling?

• A unique identifier for each row in a table

• A field used to store text

• A formula for calculations

• A relationship between two tables

Answer explanation

A primary key in Power BI data modeling serves as a unique identifier for each row in a table, ensuring that each record can be distinctly recognized. This is crucial for maintaining data integrity and establishing relationships.

Which type of relationship allows filtering in both directions between two tables?

• One-to-Many

• Many-to-One

• Many-to-Many

• Bidirectional

Answer explanation

A bidirectional relationship allows filtering in both directions between two tables, meaning you can access related records from either table. This is not the case for one-to-many or many-to-one relationships.

What is a calculated column in Power BI?

• A column that is manually entered by the user

• A column created by applying a DAX formula to existing columns

• A column imported from another data source

• A column used to create a relationship between tables

Answer explanation

A calculated column in Power BI is created by applying a DAX formula to existing columns, allowing for dynamic calculations based on the data model. This distinguishes it from manually entered or imported columns.