Data Engineering Quiz
Building data pipelines. ETL/ELT, warehousing, and moving data at scale.
This category currently has 80 questions in the SERVBG quiz bank. Below are a few sample questions: the full interactive quiz shuffles through the whole set with instant scoring.
Sample questions
What does ETL stand for in data engineering?
- Encode, Translate, Link
- Export, Track, Log
- Extend, Transmit, Locate
- Extract, Transform, Load
- Evaluate, Test, Launch
What is the main difference between ETL and ELT?
- ETL only works with NoSQL databases
- ELT loads raw data first and transforms inside the warehouse
- ELT requires no compute resources
- ELT does not transform data at all
- ETL is faster than ELT in every case
What is a data warehouse primarily optimized for?
- Serving static web pages
- Real-time chat messages
- Analytical queries over historical data
- High-volume transactional writes
- Storing operating system logs only
Which file format is columnar and commonly used in analytics?
- XML
- Parquet
- INI
- CSV
- YAML
What does OLAP stand for?
- Open Linked Application Protocol
- Object Layer Access Plan
- Online Analytical Processing
- Offline Archive Processing
- Operational Log Aggregation Pipeline
Related categories
Python (Coding)
Python syntax and standard-library usage, from quick scripts to full applications.
JavaScript (Coding)
Core JavaScript behavior and async patterns, including the quirks that trip up beginners and veterans alike.
Linux
Linux command-line usage, file permissions, process management. The daily admin tasks.
Security
General information security concepts: common threats and standard defenses.
Hardware
Hardware components, how they interact, and basic troubleshooting to keep systems running.