Power BI PL-300 Mock Exam Review

Comprehensive vocabulary flashcards covering the Power BI PL-300 curriculum, including storage modes, DAX functions, Power Query transformations, and visualization features.

$$Import$$

The storage mode that stores data in the Power BI in-memory model and provides the fastest query performance.

$$DirectQuery$$

A storage mode that queries source data in real time and is used for large datasets or real-time reporting requirements.

$$Composite\ Model$$

A model that combines both $Import$ and $DirectQuery$ storage modes.

$$Power\ Query\ Editor$$

The component used to shape, transform, and clean data before loading it into the Power BI model.

$$Query\ Folding$$

The process of pushing data transformations and filters back to the source systems for more efficient processing.

$$Measure$$

A dynamic calculation evaluated at query time rather than being stored in the model.

$$Calculated\ Column$$

A column calculated during data refresh and stored permanently in the data model.

$$Fact\ Table$$

A central table in a star schema that typically stores transactional data and quantitative measures.

$$Dimension\ Table$$

A table in a star schema used to store descriptive attributes or lookup information.

$$Star\ Schema$$

The recommended data modeling design for Power BI, consisting of a central fact table surrounded by dimension tables.

$$CALCULATE()$$

The primary DAX function used to modify the filter context of a calculation.

$$RELATED()$$

A DAX function used to retrieve values from a related table.

$$SUMX()$$

An iterator DAX function that evaluates an expression row by row over a table.

$$USERPRINCIPALNAME()$$

A DAX function that returns the email address or identity of the current logged-in user, often used for security.

$$DISTINCTCOUNT()$$

A DAX function that returns the number of unique values in a column.

$$Row-Level\ Security\ (RLS)$$

A feature that restricts data access at the row level based on the identity or role of the user.

$$On-Premises\ Data\ Gateway$$

A component used to connect on-premises data sources to the Power BI Service for scheduled data refreshes.

$$PBIX$$

The native file format for Power BI Desktop containing reports, the data model, and queries.

$$KPI\ Visual$$

A visual optimized for displaying progress toward a specific target or goal.

$$Waterfall\ Chart$$

A visual that identifies the cumulative effect of positive and negative values contributing to a total.

$$Decomposition\ Tree$$

An AI-powered visual used for root cause analysis and exploring data across multiple hierarchical dimensions.

$$Key\ Influencers\ Visual$$

An AI feature that identifies the factors or attributes that most influence a specific metric.

$$Smart\ Narrative$$

An AI feature that automatically generates written summaries and narrative insights about report data.

$$Drillthrough$$

A feature allowing users to navigate from a summary report page to a detailed page while maintaining the filter context.

$$Unpivot$$

A Power Query transformation that converts columns into attribute-value pairs (rows).

$$Append\ Queries$$

A Power Query operation that combines rows from multiple tables with identical structures into a single table.

$$Merge\ Queries$$

A Power Query operation that joins two tables based on matching columns.

$$App$$

A Power BI Service feature used to package and distribute dashboards and reports as a unified content set to users.

$$Incremental\ Refresh$$

A process enabled by $RangeStart$ and $RangeEnd$ parameters to refresh only new or changed data.

$$Bookmarks$$

A feature that captures the current state of a report page, including filters and the visibility of visuals.

$$Query\ Diagnostics$$

A tool used to analyze and monitor the performance of Power Query transformations during refresh or authoring.

$$Table.Buffer()$$

A function that loads a table into memory to prevent multiple queries from repeatedly referencing the same source.