Microsoft Power BI Data Analyst Associate (PL-300) Practice Questions and Correct Answers 100% Aerified 2026 Question 1 Which Power BI component is primarily used to create reports and data models? A. Power BI Service B. Power BI Desktop C. Power

Microsoft Power BI Data Analyst Associate (PL-300)
Practice Questions and Correct Answers 100%
Aerified 2026



Question 1

Which Power BI component is primarily used to create reports and data models?

A. Power BI Service
B. Power BI Desktop
C. Power BI Mobile
D. Power BI Gateway

Correct Answer: B. Power BI Desktop

Rationale: Power BI Desktop is the primary authoring tool used to connect to data sources,
transform data, build models, and create reports before publishing them to the Power BI Service.



Question 2

Which language is used to create calculated columns and measures in Power BI?

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

Correct Answer: C. DAX

Rationale: Data Analysis Expressions (DAX) is the formula language used for calculations in
Power BI data models.



Question 3

Which feature is used to transform and clean data before loading it into a Power BI model?

,A. Report View
B. Model View
C. Power Query Editor
D. Dashboard View

Correct Answer: C. Power Query Editor

Rationale: Power Query Editor provides tools for data cleansing, transformation, and shaping
before loading data.



Question 4

What is the primary purpose of a Power BI Gateway?

A. Create reports
B. Store datasets
C. Refresh on-premises data
D. Build dashboards

Correct Answer: C. Refresh on-premises data

Rationale: A gateway enables secure access between on-premises data sources and Power BI
cloud services.



Question 5

Which relationship cardinality represents one record in Table A matching many records in Table
B?

A. One-to-One
B. Many-to-Many
C. One-to-Many
D. Many-to-One

Correct Answer: C. One-to-Many

Rationale: One-to-many is the most common relationship type in star schema models.



Question 6

,What is the recommended schema design for Power BI models?

A. Snowflake Schema
B. Flat File Schema
C. Star Schema
D. Network Schema

Correct Answer: C. Star Schema

Rationale: Star schema improves performance and simplifies reporting by separating fact and
dimension tables.



Question 7

Which DAX function returns the total of a column?

A. SUM()
B. TOTAL()
C. ADD()
D. COUNT()

Correct Answer: A. SUM()

Rationale: SUM() aggregates all numeric values in a specified column.



Question 8

What is a measure in Power BI?

A. Stored data field
B. Dynamic calculation
C. Relationship type
D. Visualization

Correct Answer: B. Dynamic calculation

Rationale: Measures are calculated at query time based on report context.



Question 9

, Which storage mode imports data into Power BI for fastest query performance?

A. DirectQuery
B. Live Connection
C. Import
D. Composite

Correct Answer: C. Import

Rationale: Import mode stores data in Power BI's in-memory engine for optimal performance.



Question 10

Which visualization is best for showing trends over time?

A. Pie Chart
B. Line Chart
C. Gauge
D. Card

Correct Answer: B. Line Chart

Rationale: Line charts effectively display changes and trends across time periods.



Question 11

What does DirectQuery do?

A. Copies data into Power BI
B. Queries source data in real time
C. Exports reports
D. Creates dashboards

Correct Answer: B. Queries source data in real time

Rationale: DirectQuery leaves data at the source and retrieves it when users interact with
reports.



Question 12