Azure Data Fundamentals Flashcards

1
Q

Data Classification Types

A

structured, semi-structured, or unstructured

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

Structured data

A

1) typically tabular data that is represented by rows and columns in a database.
2) Databases that hold tables in this form are called relational databases
3)

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

Semi-structured data

A

1) information that doesn’t reside in a relational database but still has some structure to it.
2) Examples include documents held in JavaScript Object Notation (JSON) format
3) Other forms: key-value stores (similar to a relational table, except that each row can have any number of columns) and graph databases (store and query information about complex relationships. A graph contains nodes (information about objects), and edges (information about the relationships between objects))

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

unstructured data

A

audio and video files, and binary data files might not have a specific structure

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

Storage of structured data

A

typically stored in a relational database such as SQL Server or Azure SQL Database.

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

Storage of unstructured data

A

use Azure Blob storage (Blob is an acronym for Binary Large Object)

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

Storage of semi-structured data

A

Azure Cosmos DB

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

Data processing solutions categories

A

analytical systems, and transaction processing systems

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

analytical system

A

1) designed to support business users who need to query data and gain a big picture view of the information held in a database
2) capturing raw data, and using it to generate insights
3) data ingestion, data transformation, data querying, and data visualization

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

transactional system

A

1) records transactions
2) often high-volume, sometimes handling many millions of transactions in a single day. The data being processed has to be accessible very quickly. The work performed by transactional systems is often referred to as Online Transactional Processing (OLTP)

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

Normalization

A

1) process of organizing data in a database

end result of the normalization process is that your data is split into a large number of narrow, well-defined tables

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

Non-relational database

A

One to many relationships in tables with duplicates

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

Relational database

A

Model for holding data. A primary use of relational databases is to handle transaction processing

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

Transactional database

A

A transactional database must adhere to the ACID (Atomicity, Consistency, Isolation, Durability) properties to ensure that the database remains consistent while processing transactions.

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

ACID

A

1) Atomicity guarantees that each transaction is treated as a single unit, which either succeeds completely, or fails completely.
2) Consistency ensures that a transaction can only take the data in the database from one valid state to another.
3) Isolation ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially.
4) Durability guarantees that once a transaction has been committed, it will remain committed even if there’s a system failure such as a power outage or crash.

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

Distributed database

A

is a database in which data is stored across different physical locations

17
Q

Analytical workloads

A

1) typically read-only systems that store vast volumes of historical data or business metrics, such as sales performance and inventory levels
2) used for data analysis and decision making