FREE Introduction To Data Engineering Questions and Answers
A PostgreSQL utility process that cleans up dead tuples in the background.
Correct!
Wrong!
A secondary database that is used to offload analytics queries from the primary instance.
Correct!
Wrong!
Raw data from source systems is stored in an ELT data warehouse.
Correct!
Wrong!
What are database transactions' ACID properties?
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.
Correct!
Wrong!
Dividing a large table into smaller physical pieces to improve query performance, speed up bulk loads and data deletions, and cost-savings
Correct!
Wrong!
What does ETL in a data pipeline mean?
Correct!
Wrong!