Search Azure terms

Analytics learning-path-anchor Databricks table A governed Databricks data object, commonly managed, external, or foreign, queried through Unity Catalog and optimized for analytics. Databricks fundamentals 4 commands Aliases: Unity Catalog table, Delta table in Databricks, Databricks managed table Quick peek Open full term page

Storage premium Access tier An access tier is the storage temperature for blob data. Hot is for frequent access, cool and cold are for less frequent access, and archive is cheapest to store but slowest to retrieve. Choose tiers based on real lifecycle and retrieval needs. Blob Storage fundamentals 5 commands Aliases: No aliases yet Quick peek Open full term page

Management and Governance premium Azure savings plan An Azure savings plan provides discounted pricing on eligible compute usage when you commit to an hourly spend for one or three years. Cost Management fundamentals 5 commands Aliases: Azure savings plan, Azure savings plans, compute savings plan, savings plan for compute Quick peek Open full term page

Analytics premium Kusto materialized view Kusto materialized view is a managed aggregation over a source table or another materialized view that keeps a continuously updated result for faster queries. Kusto query optimization Advanced 5 commands Aliases: ADX materialized view, Kusto MV, materialized view in Azure Data Explorer Quick peek Open full term page

Management and Governance premium Advisor score Advisor score is an Azure Advisor percentage score that summarizes how closely resources follow recommended best practices. In everyday Azure work, teams use it to measure improvement across cost, reliability, security, performance, and operational excellence recommendations. The useful evidence is overall score, category score, impacted resource count, potential score increase, date, aggregation level, and filtered Azure Advisor fundamentals 4 commands Aliases: Azure Advisor score, best practices score, cloud optimization score Quick peek Open full term page

Management and Governance premium Azure Advisor Azure Advisor is the Azure recommendation service that reviews resource configuration and usage signals, then suggests best-practice actions for healthier cloud deployments. In Azure, teams encounter it when platform teams need a prioritized backlog for cost savings, reliability fixes, security hardening, performance improvements, and operational excellence. The useful question is what behavior it proves, who Optimization fundamentals 4 commands Aliases: Advisor, Azure Advisor recommendations, Advisor score Quick peek Open full term page

Databases premium Azure SQL vCore model The Azure SQL vCore purchasing model lets customers independently choose compute, storage, service tier, and hardware configuration for Azure SQL Database workloads. Azure SQL Database intermediate 4 commands Aliases: No aliases yet Quick peek Open full term page

Management and Governance premium Chargeback Chargeback bills internal teams or business units for their Azure consumption. Cost Management fundamentals 4 commands Aliases: No aliases yet Quick peek Open full term page

Databases premium MySQL storage autogrow MySQL storage autogrow means a MySQL Flexible Server setting that automatically increases storage when used capacity approaches the configured limit. You see it when teams protect databases from running out of storage during growth, imports, reporting, migrations, or seasonal demand. Think of it as automatic storage expansion, not automatic cost or performance optimization. It matters because the setting changes how teams design, secure, operate, and troubleshoot the workload. Before changing it in production, know the owner, dependency, evidence, expected result, and rollback path. Azure Database for MySQL advanced 4 commands Aliases: No aliases yet Quick peek Open full term page

Storage premium Azure Storage Discovery Azure Storage Discovery is a fully managed service that provides enterprise-wide visibility into Azure Blob Storage and Azure Data Lake Storage estates for analysis, optimization, security, and operations. Storage platform intermediate 3 commands Aliases: No aliases yet Quick peek Open full term page

Databases premium Composite index an Azure Cosmos DB indexing policy entry that combines multiple item properties in a defined order so certain filters and multi-property sorts run efficiently Azure Cosmos DB Intermediate 3 commands Aliases: No aliases yet Quick peek Open full term page

Management and Governance premium Cost recommendation Cost recommendation is an Azure glossary term for an Azure Advisor or Cost Management suggestion that identifies a likely way to reduce spend or improve cost efficiency. In practice, it helps teams reason about turning usage and configuration telemetry into actionable savings opportunities such as right-sizing, cleanup, reservations, or commitment planning using live Azure evidence, documented ownership, and Microsoft Learn guidance. It should be reviewed through security, reliability, operations, cost, and performance lenses before production changes. Azure Advisor intermediate 3 commands Aliases: No aliases yet Quick peek Open full term page

Databases complete SQL compatibility level Microsoft Learn explains that compatibility level controls database behavior for SQL Server, Azure SQL Database, and Azure SQL Managed Instance. It can be viewed or changed with Transact-SQL, requires ALTER permission on the database, and should be evaluated because changes can affect applications and query optimization. Data platform intermediate 6 commands Aliases: database compatibility level, compatibility_level, SQL Server compatibility level, Azure SQL compatibility level 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

Storage complete Storage account SKU A storage account SKU is the account’s selected service tier and redundancy option, such as Standard_LRS, Standard_ZRS, Standard_GRS, or Premium_LRS. It influences durability, availability, performance characteristics, regional support, and pricing for the account. Engineers review it before creation, migration, and cost optimization. Storage accounts intermediate 5 commands Aliases: Storage account SKU, storage account sku, storage-account-sku, storage SKU, storage account tier, storage redundancy SKU Quick peek Open full term page

Management and Governance top-250-pre130-priority-upgraded Advisor recommendation Advisor recommendation is a personalized Azure Advisor action that suggests how to improve reliability, security, performance, cost, or operational excellence. In everyday Azure work, teams use it to find idle resources, missing redundancy, performance risks, upgrade needs, or governance issues before they become bigger problems. The useful evidence is category, impacted resource, impact level, recommendation Azure Advisor intermediate 4 commands Aliases: Azure Advisor recommendation, best practice recommendation, Advisor optimization item 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

Management and Governance complete Cost Analysis Cost Analysis is an Azure glossary term for the Cost Management workspace for exploring Azure spending by scope, service, resource, tag, time period, meter, and trend. In practice, it helps teams reason about understanding where money is going, why it changed, and which owner should respond before budgets or forecasts are missed using live Azure evidence, documented ownership, and Microsoft Learn guidance. It should be reviewed through security, reliability, operations, cost, and performance lenses before production changes. Cost Management beginner 3 commands Aliases: Azure Cost Analysis, Cost Management Cost Analysis Quick peek Open full term page