Term 121
Sort key
A sort key is a field or attribute used to determine the order in which data items are arranged within a database or storage system, often in combination with a partition key.
Acronym study
Terms 121–136 of 136 DP-900 acronyms and key terms. Each entry includes a plain-English definition and a link to the full 800-word glossary page with exam context and practice questions.
Term 121
A sort key is a field or attribute used to determine the order in which data items are arranged within a database or storage system, often in combination with a partition key.
Term 122
A Spark pool is a cloud-based cluster of computing resources that allows you to run Apache Spark analytics and data processing workloads on demand.
Term 123
SQL Managed Instance is a cloud database service from Azure that gives you most of the features of a full SQL Server instance without you having to manage the underlying hardware or software patches.
Term 124
SQL Server on Azure VM is a cloud service that lets you run Microsoft SQL Server database software on a virtual machine in Microsoft Azure, giving you full control over the database environment while Azure handles the underlying hardware.
Term 125
A Storage Gateway is a service or device that connects on-premises IT environments to cloud storage, making cloud storage feel like a local drive or backup target.
Term 126
A stored procedure is a pre-written collection of SQL statements saved in a database that can be executed as a single unit to perform specific tasks, like updating records or generating reports.
Term 127
Stream processing is a data processing method that continuously analyzes and acts on data in real time as it arrives, rather than storing it first and processing it later.
Term 128
Structured data is information that is organized in a predefined format, typically in rows and columns, making it easy to search, process, and analyze by computers.
Term 129
A table is a structured collection of data organized into rows and columns, used in databases and spreadsheets to store and manage information efficiently.
Term 130
A trace is a record of the path and timing of a request or operation as it moves through components in a system, used to monitor performance and troubleshoot issues.
Term 131
Transactional data is information that captures a specific event or exchange, such as a sale, a payment, or a system log entry, and is recorded in a database or log system.
Term 132
A specialized hardware or virtual device used to securely and efficiently migrate large volumes of data between storage systems, often across different environments or geographic locations, without tying up production network bandwidth.
Term 133
In Azure data services, a trigger is a predefined automatic action that initiates a process when a specific event occurs, such as data arriving or a schedule being met.
Term 134
Unstructured data is information that does not have a predefined data model or is not organized in a predefined manner, making it difficult for traditional databases to read and process.
Term 135
An uptime check is a monitoring test that verifies whether a system or service is running and accessible over a network.
Term 136
A view is a saved query in a database that acts like a virtual table, letting you see specific data without storing it separately.