Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Azure > Azure Data Terms 01 > Flashcards

Azure Data Terms 01 Flashcards

(107 cards)

Start Studying
1
Q

ACID

A

Atomicity, consistency, isolation, durability. A set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

AES

A

Advanced Encryption Standard. The encryption standard used for Transparent data encryption (TDE) in Microsoft SQL Server (all flavors).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

BSON

A

Binary JSON. A binary-encoded serialization of JSON-like documents.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

DMS

A

Azure Database Migration Service.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

DPR

A

Supplier data protection requirements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DQS

A

Data Quality Services. The data quality tool for Microsoft SQL Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

DTU

A

Database transaction unit. On Microsoft Azure, a way of measuring computing resources for pricing, an alternative to serverless compute and provisioned compute pricing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

DWU

A

Data warehouse unit. In Azure Synapse Analytics, a measure based on CPU, memory, and I/O values.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

EDA

A

Exploratory data analysis. An approach of analyzing data sets to summarize their main characteristics, often using statistical graphics and other data visualization methods. One of the best practices in MLOps.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

GRS

A

Geo-redundant storage. A redundancy option in Azure Storage in which there are three copies of the data in the primary region using locally-redundant storage (LRS) and another three copies in a second region also using LRS. The other options are LRS, zone-redundant storage (ZRS), and geo-zone-redundant storage (GZRS) which is the same as GRS except that the data in the primary region uses ZRS.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

ISV

A

Independent software vendor.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

LRS

A

Locally-redundant storage. A redundancy option in Azure Storage in which there are three copies of the data within the same datacenter. The other options are zone-redundant storage (ZRS), geo-redundant storage (GRS), and geo-zone-redundant storage (GZRS).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

MDS

A

Master Data Services. The MDM tool for Microsoft SQL Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

MLOps

A

Machine Learning Operations. The Machine Learning analog of DevOps, as used in Azure Machine Learning (Azure ML).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

MPP

A

Massively parallel processing. The coordinated processing of a program by multiple processors working on different parts of the program. Each processor has its own operating system and memory. MPP speeds the performance of huge databases that deal with massive amounts of data. Contrast with Symmetric multiprocessing (SMP).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

MQL

A

MongoDB Query Language. The query langugage used for the MongoDB API in Azure Cosmos DB.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

MVCC

A

Multi-version concurrency control. A feature of PostgreSQL.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

ORC

A

Optimized Row Columnar. A highly efficient file format used for Apache Hive data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

RDP

A

Remote Desktop Protocol.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

RU

A

Request unit. The unit of measure for pricing in Azure Cosmos DB.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

SID

A

Security identifier. A unique value that is used to identify any security entity that the Windows operating system can authenticate. A security entity can be a security principal - a user account, a computer account or a process started by those accounts - or it can be a security group.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

SLO

A

Service Level Objective. A standardized combination of measures like CPU, memory, and I/O used for pricing tiers.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

SMP

A

Symmetric multiprocessing. A multiprocessor computer hardware and software architecture where two or more identical processors are connected to a single, shared main memory, have full access to all input and output devices, and are controlled by a single operating system instance that treats all processors equally. Also called “shared-memory multiprocessing”. Contrast with massively parallel processing (MPP).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

SQL-MI

A

Azure SQL Managed Instance.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
SSPA
Supplier Security and Privacy Assurance. Microsoft's program for ensuring that vendors adhere to data security and privacy standards.
26
TDE
Transparent data encryption. The feature in Microsoft SQL Server (all flavors) that encrypts data at rest.
27
TDS
Tabular Data Stream. An application layer protocol used to transfer data between a database server and a client.
28
TDSP
Team Data Science Process. An agile, iterative data science process.
29
Adjacency list
In graph theory and computer science, a collection of unordered lists used to represent a finite graph. Each unordered list within an adjacency list describes the set of neighbors of a particular vertex in the graph.
30
Adjacency matrix
In graph theory and computer science, an adjacency matrix is a square matrix used to represent a finite graph. The elements of the matrix indicate whether pairs of vertices are adjacent or not in the graph.
31
Advanced Encryption Standard (AES)
The encryption standard used for Transparent data encryption (TDE) in Microsoft SQL Server (all flavors).
32
Apache Cassandra API
The API for column-family storage in Azure Cosmos DB.
33
Apache Gremlin API
The API for graph databases in Azure Cosmos DB.
34
Apache Hive
A distributed, fault-tolerant data warehouse system that enables analytics at a massive scale.
35
Atomicity
In ACID, the guarantee that each transaction is treated as a single unit that either succeeds completely or fails completely, even if it's made up of multiple statements.
36
Atomicity, consistency, isolation, durability (ACID)
A set of properties of database transactions intended to guarantee data validity despite errors, power failures, and other mishaps.
37
Batch layer
In the Lambda architecture, the layer that precomputes results using a distributed processing system that can handle very large quantities of data. The batch layer aims at perfect accuracy by being able to process all available data when generating views.
38
Binary JSON (BSON)
Binary JSON. A binary-encoded serialization of JSON-like documents.
39
Blocking transformation
In SQL Server Integration Services (SSIS), a data flow task that stalls the process, such as a large sort operation where there is not enough memory.
40
Card
In Microsoft Power BI, a report visual that focuses on displaying a single value.
41
Columnstore
Data that is logically organized as a table with rows and columns, and physically stored in a column-wise data format. Contrast with rowstore.
42
Columnstore index
An index used for storing and querying large data warehouse fact and dimension tables.
43
Compute node
In Azure Synapse Analytics, a node that works on a chunk of data. In Massively Parallel Processing (MPP), this is called a worker node.
44
Consistency
In ACID, the guarantee that a transaction can only bring the database from one consistent state to another, preserving database invariants like primary and foreign keys. Consistency also guarantees that after a successful write of a record, any read request immediately receives the latest value of the record.
45
Consumer group
In data stream processing, an isolated view over a data stream that can be read at its own pace and starting at its own offset.
46
Control flow
In SQL Server Integration Services (SSIS), the ordered set of tasks to be performed. Contrast with a data flow, which is a specific task in the control flow that transforms data.
47
Control node
In Azure Synapse Analytics, the node that orchestrates multiple compute nodes. In Massively Parallel Processing (MPP), this is called a header node.
48
Data flow
In SQL Server Integration Services (SSIS), a specific task in the control flow that transforms data.
49
Data mart
A subset of a data warehouse focused on a particular line of business, department, or subject area. This may appear on the serving layer.
50
Data Quality Services (DQS)
The data quality tool for Microsoft SQL Server.
51
Data virtualization
A unified, virtual data access layer built on top of many data sources, allowing the data to be accessed without moving it to a central repository. One example is PolyBase for SQL Server.
52
Data warehouse unit (DWU)
In Azure Synapse Analytics, a measure based on CPU, memory, and I/O values.
53
Database transaction unit (DTU)
On Microsoft Azure, a way of measuring computing resources for pricing, an alternative to serverless compute and provisioned compute pricing.
54
Dedicated SQL pool
In Azure Synapse Analytics, a collection of analytic resources that are provisioned when using Synapse SQL.
55
Delta Lake
An open-source storage layer that adds support to Data Lake Storage for transactional consistency.
56
DirectQuery
For Microsoft Power BI and Microsoft Analysis Services, a method of connecting directly to the data source without importing data.
57
Durability
In ACID, the guarantee that once a transaction has been committed, it will remain committed even in the case of a system failure.
58
Elastic pool
A model for Azure SQL Database in which one has several databases sharing resources in the same pool.
59
Event
In the context of Streaming Data, a chunk of raw information. Synonym for message.
60
Event hub capture
A feature of Azure Event Hubs that offloads incoming events to a cloud storage location as soon as they arrive, as well as passing them down the stream pipeline.
61
Exploratory data analysis (EDA)
An approach of analyzing data sets to summarize their main characteristics, often using statistical graphics and other data visualization methods. One of the best practices in MLOps.
62
Functional partitioning
A strategy in which data is aggregated according to how it is used by each bounded context in the system.
63
Geo-redundant storage (GRS)
A redundancy option in Azure Storage in which there are three copies of the data in the primary region using locally-redundant storage (LRS) and another three copies in a second region also using LRS. The other options are LRS, zone-redundant storage (ZRS), and geo-zone-redundant storage (GZRS) which is the same as GRS except that the data in the primary region uses ZRS.
64
Header node
In Massively Parallel Processing (MPP), the node that orchestrates multiple worker nodes. In Azure Synapse Analytics, this is called a control node.
65
Horizontal partitioning
Also called sharding, a strategy in which each partition or shard holds a subset of the rows.
66
Hypervisor
Computer software, firmware or hardware that creates and runs virtual machines. Similar to an emulator. Also called a virtual machine monitor (VMM) or virtualizer.
67
Information retrieval
The process of using Machine Learning models to extract useful information from unstructured data.
68
Isolation
In ACID, the guarantee that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially.
69
Kappa architecture
Kappa architecture is a data processing architecture that is designed to provide a scalable, fault-tolerant, and flexible system for processing large amounts of data in real time. It was developed as an alternative to Lambda architecture.
70
Lambda architecture
A data-processing architecture designed to handle massive quantities of data by taking advantage of both batch and stream-processing methods. In many cases, it's being replaced with kappa architecture.
71
Locally-redundant storage (LRS)
A redundancy option in Azure Storage in which there are three copies of the data within the same datacenter. The other options are zone-redundant storage (ZRS), geo-redundant storage (GRS), and geo-zone-redundant storage (GZRS).
72
Machine Learning Operations (MLOps)
The Machine Learning analog of DevOps, as used in Azure Machine Learning (Azure ML).
73
Massively parallel processing (MPP)
The coordinated processing of a program by multiple processors working on different parts of the program. Each processor has its own operating system and memory. MPP speeds the performance of huge databases that deal with massive amounts of data. Contrast with Symmetric multiprocessing (SMP).
74
Master Data Services (MDS)
The MDM tool for Microsoft SQL Server.
75
Message
In the context of Streaming Data, a chunk of raw information. Synonym for event.
76
MLflow
An open source platform for the machine learning lifecycle. Site.
77
MongoDB Query Language (MQL)
The query langugage used for the MongoDB API in Azure Cosmos DB.
78
Multi-version concurrency control (MVCC)
A feature of PostgreSQL.
79
Optimized Row Columnar (ORC)
A highly efficient file format used for Apache Hive data.
80
Partition pruning
A data querying optimization in which partitions are skipped if they are known not to have matching values.
81
PL-PGSQL
The query language for PostgreSQL.
82
PolyBase
A data virtualization feature for SQL Server.
83
Predicate pushdown
A data querying optimization in which rows are filtered at the source to reduce the amount of data sent to the requestor. Projection pushdown is the equivalent for only sending the needed columns.
84
Producer
In the context of streaming data, something that produces events/messages, such as a mobile device, production line, or application.
85
Projection pushdown
A data querying optimization in which only the needed columns are sent to the requestor. Predicate pushdown is the equivalent for only sending the needed rows.
86
Request unit (RU)
The unit of measure for pricing in Azure Cosmos DB.
87
Rowgroup
A group of rows that are compressed into columnstore format at the same time. Usually this is the maximum number of rows in a rowgroup, 1,048,576.
88
Rowstore
Data that's logically organized as a table with rows and columns, and physically stored in a row-wise data format as is usually the case in a relational database. Contrast with columnstore.
89
Schema on read
A system in which a schema is created only when reading the data, as in NoSQL. Contrast with schema on write.
90
Schema on write
A system in which a schema is created before writing into a database, as in SQL. Contrast with schema on read.
91
Security identifier (SID)
A unique value that is used to identify any security entity that the Windows operating system can authenticate. A security entity can be a security principal - a user account, a computer account or a process started by those accounts - or it can be a security group.
92
Semantic model
In OLAP, a conceptual model that describes the meaning of the data elements it contains. Not to be confused with semantic modeling, which is a process in text analytics.
93
Service Level Objective (SLO)
A standardized combination of measures like CPU, memory, and I/O used for pricing tiers.
94
Serving layer
In the Lambda architecture, the layer that stores output from the batch and speed layers and responds to ad-hoc queries by returning precomputed views or building views from the processed data.
95
Sharding
Also called horizontal partitioning, a strategy in which each partition or shard holds a subset of the rows.
96
Speed layer
In the Lambda architecture, the layer that processes data streams in real time and without the requirements of fix-ups or completeness. This layer sacrifices throughput as it aims to minimize latency by providing real-time views into the most recent data.
97
Supplier Security and Privacy Assurance (SSPA)
Microsoft's program for ensuring that vendors adhere to data security and privacy standards.
98
Symmetric multiprocessing (SMP)
A multiprocessor computer hardware and software architecture where two or more identical processors are connected to a single, shared main memory, have full access to all input and output devices, and are controlled by a single operating system instance that treats all processors equally. Also called "shared-memory multiprocessing". Contrast with massively parallel processing (MPP).
99
Tabular Data Stream (TDS)
An application layer protocol used to transfer data between a database server and a client.
100
Tabular model
Microsoft Analysis Services, a database that runs in-memory or in DirectQuery mode, connecting to data from back-end relational data sources.
101
Team Data Science Process (TDSP)
An agile, iterative data science process.
102
Time window aggregation
In data stream processing, a method for aggregating data based on chunks of time which may overlap or vary in duration depending on the method. In Azure Stream Analytics, the options are tumbling window, hopping window, sliding window, and session window.
103
Transparent data encryption (TDE)
The feature in Microsoft SQL Server (all flavors) that encrypts data at rest.
104
U-SQL
A language that combines declarative SQL with imperative C# for processing unstructured data by applying schema on read and inserting custom logic and UDFs.
105
Vertical partitioning
A strategy in which each partition holds a subset of the fields/columns.
106
Watermark
In data stream processing, a technique to deal with late-arriving events by discarding events that arrive too long after they were produced.
107
Worker node
In Massively Parallel Processing (MPP), a node that works on a chunk of data. In Azure Synapse Analytics, this is called a compute node.

Azure (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions