Linux Academy

Question 1

Document database

Answer 1

1. NoSQL
2. Typically JSON
3. Family of information with varying structure.

Question 2

Data factory activity

Answer 2

Processing steps in a pipeline:
1. Data movement
2, Data transformation
3. Control

Question 3

Data lake encryption

Answer 3

Data at rest and in motion are always encrypted by default

Question 4

Snowflake schema

Answer 4

1. Reduced query performance
2. Multiple dimension tables
3. Normalised

Question 5

DWU

Answer 5

Data Warehouse Unit. Unit of measure used in SQL Data Warehouse

Question 6

Key-value store

Answer 6

1. Highly optimised for simple lookups.

2. Scalable across multiple nodes

Question 7

Graph databases

Answer 7

Consists of nodes and edges.

Example is Gremlin API in CosmosDB

Question 8

Star scheme

Answer 8

1. Easy to query
2. Fact table
3. Dimension table
4. Not normalised

Question 9

Data factory linked service

Answer 9

The connection string needed to connect to the data

Question 10

Azure Monitor

Answer 10

Centralised, consolidated monitoring for all Azure resources

Question 11

Wide column store

Answer 11

Data organised into column and row