PL-300 Exam Flashcards

Q: What do PL-300 flashcards help you study?

These PL-300 flashcards review Power Query, DAX, data modeling, visualization, Power BI service workspaces, refresh, deployment, and security concepts.

Q: Are PL-300 flashcards enough to pass the exam?

Flashcards help with terminology and feature recall, but PL-300 candidates should also build reports, practice DAX, and answer scenario-based questions.

Q: How should I use PL-300 flashcards?

Use them after hands-on Power BI practice to check whether you can explain each feature, then focus extra review on missed DAX, modeling, or service topics.

Question 1

Import mode

Accepted Answer

Import mode loads a compressed copy of source data into the Power BI semantic model. It usually gives the fastest report performance but requires refresh to keep data current.

Question 2

DirectQuery mode

Accepted Answer

DirectQuery leaves data in the source system and sends queries as users interact with visuals. It supports near-real-time reporting but depends on source performance and has modeling limits.

Question 3

Power Query applied steps

Accepted Answer

Applied steps record each transformation in order. On the exam, changing an earlier step can affect later steps, so understand dependency and step order.

Question 4

Column quality

Accepted Answer

Column quality shows valid, error, and empty value percentages in Power Query. It helps identify cleaning work before data reaches the model.

Question 5

Column distribution

Accepted Answer

Column distribution shows distinct and unique value counts. It helps spot skewed data, unexpected duplicates, and candidate key columns.

Question 6

Query parameters

Accepted Answer

Parameters store reusable values such as server names, file paths, or date filters. They make queries easier to maintain across environments.

Question 7

Append queries

Accepted Answer

Append stacks rows from tables with compatible columns. Use it when datasets have the same grain and structure, such as monthly sales files.

Question 8

Merge queries

Accepted Answer

Merge joins tables by matching key columns. It is used to add related columns from another table before loading data into the model.

Question 9

Folder connector

Accepted Answer

The Folder connector combines files from a folder when the files share the same structure. It is useful for recurring exports because new files can be included on refresh.

Question 10

Data type changes

Accepted Answer

Correct data types improve sorting, filtering, relationships, and DAX behavior. Date, decimal, whole number, and text columns should be typed before loading.

Question 11

Star schema

Accepted Answer

A star schema uses fact tables for measurable events and dimension tables for descriptive attributes. It improves usability, relationship clarity, and DAX performance.

Question 12

Fact table

Accepted Answer

A fact table stores numeric measures and foreign keys at a defined grain, such as one row per order line. The grain controls what analysis is possible.

Question 13

Dimension table

Accepted Answer

A dimension table stores descriptive fields such as product, customer, date, or region. Dimensions filter facts and make reports understandable.

Question 14

One-to-many relationship

Accepted Answer

A one-to-many relationship usually connects a dimension key to repeated fact rows. It is the standard relationship pattern in Power BI models.

Question 15

Filter direction

Accepted Answer

Filter direction controls how filters flow through relationships. Single direction from dimensions to facts is usually preferred for predictable model behavior.

Question 16

Inactive relationship

Accepted Answer

An inactive relationship exists but does not filter by default. DAX can activate it with USERELATIONSHIP for calculations such as ship date analysis.

Question 17

Calculated column

Accepted Answer

A calculated column is evaluated row by row during data refresh and stored in the model. Use it for attributes needed in slicers, relationships, or row-level logic.

Question 18

Measure

Accepted Answer

A measure calculates at query time based on filter context. Measures are best for aggregations such as sales, margin, and year-to-date totals.

Question 19

Row context

Accepted Answer

Row context means DAX is evaluating one row at a time, as in calculated columns and iterators. It matters because row context does not automatically filter related tables like filter context.

Question 20

Filter context

Accepted Answer

Filter context is the set of filters from visuals, slicers, relationships, and DAX expressions. Measures depend on filter context for their final result.

Question 21

CALCULATE

Accepted Answer

CALCULATE evaluates an expression under modified filter context. It is central to DAX because it lets measures change or add filters explicitly.

Question 22

SUMX

Accepted Answer

SUMX is an iterator that evaluates an expression for each row of a table, then sums the results. Use it when simple SUM cannot represent row-level logic.

Question 23

ALL

Accepted Answer

ALL removes filters from a table or column. It is commonly used for percent-of-total calculations and comparisons against an unfiltered baseline.

Question 24

Time intelligence

Accepted Answer

Time intelligence functions compare periods such as year to date, prior year, or moving totals. They require a proper date table for reliable results.

Question 25

Date table

Accepted Answer

A date table is a continuous calendar table marked as the model's date table. It enables correct time intelligence and consistent date filtering.

Question 26

Cardinality

Accepted Answer

Cardinality describes uniqueness in a column and relationship type. High-cardinality columns can increase model size and reduce compression efficiency.

Question 27

Hierarchies

Accepted Answer

Hierarchies group fields into drill paths such as Year > Quarter > Month. They improve report navigation and support drill-down analysis.

Question 28

Implicit measures

Accepted Answer

Implicit measures are automatic aggregations created by visuals. Explicit DAX measures are preferred for reusable, documented, and controlled calculations.

Question 29

Slicer

Accepted Answer

A slicer is an on-canvas filter control. It helps users narrow report context without opening the filters pane.

Question 30

Visual interactions

Accepted Answer

Visual interactions define whether one visual filters, highlights, or ignores another. They are tested because report behavior depends on these settings.

Question 31

Drillthrough page

Accepted Answer

A drillthrough page shows detail for a selected entity or category. It lets users move from summary visuals to focused analysis.

Question 32

Bookmarks

Accepted Answer

Bookmarks capture report state, including filters, visibility, and page view. They support guided navigation, toggles, and presentation-style reports.

Question 33

Report tooltip

Accepted Answer

A report tooltip is a custom page shown on hover. It provides extra context without cluttering the main report canvas.

Question 34

Conditional formatting

Accepted Answer

Conditional formatting changes visual styling based on values or rules. It helps users quickly spot thresholds, trends, and exceptions.

Question 35

Key influencers visual

Accepted Answer

The Key influencers visual identifies factors associated with a selected outcome. It matters for exploratory analysis and AI-assisted insight discovery.

Question 36

Q&A visual

Accepted Answer

The Q&A visual lets users ask natural-language questions against a model. Clear field names and synonyms improve the quality of answers.

Question 37

Decomposition tree

Accepted Answer

A decomposition tree breaks a measure down by multiple dimensions. It helps analyze root causes and compare contributors to a result.

Question 38

Anomaly detection

Accepted Answer

Anomaly detection highlights values that differ from expected patterns in a time series visual. It helps users investigate unusual business events.

Question 39

Workspace roles

Accepted Answer

Workspace roles control what users can do in a workspace. Admin, Member, Contributor, and Viewer have different permissions for publishing, sharing, and managing content.

Question 40

App workspace

Accepted Answer

An app workspace is the collaborative container for reports, semantic models, dashboards, and dataflows. It is usually the source for publishing a Power BI app.

Question 41

Power BI app

Accepted Answer

A Power BI app packages selected workspace content for consumers. Apps make distribution cleaner than granting broad workspace access.

Question 42

Scheduled refresh

Accepted Answer

Scheduled refresh updates imported data on a defined cadence. It requires valid credentials and, for on-premises data, a working gateway.

Question 43

On-premises data gateway

Accepted Answer

A gateway securely connects Power BI service to on-premises data sources. It is essential for scheduled refresh or DirectQuery against local systems.

Question 44

Dataflow

Accepted Answer

A dataflow stores reusable Power Query transformations in the Power BI service. It helps standardize data preparation across multiple semantic models.

Question 45

Deployment pipelines

Accepted Answer

Deployment pipelines move content through development, test, and production stages. They reduce manual publishing mistakes in managed environments.

Question 46

Row-level security (RLS)

Accepted Answer

RLS restricts rows a user can see based on roles and filters. It matters when different audiences share the same report but need different data access.

Question 47

Dynamic RLS

Accepted Answer

Dynamic RLS uses DAX functions such as USERPRINCIPALNAME to filter data for the signed-in user. It avoids creating separate static roles for every user.

Question 48

Sensitivity labels

Accepted Answer

Sensitivity labels classify and protect Power BI content based on information sensitivity. They support governance and data loss prevention policies.

Question 49

Endorsement

Accepted Answer

Endorsement marks content as promoted or certified. It helps users identify trusted datasets and reports in the Power BI service.

Question 50

Incremental refresh

Accepted Answer

Incremental refresh updates only recent partitions instead of reloading all historical data. It improves refresh speed and reduces load on large models.

Free PL-300 Exam Flashcards

Filter by Topic

Jump to Card

About These PL-300 Flashcards

Topics Covered

Frequently Asked Questions

Microsoft Power BI Data Analyst

Explore More Microsoft Certifications

Azure MS-102

Microsoft Power Platform Functional Consultant

Azure MD-102

Microsoft Power Platform Developer

Microsoft Power Platform Fundamentals (PL-900)

Microsoft Power Platform Fundamentals (PL-900)

More From This Family