FREE Introduction To Data Engineering Questions and Answers

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

Access Layer

Staging Layer

Data Integration Layer

Semantic Layer

Correct! Wrong!

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

Read replica

Global replica

Merge replica

Streaming replica

Correct! Wrong!

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

Table Indexing

Table Clustering

Table Partitioning

Table Compaction

Correct! Wrong!

What are database transactions' ACID properties?

Atomicity, Consistency, Inconsistency, Durability

Automatically, Concurrency, Isolation, Durability

Atomicity, Consistency, Isolation, Database

Atomicity, Consistency, Isolation, Durability

Correct! Wrong!

What does ETL in a data pipeline mean?

Extract-Transform-Load

Extract-Tweak-Load

Extract-Transform-Link

Execute-Transform-Load

Correct! Wrong!

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

BGcleaner

Autocompress

MVCC

Autovacuum

Correct! Wrong!

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.

Mapping Table

Audit Table

Dimension Table

Bridge Table

Correct! Wrong!

FREE Introduction To Data Engineering Questions and Answers

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

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

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

What are database transactions' ACID properties?

What does ETL in a data pipeline mean?

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

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.

Related Post