Introduction To Data Engineering

Question 1

Raw data from source systems is stored in an ELT data warehouse.

Accepted Answer

Staging Layer

Answer

Data Integration Layer

Answer

Semantic Layer

Answer

Access Layer

Question 2

Dividing a large table into smaller physical pieces to improve query performance, speed up bulk loads and data deletions, and cost-savings

Accepted Answer

Table Partitioning

Answer

Table Clustering

Answer

Table Indexing

Answer

Table Compaction

Question 3

A PostgreSQL utility process that cleans up dead tuples in the background.

Accepted Answer

Autovacuum

Answer

Autocompress

Answer

MVCC

Answer

BGcleaner

Question 4

A _________ table in a Star Schema contains attributes that describe the events in a fact table. It provides answers to the event's who, what, where, when, and why questions.

Accepted Answer

Dimension Table

Answer

Audit Table

Answer

Bridge Table

Answer

Mapping Table

Question 5

What are database transactions' ACID properties?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

Atomicity, Consistency, Isolation, Database

Answer

Atomicity, Consistency, Inconsistency, Durability

Answer

Automatically, Concurrency, Isolation, Durability

Question 6

What does ETL in a data pipeline mean?

Accepted Answer

Extract-Transform-Load

Answer

Execute-Transform-Load

Answer

Extract-Tweak-Load

Answer

Extract-Transform-Link

Question 7

A secondary database that is used to offload analytics queries from the primary instance.

Accepted Answer

Read replica

Answer

Merge replica

Answer

Streaming replica

Answer

Global replica