Working with non-relational data on Azure (25% - 30%) Flashcards

1
Q

Why would you choose a non-relational database over a relational database?

A

A relational database restructures data into a fixed format designed to answer specific queries. If the data needs to be ingested quickly, or the query is unknown and unconstrainted, a non-relational database would be better.

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

What is a key-value store?

A

An associative array with a key that acts as a unique identifier to retrieve a specific value. Those values can be anything, from a strong or number, to a complex object like a JSON file.

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

What are 4 types of NoSQL database?

A

Documents, key/value stores, column family database and graph databases.

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

What is unstructured data?

A

Data without any structure, like video and audio files.

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

What is semi-structured data?

A

Data that doesn’t reside in a relational database, but still has some structure. (Microsoft Learn defines it as data that contains fields.)

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

What is a document database?

A

A NoSQL database the stores and queries data as JSON-like documents. Each document has its own unique ID.

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

What is a column family database?

A

A database that groups related data into columns. The data for a single entity in that spans multiple columns has the same row key in each column.

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

What is a graph database?

A

A database that stores entities as nodes and the relationships between them as edges.

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

What is NoSQL?

A

NoSQL is a general term that means non-relational.

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

When would you use a key/value store?

A

When you need to ingest data quickly and don’t care about or need to query it.

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

When would you use a document database?

A

When you need ingest data faster than a relational database can, but need better query capabilities than a key/value store.

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

When would you use a graph database?

A

When an application needs to efficiently query entities and their relationships, and to analyse the relationships between entities.

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

When would you use a column family database?

A

When you need to find an entity’s related data (e.g. get a customer’s address or order info) quickly and efficiently.

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

What are Azure’s non-relational data services?

A

Azure Cosmos DB, Azure Table Storage, Azure Blob Storage and Azure File Storage.

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

What is a document?

A

A collection of fields, identified by a key. The number of fields can vary, and a field can contain child documents.

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