FREE Introduction To Data Engineering Questions and Answers

What are database transactions' ACID properties?

Atomicity, Consistency, Inconsistency, Durability

Atomicity, Consistency, Isolation, Durability

Automatically, Concurrency, Isolation, Durability

Atomicity, Consistency, Isolation, Database

Correct! Wrong!

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

Staging Layer

Access Layer

Semantic Layer

Data Integration Layer

Correct! Wrong!

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

BGcleaner

Autocompress

MVCC

Autovacuum

Correct! Wrong!

What does ETL in a data pipeline mean?

Extract-Tweak-Load

Extract-Transform-Load

Execute-Transform-Load

Extract-Transform-Link

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 Partitioning

Table Compaction

Table Clustering

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.

Bridge Table

Audit Table

Mapping Table

Dimension Table

Correct! Wrong!

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

Global replica

Streaming replica

Read replica

Merge replica

Correct! Wrong!

FREE Introduction To Data Engineering Questions and Answers

What are database transactions' ACID properties?

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

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

What does ETL in a data pipeline mean?

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

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.

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

Related Post