Data Engineering Interview Practice Tests: 6 Practice Tests and 637 Questions
Data Engineering Interview Prep
637
SQL and Relational Database Fundamentals | Keys, constraints, joins, views, transactions and normalization (8%)
Indexing and Query Performance | Clustered, covering and composite indexes, execution plans and tuning (4%)
NoSQL and Distributed Systems | Document, key-value, wide-column and graph stores, CAP, consensus, sharding and replication (7%)
Data Warehousing and Dimensional Modeling | Star and snowflake schemas, facts, conformed dimensions and slowly changing dimensions (6%)
Data Modeling and ER Diagrams | Conceptual, logical and physical models, ERD notation, cardinality and modeling tools (10%)
ETL, ELT and Data Integration | Extraction, CDC, incremental and bulk loading, transformation and tools such as NiFi and Talend (13%)
Data Lakes and Lakehouse Architecture | Object storage, schema-on-read, medallion layers and lake governance (2%)
Big Data Processing: Spark and Hadoop | Spark DataFrames, shuffles, caching and partitioning, HDFS, YARN, Hive and HBase (8%)
Stream Processing and Messaging | Kafka topics, partitions and KRaft, Flink, Structured Streaming, watermarks and checkpoints (11%)
Pipeline Orchestration, Monitoring and Reliability | Airflow DAGs and sensors, alerting, retries, backoff, idempotence and circuit breakers (10%)
Data Quality | Profiling, cleansing, validation, deduplication and quality dimensions (11%)
Data Governance, Security and Compliance | Lineage, metadata, stewardship, access control, encryption, GDPR and PCI DSS (10%)
Stream Processing and Messaging
In current versions of Apache Kafka, where are the committed offsets of a consumer group stored?
In ZooKeeper
In the internal __consumer_offsets topic on the brokers
In the producer that wrote the messages
On each consumer's local disk
B
Committed offsets are written by the group coordinator to the internal __consumer_offsets topic on the brokers. ZooKeeper-based offset storage is long obsolete, and Kafka 4.0 removed ZooKeeper entirely in favour of KRaft. Producers and individual consumer disks do not hold the group's committed position.
https://exametics.com/product/data-engineering-interview-practice-tests/
Course Content
Supporting Resources
You don't currently have access to this content
Data Engineer Interview Questions – Practice Test #1
You don't currently have access to this content
Data Engineer Interview Questions – Practice Test #2
You don't currently have access to this content
Data Engineer Interview Questions – Practice Test #3
You don't currently have access to this content
Data Engineer Interview Questions – Practice Test #4
You don't currently have access to this content
Data Engineer Interview Questions – Practice Test #5
You don't currently have access to this content
Exam Mode: Data Engineer Interview Questions – Practice Test #6
You don't currently have access to this content
