Glossary
Search Azure terms
Open a clear definition, then continue into exam context, architecture, commands, operational examples, common mistakes, and related concepts.
Search all
Commands
Learning guides
Concept graph
Compare
Search-first Azure knowledge base
Term results
Search for a term or click a category. Results render only after you ask for them, so the glossary does not dump every available term on first load. Each result includes Quick peek and Open full term page actions.
Start with a search or a category.
Try managed identity , resource group , az group , private endpoint , or click Databases to load all database-related terms.
Showing 50 of 478 matching terms. Narrow the search to reduce the list.
Analytics
top-250-pre130-priority-upgraded
Dedicated SQL pool
Dedicated SQL pool is a provisioned massively parallel processing data warehouse resource in Azure Synapse Analytics used for relational analytical queries at a selected DWU level in Azure.
Analytics platform
fundamentals
7 commands
Aliases: Dedicated SQL pool
Quick peek
Open full term page
Analytics
premium
Dedicated SQL pool DWU
A data warehouse unit setting that controls performance for a dedicated SQL pool.
Analytics platform
intermediate
4 commands
Aliases: DWU
Quick peek
Open full term page
Analytics
premium
Dedicated SQL pool pause
Dedicated SQL pool pause stops compute resources for an Azure Synapse dedicated SQL pool so compute charges stop while the database storage remains available and billable.
Analytics platform
intermediate
4 commands
Aliases: pause dedicated SQL pool, Synapse SQL pool pause, pause SQL DW compute
Quick peek
Open full term page
Analytics
premium
Dedicated SQL pool resume
Dedicated SQL pool resume restarts compute for a paused Azure Synapse dedicated SQL pool so users and workloads can query the warehouse again and compute billing resumes.
Analytics platform
intermediate
4 commands
Aliases: resume dedicated SQL pool, Synapse SQL pool resume, start SQL DW compute
Quick peek
Open full term page
Analytics
complete
SQL pool DWU
Microsoft Learn describes Data Warehouse Units as the performance-level measure for dedicated SQL pool in Azure Synapse Analytics. DWUs, including compute-optimized cDWU levels, represent the blended compute, memory, and IO capacity available to the distributed data warehouse and can be changed to balance price and performance.
Azure Synapse dedicated SQL pool
intermediate
5 commands
Aliases: Data warehouse unit, DWU for dedicated SQL pool, cDWU, Synapse SQL pool performance level
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse Spark pool
A Synapse Spark pool is the workspace compute definition Azure Synapse uses to start Apache Spark sessions. It records node size, node count, autoscale behavior, runtime version, packages, and idle timeout so notebooks, Spark jobs, and pipelines get repeatable distributed processing.
Synapse Analytics
fundamentals
8 commands
Aliases: Apache Spark pool, Spark pool, Synapse Apache Spark pool, serverless Spark pool
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL CETAS
Synapse SQL CETAS means CREATE EXTERNAL TABLE AS SELECT. It creates external table metadata and exports the result of a T-SQL SELECT statement in parallel to files in Azure Storage or Azure Data Lake Storage Gen2 for later SQL or lake consumption.
Synapse Analytics
fundamentals
6 commands
Aliases: CREATE EXTERNAL TABLE AS SELECT, CETAS, Synapse CETAS, serverless SQL CETAS
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL external table
A Synapse SQL external table is database metadata that lets Synapse SQL query files stored outside the database, usually in Azure Storage or ADLS Gen2. It references an external data source, file format, and file location for governed SQL analytics.
Synapse Analytics
fundamentals
6 commands
Aliases: external table in Synapse, Synapse external table, SQL external table, external table over lake files
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL script
A Synapse SQL script is a saved T-SQL authoring artifact in Synapse Studio. Users create or import scripts in the Develop hub, connect them to a dedicated or serverless SQL pool, run queries, review tabular results, export output, and organize scripts into folders.
Synapse Analytics
fundamentals
5 commands
Aliases: SQL script in Synapse, Synapse Studio SQL script, T-SQL script artifact, Synapse query script
Quick peek
Open full term page
Analytics
learning-path-anchor
Databricks SQL warehouse
A Databricks SQL compute resource for interactive queries, dashboards, BI tools, and governed analytics workloads.
Databricks
intermediate
4 commands
Aliases: SQL warehouse, Databricks SQL compute, serverless SQL warehouse
Quick peek
Open full term page
Analytics
premium
Synapse SQL
Synapse SQL is the T-SQL analytics capability in Azure Synapse Analytics. It includes dedicated SQL pools for provisioned warehousing and serverless SQL pools for on-demand lake queries, letting teams analyze structured and semi-structured data through familiar SQL endpoints inside a Synapse workspace.
Synapse Analytics
intermediate
7 commands
Aliases: Synapse SQL engine, Azure Synapse SQL, Synapse serverless and dedicated SQL, SQL analytics in Synapse
Quick peek
Open full term page
Analytics
premium
Synapse SQL administrator
A Synapse SQL administrator is the Synapse RBAC role focused on serverless SQL access and SQL artifacts. It grants broad serverless SQL pool permissions plus create, read, update, and delete access to published SQL scripts, credentials, and linked services within a workspace.
Synapse Analytics
intermediate
6 commands
Aliases: Synapse SQL Administrator, Synapse SQL admin, SQL administrator in Synapse, Synapse SQL admin role
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workload group
A Synapse workload group is a dedicated SQL pool workload management object that reserves, caps, and grants resources for classified requests. It uses settings such as MIN_PERCENTAGE_RESOURCE, CAP_PERCENTAGE_RESOURCE, and request resource grant percentages to shape isolation, containment, concurrency, and execution behavior.
Synapse Analytics
fundamentals
5 commands
Aliases: workload group in Synapse, dedicated SQL pool workload group, CREATE WORKLOAD GROUP, Synapse workload isolation group
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse workload classifier
A Synapse workload classifier is a dedicated SQL pool workload management rule that assigns incoming requests to a workload group and importance level. It can classify by user or role, query label, session context, and time window so different workloads receive different resource behavior.
Synapse Analytics
fundamentals
3 commands
Aliases: workload classifier in Synapse, dedicated SQL pool classifier, CREATE WORKLOAD CLASSIFIER, Synapse classification rule
Quick peek
Open full term page
Analytics
premium
External table
An External table is a SQL table definition whose data is stored outside the database, commonly in Azure Storage or Azure Data Lake Storage. Teams use it to let SQL users query lake files or remote data through familiar table names while the actual data remains in external storage. It is not a managed internal database table, a copy of the data, a storage access policy, or proof that the external files are optimized, fresh, or secure.
Synapse SQL and data virtualization
intermediate
6 commands
Aliases: Synapse external table, SQL external table, PolyBase external table
Quick peek
Open full term page
Analytics
premium
PolyBase
PolyBase lets a SQL engine work with files stored outside the database, especially in Azure Storage or Azure Data Lake Storage. In Azure Synapse dedicated SQL pool, teams use it to define external data sources, file formats, and external tables, then load data into warehouse tables with T-SQL. It is useful when data lands in a lake first and the warehouse needs a scalable way to read or ingest it. PolyBase is not a pipeline by itself; it is the SQL-side external data access pattern.
Synapse Analytics
advanced
6 commands
Aliases: polybase, PolyBase
Quick peek
Open full term page
Analytics
premium
Distribution column
A distribution column is the column used by a hash-distributed dedicated SQL pool table to assign rows across distributions for parallel query processing.
Dedicated SQL pool
intermediate
4 commands
Aliases: Synapse distribution column, hash distribution column, dedicated SQL pool distribution column, distributed table column
Quick peek
Open full term page
Analytics
premium
Hash distribution
Hash distribution is spreading rows across compute distributions by hashing a chosen distribution column in an Azure Synapse dedicated SQL pool.
Synapse dedicated SQL pool
intermediate
4 commands
Aliases: Synapse hash distribution, dedicated SQL pool hash distribution, Hash distribution, hash-distribution
Quick peek
Open full term page
Analytics
premium
Hash-distributed table
Hash-distributed table is a dedicated SQL pool table whose rows are assigned to distributions using a hash value calculated from one or more distribution columns.
Synapse dedicated SQL pool
intermediate
4 commands
Aliases: hash distributed table, Synapse HASH table, Hash-distributed table, hash-distributed-table
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse notebook
A Synapse notebook is a web authoring surface in Azure Synapse Analytics for live code, visualizations, and explanatory text. It is commonly used with Apache Spark for data preparation, exploration, machine learning, and repeatable transformations that can run interactively or from pipelines.
Synapse Analytics
fundamentals
8 commands
Aliases: Azure Synapse notebook, Synapse Spark notebook, Synapse Analytics notebook, notebook artifact in Synapse
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse pipeline
A Synapse pipeline is a data-driven workflow in Azure Synapse Analytics that groups activities for moving, transforming, and orchestrating data. It can run manually or from triggers, pass parameters between activities, and record pipeline and activity run history for monitoring.
Synapse Analytics
fundamentals
8 commands
Aliases: Azure Synapse pipeline, Synapse Analytics pipeline, pipeline in Synapse, Synapse data integration pipeline
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse private endpoint
A Synapse private endpoint is an Azure Private Link network interface that lets clients reach a Synapse workspace over a private IP address instead of the public internet. It is used with workspace development, SQL, and private-link patterns to reduce exposure and control network access.
Synapse Analytics
advanced
8 commands
Aliases: Azure Synapse private endpoint, Synapse workspace private endpoint, Private Link for Synapse, private endpoint for Synapse workspace
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse role
A Synapse role is a workspace-level RBAC permission set that controls what users, groups, managed identities, and service principals can do inside Azure Synapse Analytics. Synapse RBAC governs workspace artifacts and actions, while Azure RBAC controls management of the Azure resources.
Synapse Analytics
intermediate
8 commands
Aliases: Azure Synapse role, Synapse RBAC role, Synapse workspace role, Synapse access role
Quick peek
Open full term page
Analytics
verified
Result set cache
Microsoft Learn describes result set caching in Azure Synapse dedicated SQL pool as a feature that stores query results in the user database for reuse. When a repeated query can use cached results, it avoids recomputation, reduces compute use, and does not consume concurrency slots.
Synapse Analytics
intermediate
7 commands
Aliases: result set caching, Synapse result set cache, SET RESULT_SET_CACHING, cached query results, dedicated SQL pool result cache
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse Link
A analytics platform concept in Synapse Analytics that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Synapse Analytics
advanced
7 commands
Aliases: Azure Synapse Link, Synapse Link, Synapse Link for SQL, link connection, near real-time analytics, synapse Link, synapse link, synapse-link
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse result-set cache
Synapse result-set cache is a dedicated SQL pool feature that persists eligible query results in the user database so repeated executions can return from cache instead of recomputing. It improves response time, reduces compute usage, and lets cached queries avoid consuming concurrency slots.
Synapse Analytics
fundamentals
7 commands
Aliases: Azure Synapse result set caching, result set cache in dedicated SQL pool, Synapse SQL result-set cache, dedicated SQL pool cached results
Quick peek
Open full term page
Analytics
template-specs-upgraded
Round-robin distribution
Dedicated SQL pool distribution choice that spreads rows evenly and randomly for fast loading and simple staging.
Synapse Analytics
intermediate
6 commands
Aliases: round-robin distributed, Synapse round-robin distribution, dedicated SQL pool round robin, random table distribution, round-robin data distribution
Quick peek
Open full term page
Analytics
template-specs-upgraded
Round-robin table
A dedicated SQL pool table whose rows are spread evenly and randomly across distributions, commonly for staging.
Synapse Analytics
fundamentals
6 commands
Aliases: round-robin distributed table, Synapse round-robin table, dedicated SQL pool staging table, ROUND_ROBIN table, randomly distributed table
Quick peek
Open full term page
Analytics
verified
Replicated table
A replicated table in Azure Synapse dedicated SQL pool stores a full copy of a small table on each compute node. It reduces data movement during joins and aggregations, improving query performance when the table is relatively small, stable, and not frequently updated.
Synapse Analytics
fundamentals
5 commands
Aliases: Synapse replicated table, DISTRIBUTION = REPLICATE, replicated dimension table, dedicated SQL pool replicated distribution
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse distribution
A analytics platform concept in Synapse Analytics that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Synapse Analytics
fundamentals
5 commands
Aliases: Azure Synapse distribution, Synapse distribution, dedicated SQL pool distribution, hash distribution, replicated table, round robin distribution, synapse distribution, synapse-distribution
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse materialized view
A Synapse materialized view is a dedicated SQL pool object that stores the result of a T-SQL query and refreshes as base tables change. The optimizer can use it automatically for eligible joins and aggregations, improving response time without changing user queries.
Synapse Analytics
advanced
5 commands
Aliases: Azure Synapse materialized view, dedicated SQL pool materialized view, CREATE MATERIALIZED VIEW AS SELECT, Synapse SQL materialized view
Quick peek
Open full term page
Analytics
template-specs-upgraded
Result set caching
Microsoft Learn describes result set caching in Azure Synapse dedicated SQL pool as a database and session feature that stores eligible query results for repeated use. Matching queries can read persisted cached results instead of recomputing, reducing compute work, resource usage, and concurrency-slot pressure.
Synapse dedicated SQL pool
intermediate
5 commands
Aliases: result set caching, Synapse result set caching, dedicated SQL pool result cache, cached query results
Quick peek
Open full term page
Analytics
premium field-manual
Materialized view in Synapse
A materialized view in Synapse is a precomputed table-like query result in Synapse dedicated SQL pool that can improve repeated analytical queries. Teams use it when warehouse workloads repeatedly aggregate or join data and need faster response with managed storage tradeoffs. In plain English, it gives operators a named control for query acceleration for common reporting patterns with explicit design and refresh considerations instead of leaving the decision hidden in a portal setting, script, or deployment file. Treat it as production-ready only when the owner, dependencies, permission boundary, monitoring signal, and rollback evidence are clear.
Azure Synapse dedicated SQL pool
intermediate
4 commands
Aliases: Materialized view in Synapse, Synapse materialized view, dedicated SQL pool materialized view, CREATE MATERIALIZED VIEW AS SELECT, Azure Synapse Analytics dedicated SQL pool, Azure Synapse dedicated SQL pool
Quick peek
Open full term page
Databases
premium
Azure SQL elastic pool
Azure SQL elastic pool lets multiple Azure SQL databases on one logical server share a set of resources at a set price for variable usage patterns.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure SQL elastic pool, SQL elastic pool, eDTU pool, elastic pool, pooled databases
Quick peek
Open full term page
Analytics
premium
Serverless SQL pool
Serverless SQL pool in Azure Synapse Analytics lets users query data in the lake with T-SQL without provisioning dedicated SQL compute. It stores only metadata objects in databases, supports SELECT, CETAS, views, credentials, users, and object permissions, and charges based on data processed by queries.
Azure Synapse Analytics
fundamentals
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
complete
SQL elastic pool DTU
SQL elastic pool DTU means an Azure SQL elastic pool sized with the DTU purchasing model.
Data platform
intermediate
5 commands
Aliases: DTU elastic pool, Azure SQL DTU pool, eDTU pool, SQL elastic pool using DTUs
Quick peek
Open full term page
Databases
complete
SQL elastic pool vCore
SQL elastic pool vCore means an Azure SQL elastic pool sized with the vCore purchasing model.
Data platform
intermediate
5 commands
Aliases: vCore elastic pool, Azure SQL vCore pool, SQL elastic pool using vCores, shared vCore pool
Quick peek
Open full term page
Analytics
learning-path-anchor
Synapse SQL on-demand
Synapse SQL on-demand is the serverless SQL pool model in Azure Synapse Analytics. It lets teams run T-SQL queries over data in the lake without provisioning dedicated warehouse capacity, storing only metadata objects while using external data sources, views, functions, and security objects.
Synapse Analytics
fundamentals
6 commands
Aliases: SQL on-demand, Synapse serverless SQL, serverless SQL in Synapse, built-in serverless SQL pool
Quick peek
Open full term page
Analytics
premium
Serverless SQL external table
A serverless SQL external table in Azure Synapse SQL is a metadata object that references files in Azure Storage or Azure Data Lake Storage. Serverless SQL pools use native external tables to read external data, map columns, apply supported file formats, and support CETAS export patterns.
Azure Synapse Analytics
intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
learning-path-anchor
Cosmos DB dedicated gateway
Azure Cosmos DB dedicated gateway is provisioned server-side compute that fronts an account and enables the integrated cache for supported NoSQL workloads.
Azure Cosmos DB
fundamentals
3 commands
Aliases: No aliases yet
Quick peek
Open full term page
Analytics
field-manual-complete
Synapse data explorer pool
A analytics platform concept in Synapse Analytics that helps teams move, transform, query, and govern data at scale with clearer ownership, safety, and operational context.
Synapse Analytics
fundamentals
6 commands
Aliases: Azure Synapse data explorer pool, Data Explorer pool, Kusto pool in Synapse, Synapse Kusto pool, Synapse data explorer pool, legacy Synapse Data Explorer, synapse data explorer pool, synapse-data-explorer-pool
Quick peek
Open full term page
Databases
premium
Dedicated gateway
Dedicated gateway is documented by Microsoft as part of the Azure Cosmos DB area in Azure.
Azure Cosmos DB
intermediate
11 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL Database
Azure SQL Database is a fully managed relational database service in Azure that provides SQL Server-compatible engines as single databases, elastic pools, and serverless or provisioned compute choices. Microsoft Learn presents it as platform as a service with built-in availability, backups, patching, scaling, and security integration.
Database
intermediate
5 commands
Aliases: Azure SQL DB, Azure SQL Database, Azure SQL pooled database, Azure SQL single database, SQL Database
Quick peek
Open full term page
Databases
premium
Azure SQL elastic job
Azure SQL elastic jobs schedule and run Transact-SQL scripts across one or many Azure SQL databases, including target groups across servers, pools, and subscriptions.
Azure SQL Database
fundamentals
5 commands
Aliases: Azure Elastic Jobs, Azure SQL elastic job, SQL elastic job agent, elastic job agent, elastic jobs
Quick peek
Open full term page
Databases
premium
Dedicated container throughput
A database capability or setting in Azure Cosmos DB that helps teams store, query, scale, secure, and recover application data with clearer ownership, safety, and operational context.
Azure Cosmos DB
intermediate
5 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Instance pool
Instance pool controls how multiple small Azure SQL Managed Instances share capacity for migrations that need instance-level compatibility with lower per-instance overhead. Teams see it in azure sql managed instance pools, virtual clusters. It is not an Azure SQL elastic pool, a VM scale set, a Hyperscale database, or a shared SQL Server instance; confusing them can create capacity exhaustion, subnet design mistakes. Use the term when reviewing access, monitoring, cost, recovery, or performance. It keeps architects, operators, security reviewers, and support teams focused on the same setting, resource, or behavior.
Azure SQL Managed Instance
Intermediate
5 commands
Aliases: SQL Managed Instance pool, Azure SQL instance pool, managed instance pool, SQL MI instance pool
Quick peek
Open full term page
Databases
premium
Azure SQL service objective
An Azure SQL service objective is the named performance level or SKU selected for an Azure SQL Database or elastic pool, defining resource limits, capabilities, and price within the chosen purchasing model.
Azure SQL Database
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Azure SQL zone redundancy
Azure SQL zone redundancy places database replicas or storage across multiple availability zones in a supported region to improve resilience against datacenter-level failures.
Azure SQL Database
intermediate
4 commands
Aliases: No aliases yet
Quick peek
Open full term page
Databases
premium
Elastic pool
An elastic pool in Azure SQL Database lets multiple databases on the same logical server share a set amount of compute and storage resources at a predictable price.
Azure SQL
fundamentals
4 commands
Aliases: Azure SQL elastic pool, SQL elastic pool
Quick peek
Open full term page
Containers
learning-path-anchor
System node pool
A system node pool is the AKS worker pool that keeps the cluster itself functioning. It hosts core Kubernetes and AKS add-on pods such as DNS, networking agents, metrics, and connectivity components. You can technically run application pods there, but experienced teams avoid that because noisy workloads can starve the services that make the...
Azure Kubernetes Service
intermediate
4 commands
Aliases: AKS system pool, system mode node pool, AKS platform node pool, kube-system node pool
Quick peek
Open full term page
No glossary terms matched that search.
Try a service name, acronym, command group, or category such as RBAC , az group , App Service , Application Insights , Databases , or Azure AI Search .
Clear filters and show matches
Reset search