DP-600 flashcards
DP-600 · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Fabric capacity unit
- The compute measure consumed by Fabric workloads; each SKU provides a fixed number of capacity units per second, and exceeding the limit triggers throttling of interactive and background operations.
- Contributor workspace role
- A workspace role that can create, edit, and delete items such as lakehouses and reports, but cannot add users to the workspace or change workspace-level permissions.
- Deployment pipeline stages
- Ordered environments, defaulting to Development, Test, and Production with up to ten allowed; deployment rules rebind data sources or parameters so each stage points at the right data.
- Fabric domain
- A governance grouping of workspaces managed by domain admins; a workspace can belong to only one domain, and domains may contain nested subdomains.
- Certified endorsement
- The higher of the two endorsement levels for Fabric and Power BI items; only users designated as certifiers by the tenant administrator can apply it to trusted, reviewed content.
- Git integration
- A workspace setting that binds the workspace to an Azure DevOps repository, branch, and folder so supported item definitions are serialized to text for version control.
- Capacity Metrics app
- A Power BI monitoring app installed by a capacity admin that reports capacity unit consumption, throttling events, and per-item and per-operation usage over time.
- Pausing a capacity
- An operation that suspends compute for a Fabric capacity, stopping compute billing and making hosted items unavailable; OneLake storage charges continue while the capacity is paused.
- Lakehouse versus warehouse
- A lakehouse stores Delta tables in OneLake and is queried by Spark plus a read-only SQL analytics endpoint, whereas a warehouse offers full read-write T-SQL with no Spark engine.
- OneLake shortcut
- A zero-copy reference that makes data in another OneLake location, ADLS Gen2, Amazon S3, Google Cloud Storage, or Dataverse appear as a folder without moving or duplicating it.
- Dataflow Gen2
- A Power Query Online based data preparation item that transforms data and writes results to a lakehouse, warehouse, or other destination, and can be orchestrated by a pipeline.
- Medallion architecture layers
- A layered lakehouse pattern where bronze holds raw ingested data, silver holds validated and cleaned tables, and gold holds business-level aggregated tables consumed by reports.
- V-Order
- A write-time Parquet optimization in Fabric that sorts, encodes, and compresses Delta files to speed up reads, particularly for Direct Lake; it is enabled by default.
- OPTIMIZE with Z-ORDER
- A Delta table maintenance command that compacts many small files and, when Z-ORDER BY is added, co-locates related rows so filtered queries can skip more files.
- VACUUM command
- A Delta maintenance operation that permanently deletes data files no longer referenced by the transaction log and older than the retention threshold, seven days by default.
- Mirroring in Fabric
- A feature that continuously replicates an external database into OneLake as read-only Delta tables with near-real-time latency, without placing read load on the source system.
- Direct Lake mode
- A semantic model storage mode that reads Delta Parquet files from OneLake without importing a copy, and falls back to DirectQuery when model guardrails are exceeded.
- Row-level security role
- A model role containing a DAX table filter expression that restricts which rows a user can see; members are assigned by email or Entra security group and tested with View as role.
- Object-level security
- A model security feature that hides entire tables or columns from a role so those objects do not appear in reports; it is configured through XMLA or Tabular Editor, not Desktop.
- Calculation group
- A model object holding reusable calculation items that are applied to any measure, commonly used to implement time intelligence; it is authored with Tabular Editor or XMLA.
- Incremental refresh policy
- A model setting that needs RangeStart and RangeEnd date/time parameters and defines the store period, the refresh period, and an optional column used to detect changed rows.
- TMDL
- Tabular Model Definition Language, a human-readable text representation of a semantic model used for source control, Git integration, and deployment between environments.
- Measure versus calculated column
- A measure is evaluated at query time from filter context and stores no data, while a calculated column is evaluated row by row during refresh and its results are persisted in the model.
- Star schema design
- A model layout where fact tables hold keys and numeric measures and dimension tables hold descriptive attributes, joined by one-to-many relationships from dimension to fact.
- DAX query view
- An editor in Power BI Desktop and the service that runs EVALUATE queries against a semantic model and can also define, update, or delete measures in the model.
- Visual calculations
- DAX expressions evaluated on the aggregated data of a single visual, using functions such as RUNNINGSUM, MOVINGAVERAGE, RANK, COLLAPSE, and EXPAND; model columns cannot be referenced directly.
- Data Wrangler
- A Fabric data exploration tool with a grid-based interface that applies transformations to lakehouse data and exports the equivalent reusable PySpark code.
- SQL analytics endpoint
- A read-only T-SQL surface over lakehouse Delta tables that supports views, inline table-valued functions, and stored procedures, often used to control access to underlying data.
- KQL queryset
- A Real-Time Intelligence item used to query KQL databases with operators such as where, summarize, bin(), and render, suited to telemetry and time-series analysis.
- Quick measure
- A Power BI authoring shortcut that generates DAX from a template such as aggregation, filter, or time intelligence after the author selects fields in a dialog.
- Copilot in Power BI
- A Fabric assistant feature that requires an F64 or P1-or-larger capacity and a tenant setting, and can draft DAX, explain report content, and summarize data.
- Explore feature
- A Power BI capability that opens a semantic model on an ad-hoc canvas where users build their own visuals from available fields without editing the published report.