Q1
Q1 What is the primary purpose of Power BI?
To manage relational databases
To create and visualize interactive business intelligence reports and dashboards
To develop cloud-based applications
To perform machine learning model training
Q2
Q2 Which company developed Power BI?
Microsoft
IBM
Oracle
Q3
Q3 What is the primary file format used to save Power BI reports?
.xls
.pbix
.csv
.docx
Q4
Q4 Which Power BI component is used to build reports?
Power BI Desktop
Power BI Service
Power BI Mobile
Power Query
Q5
Q5 Which of the following is NOT a capability of Power BI?
Data transformation
Machine learning model training
Data visualization
Data connectivity
Q6
Q6 What is the main advantage of using Power BI over Excel for reporting?
Limited visualization options
Real-time data connectivity
Less user control over data
Lack of automation
Q7
Q7 What is Power BI’s cloud-based service called?
Power BI Report Builder
Power BI Service
Power BI Cloud
Power BI Embedded
Q8
Q8 Which language is used in Power BI for data transformation and manipulation?
SQL
DAX
Python
Java
Q9
Q9 A user loads a dataset into Power BI, but a column does not appear in the Report View. What is the most likely reason?
The column is hidden in the Model View
The Power BI file is too large
The dataset connection is broken
The user has applied incorrect filters in the Visualizations Pane
Q10
Q10 Which of the following is NOT a main component of Power BI?
Power BI Desktop
Power BI Service
Power BI Cloud
Power BI Mobile
Q11
Q11 What is the primary role of Power BI Desktop?
Creating reports and dashboards
Storing data
Performing machine learning
Managing cloud storage
Q12
Q12 What is the function of Power BI Service?
Running SQL queries
Publishing and sharing reports
Building data pipelines
Writing DAX formulas
Q13
Q13 Power BI Mobile allows users to:
Build new reports
Edit DAX formulas
View and interact with reports
Modify data models
Q14
Q14 Which component is used for connecting to different data sources?
Power Query
DAX
Power BI Service
Power BI Embedded
Q15
Q15 What is the purpose of Power BI Gateway?
To refresh cloud datasets
To connect on-premises data sources to Power BI Service
To secure user logins
To create paginated reports
Q16
Q16 What is the key function of Power BI Embedded?
Running AI models
Embedding interactive Power BI reports into applications
Storing large datasets
Scheduling data refresh
Q17
Q17 In Power BI, which component is used for managing data refresh schedules?
Power BI Service
Power BI Gateway
Power Query
Power BI Desktop
Q18
Q18 Which query language is used in Power Query for data transformation?
M Language
DAX
SQL
R
Q19
Q19 A Power BI report is not refreshing correctly after changes in the dataset. What could be a possible reason?
The report needs to be republished
The dataset refresh is disabled
The filters are not set properly
All of the above
Q20
Q20 Which of the following data sources can Power BI connect to?
Excel
SQL Server
Google Analytics
SharePoint
Q21
Q21 Which component is primarily responsible for connecting to data sources in Power BI?
Power Query
DAX
Power BI Service
Power BI Gateway
Q22
Q22 How does Power BI retrieve data from an SQL database?
Direct Query
Import Mode
Live Connection
API Connection
Q23
Q23 What happens when you use DirectQuery in Power BI?
Data is stored in Power BI
Data is stored in an external database
Data is copied to Excel
Data is preloaded in Power BI
Q24
Q24 What is the main advantage of using Live Connection over DirectQuery?
Supports real-time updates
Improves report performance
Provides offline access
Minimizes database load
Q25
Q25 What is the function of Power BI Gateway?
Connecting on-premises data sources to Power BI Service
Managing user security
Exporting Power BI reports
Creating calculated columns
Q26
Q26 When should you use Import Mode instead of DirectQuery?
When dealing with large datasets
When real-time data is required
When offline access is needed
When database queries need optimization
Q27
Q27 Which of the following methods is used to connect an Excel file to Power BI?
SQL Query
Power Automate
Power Query
Power Pivot
Q28
Q28 Which M function is used in Power Query to combine two tables based on a common column?
UNION
MERGE
JOIN
APPEND
Q29
Q29 A user imports data from an Excel file, but some rows are missing. What could be the cause?
Incorrect data types
Data privacy settings
Applied filters
Merging issues
Q30
Q30 After connecting to a SQL database in Power BI, the user sees outdated data. What is the most likely reason?
The data source is disconnected
The query is not refreshing
The server is down
The data format is incorrect
