Practice Questions

---

Question 1

What is the primary purpose of Microsoft Power BI?

A. Managing databases
B. Running virtual machines
C. Creating reports and visualizations from data
D. Developing applications

✅ Answer: C

Explanation:
Power BI is a business intelligence tool used to create reports, dashboards, and visualizations.

---

Question 2

Which Power BI component is used to create reports?

A. Power BI Service
B. Power BI Mobile
C. Power BI Desktop
D. Azure Portal

✅ Answer: C

Explanation:
Power BI Desktop is the primary tool for building reports and data models.

---

Question 3

What is the main difference between a report and a dashboard in Power BI?

A. Reports are single-page, dashboards are multi-page
B. Reports are multi-page, dashboards are single-page
C. Reports are only for developers
D. Dashboards cannot contain visuals

✅ Answer: B

Explanation:
Reports are multi-page and detailed, while dashboards are single-page summaries.

---

Question 4

Which feature in Power BI is used to clean and transform data?

A. DAX
B. Power Query
C. Power Pivot
D. Azure Data Factory

✅ Answer: B

Explanation:
Power Query is used for data transformation and preparation.

---

Question 5

Which language is used in Power BI for creating calculations and measures?

A. SQL
B. Python
C. DAX
D. Java

✅ Answer: C

Explanation:
DAX (Data Analysis Expressions) is used for calculations and measures.

---

Question 6

Which Power BI feature allows users to restrict data access to specific rows?

A. Data refresh
B. Row-Level Security (RLS)
C. Power Query
D. Dashboards

✅ Answer: B

Explanation:
Row-Level Security (RLS) ensures users only see data they are authorized to access.

---

Question 7

Which of the following is a key capability of Power BI?

A. Running operating systems
B. Hosting web applications
C. Connecting to multiple data sources
D. Managing network traffic

✅ Answer: C

Explanation:
Power BI can connect to many different data sources, including databases, files, and cloud services.

---

Question 8

Where are Power BI reports typically published for sharing and collaboration?

A. Power BI Desktop
B. Power BI Service
C. Azure Virtual Machines
D. SQL Server

✅ Answer: B

Explanation:
Reports are published to the Power BI Service for sharing and collaboration.

---

Question 9

Which capability allows Power BI to display near real-time data?

A. Scheduled refresh only
B. Streaming datasets
C. Static reports
D. Data export

✅ Answer: B

Explanation:
Streaming datasets enable real-time or near real-time updates.

---

Question 10

What is the purpose of a Power BI dashboard?

A. To store raw data
B. To create data pipelines
C. To provide a single-page view of key metrics
D. To manage user accounts

✅ Answer: C

Explanation:
Dashboards provide a high-level, single-page summary of important data.

---

✅ Quick Exam Takeaways

✔ Power BI is used for:

• Data visualization
• Reporting
• Business intelligence

✔ Key features:

• Power Query → data transformation
• DAX → calculations
• Reports → multi-page
• Dashboards → single-page

✔ Components:

• Power BI Desktop → build reports
• Power BI Service → share and collaborate

✔ Security:

• Row-Level Security (RLS)

✔ Exam tip:
👉 Transform data → Power Query
👉 Create calculations → DAX
👉 Share reports → Power BI Service

---

Go to the DP-900 Exam Prep Hub main page.