MICROSOFT POWER BI DATA ANALYST EXAMINATION
QUESTIONS AND CORRECT ANSWER WITH
EXPLANATION GRADED A+ STUDY GUIDE SOUTHERN
NEW HAMPSHIRE
1. Power BI is primarily used for:
A. Data visualization and business intelligence
B. Hardware repair
C. Network configuration
D. Software development
Answer: A
Rationale: Power BI is a BI tool for analyzing and visualizing data.
2. The main components of Power BI include:
A. Power BI Desktop, Service, and Mobile
B. Word, Excel, PowerPoint
C. Linux, Windows, MacOS
D. SQL, Python, Java
Answer: A
Rationale: These are the core Power BI platforms.
3. Power BI Desktop is used for:
A. Creating reports and dashboards
B. Sending emails
C. Programming websites
D. Managing hardware
Answer: A
Rationale: Desktop is for report development.
4. Power BI Service is used for:
,A. Sharing and publishing reports online
B. Installing software
C. Coding applications
D. Encrypting data
Answer: A
Rationale: Cloud-based sharing platform.
5. Power BI Mobile app is used for:
A. Viewing reports on mobile devices
B. Editing code
C. Designing hardware
D. Database creation
Answer: A
Rationale: Mobile access to dashboards.
6. Data in Power BI comes from:
A. Multiple data sources
B. Only Excel
C. Only SQL
D. Only images
Answer: A
Rationale: Supports many connectors.
7. Power Query is used for:
A. Data transformation and cleaning
B. Hardware repair
C. Network setup
D. File compression
Answer: A
Rationale: ETL tool inside Power BI.
8. ETL stands for:
, A. Extract, Transform, Load
B. Edit, Test, Launch
C. Encrypt, Transfer, Load
D. Extract, Test, Link
Answer: A
Rationale: Data processing pipeline.
9. DAX in Power BI stands for:
A. Data Analysis Expressions
B. Data Access XML
C. Digital Analytics Exchange
D. Data Application eXport
Answer: A
Rationale: Formula language in Power BI.
10. A dataset in Power BI is:
A. A collection of data used for reporting
B. A hardware component
C. A programming language
D. A network device
Answer: A
Rationale: Data source for reports.
11. A dashboard is:
A. A single-page visual summary
B. A database
C. A code file
D. A server
Answer: A
Rationale: High-level summary view.
12. A report in Power BI is:
QUESTIONS AND CORRECT ANSWER WITH
EXPLANATION GRADED A+ STUDY GUIDE SOUTHERN
NEW HAMPSHIRE
1. Power BI is primarily used for:
A. Data visualization and business intelligence
B. Hardware repair
C. Network configuration
D. Software development
Answer: A
Rationale: Power BI is a BI tool for analyzing and visualizing data.
2. The main components of Power BI include:
A. Power BI Desktop, Service, and Mobile
B. Word, Excel, PowerPoint
C. Linux, Windows, MacOS
D. SQL, Python, Java
Answer: A
Rationale: These are the core Power BI platforms.
3. Power BI Desktop is used for:
A. Creating reports and dashboards
B. Sending emails
C. Programming websites
D. Managing hardware
Answer: A
Rationale: Desktop is for report development.
4. Power BI Service is used for:
,A. Sharing and publishing reports online
B. Installing software
C. Coding applications
D. Encrypting data
Answer: A
Rationale: Cloud-based sharing platform.
5. Power BI Mobile app is used for:
A. Viewing reports on mobile devices
B. Editing code
C. Designing hardware
D. Database creation
Answer: A
Rationale: Mobile access to dashboards.
6. Data in Power BI comes from:
A. Multiple data sources
B. Only Excel
C. Only SQL
D. Only images
Answer: A
Rationale: Supports many connectors.
7. Power Query is used for:
A. Data transformation and cleaning
B. Hardware repair
C. Network setup
D. File compression
Answer: A
Rationale: ETL tool inside Power BI.
8. ETL stands for:
, A. Extract, Transform, Load
B. Edit, Test, Launch
C. Encrypt, Transfer, Load
D. Extract, Test, Link
Answer: A
Rationale: Data processing pipeline.
9. DAX in Power BI stands for:
A. Data Analysis Expressions
B. Data Access XML
C. Digital Analytics Exchange
D. Data Application eXport
Answer: A
Rationale: Formula language in Power BI.
10. A dataset in Power BI is:
A. A collection of data used for reporting
B. A hardware component
C. A programming language
D. A network device
Answer: A
Rationale: Data source for reports.
11. A dashboard is:
A. A single-page visual summary
B. A database
C. A code file
D. A server
Answer: A
Rationale: High-level summary view.
12. A report in Power BI is:
