Data Engineering Quiz
Building data pipelines — ETL/ELT, warehousing, and the infrastructure behind moving and shaping 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?
- Export, Track, Log
- Extract, Transform, Load
- Extend, Transmit, Locate
- Encode, Translate, Link
- Evaluate, Test, Launch
What is the main difference between ETL and ELT?
- ETL is faster than ELT in every case
- ELT requires no compute resources
- ELT loads raw data first and transforms inside the warehouse
- ELT does not transform data at all
- ETL only works with NoSQL databases
What is a data warehouse primarily optimized for?
- Serving static web pages
- Storing operating system logs only
- High-volume transactional writes
- Analytical queries over historical data
- Real-time chat messages
Which file format is columnar and commonly used in analytics?
- YAML
- INI
- XML
- Parquet
- CSV
What does OLAP stand for?
- Object Layer Access Plan
- Open Linked Application Protocol
- Online Analytical Processing
- Offline Archive Processing
- Operational Log Aggregation Pipeline
Related categories
Python (Coding)
Python syntax, standard-library usage, and the language idioms that come up in day-to-day scripting and application work.
JavaScript (Coding)
Core JavaScript language behavior, async patterns, and the quirks that trip up both beginners and experienced developers.
Linux
Linux command-line usage, file permissions, process management, and the everyday admin tasks every sysadmin and developer needs.
Security
General information security concepts — threats, defenses, and the fundamentals every IT professional should know.
Hardware
Computer hardware components, how they interact, and the troubleshooting knowledge behind keeping systems running.