Home › Interview Questions › Data Engineering Interview Questions

Data Engineering Interview Questions

1,698 real Data Engineering questions asked in live technical interviews — each with a model answer. Updated weekly.

🎤 Auto-captured by Assisting AI during live interviews

These Data Engineering interview questions were captured from real interviews by candidates using Assisting AI. Each links to a full model answer. For real-time help during your own interview, get Assisting AI from ₹500/day.

Have you worked on Databricks as well?🟢 Easy · Behavioral · Asked 32×There is also a data engineering part to this. For example, developing a data pipeline for ground truth. How would you go about this?🟡 Medium · Conceptual · Asked 1×Imagine you need to process a large daily dataset on E‑D. You are using PySpark on EMR, but the input volume suddenly doubles and the job starts missing its SLE because of skew and shuffle. How would you redesign the job and the EMR setup to keep it both fast and cost‑efficient?🟡 Medium · Conceptual · Asked 1×Tell me about a time when you had to keep a mixed team aligned under a tight deadline, especially when one senior engineer and one junior teammate wanted very different approaches to the same data pipeline issue.🟢 Easy · Behavioral · Asked 1×What are the key aspects to consider during an ETL code review?🟡 Medium · Conceptual · Asked 1×When would you choose Parquet in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using ORC?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Delta Lake?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using snowflake schema?🟡 Medium · Conceptual · Asked 1×How would you compare data quality and data lineage for a production system?🔴 Hard · Conceptual · Asked 1×How does data lineage work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Great Expectations?🟡 Medium · Debugging · Asked 1×How does Airbyte work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Databricks?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Amazon EMR?🟡 Medium · Conceptual · Asked 1×How does batch processing work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Apache Kafka?🟡 Medium · Conceptual · Asked 1×What is the difference between Kafka consumer groups and Kafka offsets, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving Kafka offsets?🟡 Medium · Debugging · Asked 1×How would you monitor and alert on failures involving SLAs?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses ETL?🟡 Medium · Other · Asked 1×How would you document a production design that uses operators?🟡 Medium · Behavioral · Asked 1×What follow-up could reveal whether a candidate really understands instances?🟡 Medium · Conceptual · Asked 1×What security considerations apply to scheduler?🔴 Hard · Conceptual · Asked 1×How would you test a production implementation that uses retries?🟡 Medium · Other · Asked 1×What security considerations apply to medallion?🔴 Hard · Conceptual · Asked 1×How would you document a production design that uses medallion?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for architecture?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around quality?🔴 Hard · System Design · Asked 1×Explain the role of Snowflake in production systems.🟢 Easy · Conceptual · Asked 1×What security considerations apply to Snowflake?🔴 Hard · Conceptual · Asked 1×When is Snowflake a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When would you use distribution, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving pruning?🟡 Medium · Debugging · Asked 1×What edge cases should an interviewer ask about for monitors?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where cost would be useful.🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving cost?🟡 Medium · Conceptual · Asked 1×How would you implement or configure time in a production environment?🟡 Medium · Coding · Asked 1×How does ORC affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data lakes?🟡 Medium · Debugging · Asked 1×When would you choose data modeling in a real project?🟡 Medium · Conceptual · Asked 1×When would you choose star schema in a real project?🟡 Medium · Conceptual · Asked 1×What is event time, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Great Expectations?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Flink?🟡 Medium · Conceptual · Asked 1×What is the difference between Databricks and Azure Data Factory, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose ELT in a real project?🟡 Medium · Conceptual · Asked 1×What is stream processing, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What would you inspect first when ETL is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses catchup?🟡 Medium · Behavioral · Asked 1×How would you test a production implementation that uses groups?🟡 Medium · Other · Asked 1×How would you explain the trade-off between correctness and performance when using lakehouse?🟢 Easy · Conceptual · Asked 1×Why is the use of schema important in production?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses schema?🟡 Medium · Other · Asked 1×Which configuration choices matter most for schema?🟡 Medium · Conceptual · Asked 1×Why is the use of slowly important in production?🟢 Easy · Conceptual · Asked 1×What would you inspect first when evolution is slow or unstable?🟡 Medium · Debugging · Asked 1×How is DAG typically used in a real system?🟡 Medium · Conceptual · Asked 1×Explain the role of XCom in production systems.🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for task?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for task?🟡 Medium · Conceptual · Asked 1×When is scheduler a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When would you use retries, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure cost in a production environment?🟡 Medium · Coding · Asked 1×How would you design for failure recovery around workload?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for workload?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving monitors?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving cost?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using watermarks?🟡 Medium · Conceptual · Asked 1×When would you choose Beam in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Beam?🟡 Medium · Conceptual · Asked 1×What security considerations apply to ELT?🔴 Hard · Conceptual · Asked 1×Describe a realistic interview scenario where ELT would be useful.🟡 Medium · Conceptual · Asked 1×How does task compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure catchup in a production environment?🟡 Medium · Coding · Asked 1×How does catchup compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How should a system using groups be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to mapping safely?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving datasets?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using warehouses?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving medallion?🟡 Medium · Debugging · Asked 1×What are common mistakes when using slowly?🟡 Medium · Debugging · Asked 1×How would you design for failure recovery around slowly?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving dimensions?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where dimensions would be useful.🟡 Medium · Conceptual · Asked 1×When would you use evolution, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure Snowflake in a production environment?🟡 Medium · Coding · Asked 1×Which configuration choices matter most for Snowflake?🟡 Medium · Conceptual · Asked 1×How is pruning typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to monitors safely?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around time?🔴 Hard · System Design · Asked 1×How would you test a component that depends on data lineage?🟡 Medium · Conceptual · Asked 1×How does exactly once processing affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does Databricks work at a high level?🟡 Medium · Conceptual · Asked 1×How does Databricks affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Apache Kafka?🟡 Medium · Conceptual · Asked 1×How does schema registry work at a high level?🟡 Medium · Conceptual · Asked 1×How should a system using dimensional be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for DAG?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for operators?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses XCom?🟡 Medium · Other · Asked 1×Describe a realistic interview scenario where XCom would be useful.🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses task?🟡 Medium · Other · Asked 1×How would you optimize a system that depends on retries?🟡 Medium · System Design · Asked 1×How would you design for failure recovery around operators?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to operators safely?🔴 Hard · System Design · Asked 1×What security considerations apply to task?🔴 Hard · Conceptual · Asked 1×Describe a realistic interview scenario where scheduler would be useful.🟡 Medium · Conceptual · Asked 1×How would you implement or configure lakes in a production environment?🟡 Medium · Coding · Asked 1×How would you document a production design that uses dimensional?🟡 Medium · Behavioral · Asked 1×When would you use star, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What would you inspect first when star is slow or unstable?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for star?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for snowflake?🟡 Medium · Conceptual · Asked 1×How does slowly compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with quality?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using ETL?🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for distribution?🟡 Medium · Conceptual · Asked 1×What would you inspect first when distribution is slow or unstable?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using data pipelines?🟡 Medium · Conceptual · Asked 1×How would you compare batch processing and stream processing for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving PySpark?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving Dagster?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Kafka offsets?🟡 Medium · Conceptual · Asked 1×What is Avro, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Parquet work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose Apache Hudi in a real project?🟡 Medium · Conceptual · Asked 1×How does fact tables work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using dimension tables?🟡 Medium · Conceptual · Asked 1×How would you compare Trino and Presto for a production system?🔴 Hard · Conceptual · Asked 1×What would you inspect first when groups is slow or unstable?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for lakes?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with warehouses?🟡 Medium · Conceptual · Asked 1×What security considerations apply to warehouses?🔴 Hard · Conceptual · Asked 1×How is lakehouse typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on dimensional?🟡 Medium · System Design · Asked 1×What are common mistakes when using star?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses star?🟡 Medium · Behavioral · Asked 1×Which configuration choices matter most for slowly?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for evolution?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses quality?🟡 Medium · Other · Asked 1×How would you migrate an existing system to sensors safely?🔴 Hard · System Design · Asked 1×When would you use XCom, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands workers?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using lakes?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses distribution?🟡 Medium · Behavioral · Asked 1×Why is the use of time important in production?🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for travel?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Airbyte?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using batch processing?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Spark SQL?🟡 Medium · Conceptual · Asked 1×How does schema registry affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is Apache Kafka, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using schema registry?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Parquet?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Apache Hudi?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on data modeling?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving slowly changing dimensions?🟡 Medium · Debugging · Asked 1×How does fact tables affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does watermarks work at a high level?🟡 Medium · Conceptual · Asked 1×How does late arriving data affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Kafka Connect?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses Trino?🟡 Medium · Conceptual · Asked 1×When would you choose AWS Glue in a real project?🟡 Medium · Conceptual · Asked 1×How is ETL typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses ETL?🟡 Medium · Behavioral · Asked 1×How should a system using DAG be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How is sensors typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure XCom in a production environment?🟡 Medium · Coding · Asked 1×Why is the use of SLAs important in production?🟢 Easy · Conceptual · Asked 1×How would you implement or configure mapping in a production environment?🟡 Medium · Coding · Asked 1×Why is the use of datasets important in production?🟢 Easy · Conceptual · Asked 1×How should a system using architecture be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×When is dimensional a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How does star compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When would you use schema, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands dimensions?🟡 Medium · Conceptual · Asked 1×How does evolution compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving monitors?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to cost safely?🔴 Hard · System Design · Asked 1×How would you test a component that depends on ORC?🟡 Medium · Conceptual · Asked 1×How does Apache Iceberg affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using data catalogs?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving event time?🟡 Medium · Debugging · Asked 1×How does idempotent pipelines work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using data validation?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Airbyte?🟡 Medium · Conceptual · Asked 1×How would you compare Fivetran and Kafka Connect for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using Azure Data Factory?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving BigQuery ingestion?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses batch processing?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Spark SQL?🟡 Medium · Debugging · Asked 1×What is the difference between schema registry and Avro, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses datasets?🟡 Medium · Other · Asked 1×What are common mistakes when using instances?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses instances?🟡 Medium · Behavioral · Asked 1×How would you monitor and alert on failures involving scheduler?🟡 Medium · Conceptual · Asked 1×How does executor compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How should a system using SLAs be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×When is medallion a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where slowly would be useful.🟡 Medium · Conceptual · Asked 1×How should a system using changing be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you implement or configure dimensions in a production environment?🟡 Medium · Coding · Asked 1×How is CDC typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to CDC safely?🔴 Hard · System Design · Asked 1×What edge cases should an interviewer ask about for Snowflake?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using fact?🟢 Easy · Conceptual · Asked 1×When is fact a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When is distribution a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using pruning?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses late arriving data?🟡 Medium · Conceptual · Asked 1×What is Great Expectations, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between Great Expectations and Airbyte, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is Flink, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose Databricks in a real project?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for dynamic?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to schema safely?🔴 Hard · System Design · Asked 1×What edge cases should an interviewer ask about for slowly?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to slowly safely?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on DAG?🟡 Medium · System Design · Asked 1×When is DAG a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How should a system using operators be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What metrics would you monitor for instances?🟡 Medium · Conceptual · Asked 1×How does workload compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to cost?🔴 Hard · Conceptual · Asked 1×What metrics would you monitor for Snowflake?🟡 Medium · Conceptual · Asked 1×How does fact compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on monitors?🟡 Medium · System Design · Asked 1×Describe a realistic interview scenario where monitors would be useful.🟡 Medium · Conceptual · Asked 1×What would you inspect first when monitors is slow or unstable?🟡 Medium · Debugging · Asked 1×When is cost a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving time?🟡 Medium · Debugging · Asked 1×How is travel typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving ELT?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses data pipelines?🟡 Medium · Conceptual · Asked 1×How does batch processing affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does stream processing work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose Apache Kafka in a real project?🟡 Medium · Conceptual · Asked 1×How does Kafka offsets work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses ORC?🟡 Medium · Conceptual · Asked 1×How does data lakehouses affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses data lineage?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on CDC?🟡 Medium · Conceptual · Asked 1×How does Debezium affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between Trino and Presto, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on Azure Data Factory?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving ETL?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving ELT?🟡 Medium · Conceptual · Asked 1×How should a system using XCom be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What edge cases should an interviewer ask about for XCom?🟡 Medium · Conceptual · Asked 1×When is task a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How does instances compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses executor?🟡 Medium · Other · Asked 1×How should a system using workers be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How does dynamic compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of deferrable in production systems.🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for lakes?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using lakehouse?🟡 Medium · Debugging · Asked 1×Why is the use of dimensional important in production?🟢 Easy · Conceptual · Asked 1×How is dimensional typically used in a real system?🟡 Medium · Conceptual · Asked 1×How does schema compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using snowflake?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving evolution?🟡 Medium · Conceptual · Asked 1×How does Snowflake compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to fact?🔴 Hard · Conceptual · Asked 1×What edge cases should an interviewer ask about for workload?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to workload safely?🔴 Hard · System Design · Asked 1×How does cost compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When is travel a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data modeling?🟡 Medium · Debugging · Asked 1×What is data validation, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Azure Data Factory affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does ETL work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving ETL?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using batch processing?🟡 Medium · Conceptual · Asked 1×When would you choose stream processing in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on stream processing?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using dbt?🟡 Medium · Conceptual · Asked 1×How would you compare Apache Kafka and Kafka partitions for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses Kafka partitions?🟡 Medium · Conceptual · Asked 1×When would you choose schema registry in a real project?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to lakehouse safely?🔴 Hard · System Design · Asked 1×How should a system using medallion be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Explain the role of schema in production systems.🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on dimensions?🟡 Medium · System Design · Asked 1×How would you optimize a system that depends on groups?🟡 Medium · System Design · Asked 1×How would you test a production implementation that uses dynamic?🟡 Medium · Other · Asked 1×What would you inspect first when datasets is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to datasets safely?🔴 Hard · System Design · Asked 1×When is sensors a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using XCom?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with scheduler?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for executor?🟡 Medium · Conceptual · Asked 1×When would you use workers, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How does workers compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around sensors?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with XCom?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where task would be useful.🟡 Medium · Conceptual · Asked 1×Explain the role of scheduler in production systems.🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving executor?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands lakes?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with lakehouse?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses lakehouse?🟡 Medium · Other · Asked 1×How would you document a production design that uses lakehouse?🟡 Medium · Behavioral · Asked 1×How would you explain the trade-off between correctness and performance when using dimensional?🟢 Easy · Conceptual · Asked 1×Why is the use of changing important in production?🟢 Easy · Conceptual · Asked 1×How would you migrate an existing system to dimensions safely?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for evolution?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to ELT safely?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on SLAs?🟡 Medium · System Design · Asked 1×How would you optimize a system that depends on datasets?🟡 Medium · System Design · Asked 1×How is deferrable typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to Snowflake safely?🔴 Hard · System Design · Asked 1×How does distribution compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses workload?🟡 Medium · Other · Asked 1×How would you document a production design that uses monitors?🟡 Medium · Behavioral · Asked 1×What security considerations apply to travel?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving Spark Structured Streaming?🟡 Medium · Debugging · Asked 1×What is the difference between Delta Lake and Apache Iceberg, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose data lineage in a real project?🟡 Medium · Conceptual · Asked 1×How does change data capture affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Amazon EMR?🟡 Medium · Conceptual · Asked 1×How should a system using dynamic be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving dynamic?🟡 Medium · Conceptual · Asked 1×What would you inspect first when lakes is slow or unstable?🟡 Medium · Debugging · Asked 1×What edge cases should an interviewer ask about for warehouses?🟡 Medium · Conceptual · Asked 1×What security considerations apply to architecture?🔴 Hard · Conceptual · Asked 1×How would you monitor and alert on failures involving snowflake?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using CDC?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving operators?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around scheduler?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with retries?🟡 Medium · Conceptual · Asked 1×How would you implement or configure ETL in a production environment?🟡 Medium · Coding · Asked 1×Why is the use of pruning important in production?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with pruning?🟡 Medium · Conceptual · Asked 1×How would you implement or configure workload in a production environment?🟡 Medium · Coding · Asked 1×How should a system using workload be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Explain the role of time in production systems.🟢 Easy · Conceptual · Asked 1×How would you compare Apache Iceberg and Apache Hudi for a production system?🔴 Hard · Conceptual · Asked 1×How does data warehouses affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does data lakehouses work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data quality?🟡 Medium · Debugging · Asked 1×What is the difference between Kafka Connect and Flink, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Beam?🟡 Medium · Conceptual · Asked 1×What is the difference between Beam and Trino, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose batch processing in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving stream processing?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on Spark Structured Streaming?🟡 Medium · Conceptual · Asked 1×How does Kafka consumer groups work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using ETL?🟡 Medium · Conceptual · Asked 1×What is Apache Airflow, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Kafka partitions?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Apache Hudi?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using dimension tables?🟡 Medium · Conceptual · Asked 1×How does dimension tables affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving change data capture?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Kafka Connect?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using ETL?🟡 Medium · Debugging · Asked 1×What would you inspect first when XCom is slow or unstable?🟡 Medium · Debugging · Asked 1×What metrics would you monitor for task?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving task?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for executor?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around retries?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with catchup?🟡 Medium · Conceptual · Asked 1×When would you use deferrable, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to lakes safely?🔴 Hard · System Design · Asked 1×Why is the use of warehouses important in production?🟢 Easy · Conceptual · Asked 1×How does warehouses compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When is warehouses a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Why is the use of medallion important in production?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving star?🟡 Medium · Debugging · Asked 1×Explain the role of pruning in production systems.🟢 Easy · Conceptual · Asked 1×Explain the role of travel in production systems.🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands travel?🟡 Medium · Conceptual · Asked 1×How does snowflake schema affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose watermarks in a real project?🟡 Medium · Conceptual · Asked 1×How does Trino work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose data pipelines in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using data pipelines?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Apache Airflow?🟡 Medium · Conceptual · Asked 1×What is Dagster, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Apache Kafka?🟡 Medium · Conceptual · Asked 1×How does groups compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using mapping?🟡 Medium · Debugging · Asked 1×When is mapping a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for ELT?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for operators?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses instances?🟡 Medium · Other · Asked 1×How would you document a production design that uses executor?🟡 Medium · Behavioral · Asked 1×How is workers typically used in a real system?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for retries?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses SLAs?🟡 Medium · Other · Asked 1×How would you test a production implementation that uses architecture?🟡 Medium · Other · Asked 1×When is star a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands slowly?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses fact?🟡 Medium · Behavioral · Asked 1×What security considerations apply to monitors?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving data warehouses?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using data lakehouses?🟡 Medium · Conceptual · Asked 1×How does data lineage affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using event time?🟡 Medium · Conceptual · Asked 1×What is Presto, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare Databricks and Azure Data Factory for a production system?🔴 Hard · Conceptual · Asked 1×When would you choose Azure Data Factory in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare Apache Airflow and Dagster for a production system?🔴 Hard · Conceptual · Asked 1×How is ELT typically used in a real system?🟡 Medium · Conceptual · Asked 1×What would you inspect first when ELT is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you implement or configure groups in a production environment?🟡 Medium · Coding · Asked 1×What security considerations apply to mapping?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for mapping?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses warehouses?🟡 Medium · Behavioral · Asked 1×What follow-up could reveal whether a candidate really understands warehouses?🟡 Medium · Conceptual · Asked 1×How would you implement or configure snowflake in a production environment?🟡 Medium · Coding · Asked 1×How should a system using slowly be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What security considerations apply to DAG?🔴 Hard · Conceptual · Asked 1×How does XCom compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to executor?🔴 Hard · Conceptual · Asked 1×Explain the role of cost in production systems.🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around cost?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for cost?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around Snowflake?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to travel safely?🔴 Hard · System Design · Asked 1×When would you choose dbt in a real project?🟡 Medium · Conceptual · Asked 1×How does dbt affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on data lakes?🟡 Medium · Conceptual · Asked 1×How would you compare change data capture and Debezium for a production system?🔴 Hard · Conceptual · Asked 1×How does late arriving data work at a high level?🟡 Medium · Conceptual · Asked 1×How would you implement or configure DAG in a production environment?🟡 Medium · Coding · Asked 1×What follow-up could reveal whether a candidate really understands XCom?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for scheduler?🟡 Medium · Conceptual · Asked 1×Explain the role of retries in production systems.🟢 Easy · Conceptual · Asked 1×What security considerations apply to catchup?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for catchup?🟡 Medium · Conceptual · Asked 1×Why is the use of deferrable important in production?🟢 Easy · Conceptual · Asked 1×What are common mistakes when using architecture?🟡 Medium · Debugging · Asked 1×How should a system using snowflake be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×When is snowflake a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How does changing compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with dimensions?🟡 Medium · Conceptual · Asked 1×What security considerations apply to dimensions?🔴 Hard · Conceptual · Asked 1×How would you design for failure recovery around dimensions?🔴 Hard · System Design · Asked 1×When is dimensions a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving evolution?🟡 Medium · Debugging · Asked 1×How should a system using fact be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Explain the role of workload in production systems.🟢 Easy · Conceptual · Asked 1×What is snowflake schema, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on slowly changing dimensions?🟡 Medium · Conceptual · Asked 1×When would you choose late arriving data in a real project?🟡 Medium · Conceptual · Asked 1×When would you choose idempotent pipelines in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on ETL?🟡 Medium · Conceptual · Asked 1×What is ELT, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose Apache Spark in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Spark Structured Streaming?🟡 Medium · Conceptual · Asked 1×How does Apache Kafka work at a high level?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for warehouses?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving lakehouse?🟡 Medium · Debugging · Asked 1×What would you inspect first when architecture is slow or unstable?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where star would be useful.🟡 Medium · Conceptual · Asked 1×Why is the use of dynamic important in production?🟢 Easy · Conceptual · Asked 1×When would you use dynamic, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of mapping important in production?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving mapping?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where deferrable would be useful.🟡 Medium · Conceptual · Asked 1×What would you inspect first when deferrable is slow or unstable?🟡 Medium · Debugging · Asked 1×What would you inspect first when sensors is slow or unstable?🟡 Medium · Debugging · Asked 1×How is task typically used in a real system?🟡 Medium · Conceptual · Asked 1×When would you use instances, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for scheduler?🟡 Medium · Conceptual · Asked 1×What would you inspect first when executor is slow or unstable?🟡 Medium · Debugging · Asked 1×What edge cases should an interviewer ask about for workers?🟡 Medium · Conceptual · Asked 1×How does retries compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When is retries a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using sensors?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving executor?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where retries would be useful.🟡 Medium · Conceptual · Asked 1×What would you inspect first when retries is slow or unstable?🟡 Medium · Debugging · Asked 1×What security considerations apply to lakehouse?🔴 Hard · Conceptual · Asked 1×When would you use medallion, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of ELT important in production?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses catchup?🟡 Medium · Other · Asked 1×What benefits and trade-offs come with groups?🟡 Medium · Conceptual · Asked 1×When is groups a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses distribution?🟡 Medium · Other · Asked 1×What edge cases should an interviewer ask about for distribution?🟡 Medium · Conceptual · Asked 1×Why is the use of workload important in production?🟢 Easy · Conceptual · Asked 1×How does ELT work at a high level?🟡 Medium · Conceptual · Asked 1×How does Apache Spark work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Spark Structured Streaming?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Apache Airflow?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Kafka offsets?🟡 Medium · Conceptual · Asked 1×What is schema registry, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving schema registry?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Avro?🟡 Medium · Conceptual · Asked 1×How does dimension tables work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using CDC?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using change data capture?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Fivetran?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Flink?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Presto?🟡 Medium · Conceptual · Asked 1×How is catchup typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure lakehouse in a production environment?🟡 Medium · Coding · Asked 1×Explain the role of medallion in production systems.🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where dimensional would be useful.🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using dimensions?🟢 Easy · Conceptual · Asked 1×What security considerations apply to CDC?🔴 Hard · Conceptual · Asked 1×How would you test a production implementation that uses DAG?🟡 Medium · Other · Asked 1×How would you design for failure recovery around DAG?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around fact?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for monitors?🟡 Medium · Conceptual · Asked 1×What is data lakehouses, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does slowly changing dimensions work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose dimension tables in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on dimension tables?🟡 Medium · Conceptual · Asked 1×How does event time work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose event time in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using late arriving data?🟡 Medium · Conceptual · Asked 1×What is idempotent pipelines, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Flink affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is Beam, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose Presto in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Databricks?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Azure Data Factory?🟡 Medium · Debugging · Asked 1×When would you choose Amazon EMR in a real project?🟡 Medium · Conceptual · Asked 1×What is BigQuery ingestion, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving batch processing?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses PySpark?🟡 Medium · Conceptual · Asked 1×How does Dagster work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using stream processing?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using stream processing?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Prefect?🟡 Medium · Conceptual · Asked 1×What is the difference between Kafka offsets and schema registry, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose Avro in a real project?🟡 Medium · Conceptual · Asked 1×How does Avro affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between Avro and Parquet, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare data lakes and data warehouses for a production system?🔴 Hard · Conceptual · Asked 1×What is data modeling, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses dimension tables?🟡 Medium · Conceptual · Asked 1×What is the difference between data lineage and data catalogs, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is watermarks, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on late arriving data?🟡 Medium · Conceptual · Asked 1×What is the difference between Amazon EMR and BigQuery ingestion, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using BigQuery ingestion?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around XCom?🔴 Hard · System Design · Asked 1×How should a system using task be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Explain the role of instances in production systems.🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using scheduler?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving workers?🟡 Medium · Debugging · Asked 1×What follow-up could reveal whether a candidate really understands retries?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using SLAs?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for SLAs?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for dynamic?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with mapping?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving datasets?🟡 Medium · Debugging · Asked 1×How should a system using deferrable be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving lakehouse?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to medallion safely?🔴 Hard · System Design · Asked 1×What are common mistakes when using CDC?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with evolution?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for pruning?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to pruning safely?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands pruning?🟡 Medium · Conceptual · Asked 1×How is monitors typically used in a real system?🟡 Medium · Conceptual · Asked 1×When would you choose Apache Iceberg in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare snowflake schema and slowly changing dimensions for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses change data capture?🟡 Medium · Conceptual · Asked 1×How does event time affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving late arriving data?🟡 Medium · Debugging · Asked 1×What is Trino, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose Kafka offsets in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare schema registry and Avro for a production system?🔴 Hard · Conceptual · Asked 1×How does Avro work at a high level?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where groups would be useful.🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving groups?🟡 Medium · Conceptual · Asked 1×How should a system using mapping be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using ELT?🟢 Easy · Conceptual · Asked 1×Explain the role of operators in production systems.🟢 Easy · Conceptual · Asked 1×How is XCom typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses scheduler?🟡 Medium · Other · Asked 1×How would you implement or configure warehouses in a production environment?🟡 Medium · Coding · Asked 1×What would you inspect first when medallion is slow or unstable?🟡 Medium · Debugging · Asked 1×How does CDC compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of quality in production systems.🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses pruning?🟡 Medium · Other · Asked 1×How would you monitor and alert on failures involving pruning?🟡 Medium · Conceptual · Asked 1×How should a system using cost be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What are common mistakes when using time?🟡 Medium · Debugging · Asked 1×How does data lakes work at a high level?🟡 Medium · Conceptual · Asked 1×How does data warehouses work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare data lakehouses and data modeling for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare fact tables and dimension tables for a production system?🔴 Hard · Conceptual · Asked 1×What is CDC, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare CDC and change data capture for a production system?🔴 Hard · Conceptual · Asked 1×How does change data capture work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using late arriving data?🟡 Medium · Conceptual · Asked 1×How does Airbyte affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between Presto and Databricks, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare Presto and Databricks for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses Databricks?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Azure Data Factory?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Azure Data Factory?🟡 Medium · Conceptual · Asked 1×How would you compare Apache Spark and PySpark for a production system?🔴 Hard · Conceptual · Asked 1×How does Spark Structured Streaming affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between Prefect and dbt, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Kafka consumer groups?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using SLAs?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around groups?🔴 Hard · System Design · Asked 1×How would you document a production design that uses architecture?🟡 Medium · Behavioral · Asked 1×What follow-up could reveal whether a candidate really understands star?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for changing?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around evolution?🔴 Hard · System Design · Asked 1×What metrics would you monitor for quality?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for DAG?🟡 Medium · Conceptual · Asked 1×How does operators compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure task in a production environment?🟡 Medium · Coding · Asked 1×How would you implement or configure retries in a production environment?🟡 Medium · Coding · Asked 1×How is fact typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around distribution?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on pruning?🟡 Medium · System Design · Asked 1×What benefits and trade-offs come with Snowflake?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using Snowflake?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses Snowflake?🟡 Medium · Behavioral · Asked 1×Explain the role of distribution in production systems.🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for pruning?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for cost?🟡 Medium · Conceptual · Asked 1×When would you choose Kafka partitions in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses schema registry?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Apache Iceberg?🟡 Medium · Conceptual · Asked 1×What is the difference between data lakes and data warehouses, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is data quality, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between idempotent pipelines and data validation, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose Flink in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare Azure Data Factory and AWS Glue for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes when using task?🟡 Medium · Debugging · Asked 1×What would you inspect first when task is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving instances?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to executor safely?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to retries safely?🔴 Hard · System Design · Asked 1×What security considerations apply to groups?🔴 Hard · Conceptual · Asked 1×How does datasets compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands datasets?🟡 Medium · Conceptual · Asked 1×How does lakes compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to slowly?🔴 Hard · Conceptual · Asked 1×Describe a realistic interview scenario where CDC would be useful.🟡 Medium · Conceptual · Asked 1×Explain the role of evolution in production systems.🟢 Easy · Conceptual · Asked 1×How would you implement or configure fact in a production environment?🟡 Medium · Coding · Asked 1×How would you explain the trade-off between correctness and performance when using workload?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with cost?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses cost?🟡 Medium · Other · Asked 1×How would you optimize a system that depends on cost?🟡 Medium · System Design · Asked 1×How can you improve the performance of a system that uses data warehouses?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using data lineage?🟡 Medium · Conceptual · Asked 1×How would you compare idempotent pipelines and data validation for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare Airbyte and Fivetran for a production system?🔴 Hard · Conceptual · Asked 1×What is Azure Data Factory, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Azure Data Factory work at a high level?🟡 Medium · Conceptual · Asked 1×What is Apache Spark, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Dagster affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare dbt and Apache Kafka for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on schema registry?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving warehouses?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses warehouses?🟡 Medium · Other · Asked 1×How would you optimize a system that depends on warehouses?🟡 Medium · System Design · Asked 1×What are common mistakes when using quality?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving quality?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using groups?🟢 Easy · Conceptual · Asked 1×Why is the use of ETL important in production?🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for ETL?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses ELT?🟡 Medium · Other · Asked 1×How should a system using ELT be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving operators?🟡 Medium · Debugging · Asked 1×What metrics would you monitor for XCom?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using executor?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with operators?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on operators?🟡 Medium · System Design · Asked 1×Describe a realistic interview scenario where operators would be useful.🟡 Medium · Conceptual · Asked 1×Why is the use of workers important in production?🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using workers?🟢 Easy · Conceptual · Asked 1×How would you implement or configure medallion in a production environment?🟡 Medium · Coding · Asked 1×What edge cases should an interviewer ask about for medallion?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to catchup safely?🔴 Hard · System Design · Asked 1×How is mapping typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses Snowflake?🟡 Medium · Other · Asked 1×What would you inspect first when Snowflake is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses fact?🟡 Medium · Other · Asked 1×Describe a realistic interview scenario where fact would be useful.🟡 Medium · Conceptual · Asked 1×How is cost typically used in a real system?🟡 Medium · Conceptual · Asked 1×When is time a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What is PySpark, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on PySpark?🟡 Medium · Conceptual · Asked 1×What is the difference between Spark SQL and Spark Structured Streaming, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Dagster?🟡 Medium · Conceptual · Asked 1×How does Delta Lake affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses snowflake schema?🟡 Medium · Conceptual · Asked 1×When would you choose data catalogs in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using event time?🟡 Medium · Conceptual · Asked 1×How does Great Expectations work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Great Expectations?🟡 Medium · Conceptual · Asked 1×What is Kafka Connect, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is Amazon EMR, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using BigQuery ingestion?🟡 Medium · Conceptual · Asked 1×How is groups typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving medallion?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with CDC?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving scheduler?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using executor?🟢 Easy · Conceptual · Asked 1×When is executor a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×When is workers a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Explain the role of ETL in production systems.🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands ETL?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving travel?🟡 Medium · Conceptual · Asked 1×How does Apache Hudi work at a high level?🟡 Medium · Conceptual · Asked 1×How does data catalogs affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between late arriving data and exactly once processing, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving Flink?🟡 Medium · Debugging · Asked 1×How does Trino affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does Amazon EMR affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on BigQuery ingestion?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses dbt?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Apache Kafka?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Spark Structured Streaming?🟡 Medium · Conceptual · Asked 1×How would you compare Kafka partitions and Kafka consumer groups for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using ORC?🟡 Medium · Conceptual · Asked 1×How would you compare Delta Lake and Apache Iceberg for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using data warehouses?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving fact tables?🟡 Medium · Debugging · Asked 1×How would you compare dimension tables and data quality for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between event time and watermarks, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare late arriving data and exactly once processing for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using exactly once processing?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on exactly once processing?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on idempotent pipelines?🟡 Medium · Conceptual · Asked 1×How does idempotent pipelines affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Flink?🟡 Medium · Conceptual · Asked 1×How would you compare Beam and Trino for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using Trino?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Amazon EMR?🟡 Medium · Conceptual · Asked 1×What security considerations apply to XCom?🔴 Hard · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands task?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses scheduler?🟡 Medium · Behavioral · Asked 1×Explain the role of executor in production systems.🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where workers would be useful.🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using retries?🟢 Easy · Conceptual · Asked 1×How should a system using catchup be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What metrics would you monitor for catchup?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses dynamic?🟡 Medium · Behavioral · Asked 1×Explain the role of mapping in production systems.🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands lakehouse?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to architecture safely?🔴 Hard · System Design · Asked 1×What would you inspect first when schema is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you design for failure recovery around schema?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving changing?🟡 Medium · Debugging · Asked 1×What are common mistakes when using dimensions?🟡 Medium · Debugging · Asked 1×How is quality typically used in a real system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands workload?🟡 Medium · Conceptual · Asked 1×When would you use monitors, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands monitors?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data lakehouses?🟡 Medium · Debugging · Asked 1×What is the difference between data modeling and star schema, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare data catalogs and CDC for a production system?🔴 Hard · Conceptual · Asked 1×How does Beam work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Trino?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Presto?🟡 Medium · Conceptual · Asked 1×What is the difference between ETL and ELT, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using ELT?🟡 Medium · Conceptual · Asked 1×What is data pipelines, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between batch processing and stream processing, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using schema registry?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around SLAs?🔴 Hard · System Design · Asked 1×What are common mistakes when using dynamic?🟡 Medium · Debugging · Asked 1×What security considerations apply to dynamic?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving mapping?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with deferrable?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to ETL safely?🔴 Hard · System Design · Asked 1×How would you document a production design that uses ELT?🟡 Medium · Behavioral · Asked 1×How is scheduler typically used in a real system?🟡 Medium · Conceptual · Asked 1×When is lakes a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands dimensional?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using slowly?🟢 Easy · Conceptual · Asked 1×How would you implement or configure changing in a production environment?🟡 Medium · Coding · Asked 1×Which configuration choices matter most for changing?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for dimensions?🟡 Medium · Conceptual · Asked 1×How would you implement or configure CDC in a production environment?🟡 Medium · Coding · Asked 1×How should a system using CDC be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What would you inspect first when CDC is slow or unstable?🟡 Medium · Debugging · Asked 1×Why is the use of quality important in production?🟢 Easy · Conceptual · Asked 1×What would you inspect first when quality is slow or unstable?🟡 Medium · Debugging · Asked 1×Why is the use of Snowflake important in production?🟢 Easy · Conceptual · Asked 1×How does time compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Delta Lake?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses data modeling?🟡 Medium · Conceptual · Asked 1×How does data quality affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Fivetran?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on ELT?🟡 Medium · Conceptual · Asked 1×What is batch processing, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving catchup?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving groups?🟡 Medium · Debugging · Asked 1×When is dynamic a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How does deferrable compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for lakehouse?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where medallion would be useful.🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for architecture?🟡 Medium · Conceptual · Asked 1×How does dimensional compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on schema?🟡 Medium · System Design · Asked 1×How would you test a production implementation that uses dimensions?🟡 Medium · Other · Asked 1×How would you test a production implementation that uses evolution?🟡 Medium · Other · Asked 1×What follow-up could reveal whether a candidate really understands evolution?🟡 Medium · Conceptual · Asked 1×When is operators a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where executor would be useful.🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving workers?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving fact?🟡 Medium · Debugging · Asked 1×What follow-up could reveal whether a candidate really understands fact?🟡 Medium · Conceptual · Asked 1×When is pruning a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with monitors?🟡 Medium · Conceptual · Asked 1×What would you inspect first when cost is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to distribution safely?🔴 Hard · System Design · Asked 1×How is workload typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure ELT in a production environment?🟡 Medium · Coding · Asked 1×What metrics would you monitor for sensors?🟡 Medium · Conceptual · Asked 1×When is instances a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Why is the use of catchup important in production?🟢 Easy · Conceptual · Asked 1×When is catchup a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on mapping?🟡 Medium · System Design · Asked 1×Explain the role of datasets in production systems.🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for dimensional?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving dimensional?🟡 Medium · Conceptual · Asked 1×What security considerations apply to star?🔴 Hard · Conceptual · Asked 1×When is slowly a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using evolution?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to evolution safely?🔴 Hard · System Design · Asked 1×How is distribution typically used in a real system?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for travel?🟡 Medium · Conceptual · Asked 1×How would you compare ETL and ELT for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between stream processing and Apache Spark, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using Dagster?🟡 Medium · Conceptual · Asked 1×How does Parquet affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is ORC, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is Apache Iceberg, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does data lakes affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on data warehouses?🟡 Medium · Conceptual · Asked 1×What is the difference between slowly changing dimensions and fact tables, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using data catalogs?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses CDC?🟡 Medium · Conceptual · Asked 1×When would you choose change data capture in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using idempotent pipelines?🟡 Medium · Conceptual · Asked 1×How would you compare Great Expectations and Airbyte for a production system?🔴 Hard · Conceptual · Asked 1×What is Airbyte, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for lakes?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around architecture?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands snowflake?🟡 Medium · Conceptual · Asked 1×How should a system using dimensions be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you test a production implementation that uses CDC?🟡 Medium · Other · Asked 1×What metrics would you monitor for CDC?🟡 Medium · Conceptual · Asked 1×How would you implement or configure datasets in a production environment?🟡 Medium · Coding · Asked 1×How would you design for failure recovery around ETL?🔴 Hard · System Design · Asked 1×Explain the role of ELT in production systems.🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for operators?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with instances?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using scheduler?🟡 Medium · Debugging · Asked 1×Explain the role of workers in production systems.🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with workers?🟡 Medium · Conceptual · Asked 1×How would you implement or configure workers in a production environment?🟡 Medium · Coding · Asked 1×What security considerations apply to workers?🔴 Hard · Conceptual · Asked 1×What metrics would you monitor for workers?🟡 Medium · Conceptual · Asked 1×How is retries typically used in a real system?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for medallion?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with architecture?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for architecture?🟡 Medium · Conceptual · Asked 1×How would you implement or configure dimensional in a production environment?🟡 Medium · Coding · Asked 1×Describe a realistic interview scenario where schema would be useful.🟡 Medium · Conceptual · Asked 1×When is schema a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on slowly?🟡 Medium · System Design · Asked 1×Why is the use of lakes important in production?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving deferrable?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using data warehouses?🟡 Medium · Conceptual · Asked 1×What is the difference between data lakehouses and data modeling, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose Kafka Connect in a real project?🟡 Medium · Conceptual · Asked 1×How does stream processing affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does PySpark affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you implement or configure pruning in a production environment?🟡 Medium · Coding · Asked 1×When would you use workload, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with workload?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving workload?🟡 Medium · Debugging · Asked 1×What would you inspect first when workload is slow or unstable?🟡 Medium · Debugging · Asked 1×When would you use time, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for time?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for travel?🟡 Medium · Conceptual · Asked 1×How does travel compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using mapping?🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands mapping?🟡 Medium · Conceptual · Asked 1×How should a system using datasets be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Explain the role of architecture in production systems.🟢 Easy · Conceptual · Asked 1×What metrics would you monitor for slowly?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using changing?🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for quality?🟡 Medium · Conceptual · Asked 1×Why is the use of operators important in production?🟢 Easy · Conceptual · Asked 1×How is instances typically used in a real system?🟡 Medium · Conceptual · Asked 1×Why is the use of executor important in production?🟢 Easy · Conceptual · Asked 1×How would you migrate an existing system to workers safely?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with ELT?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for fact?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for fact?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using distribution?🟡 Medium · Debugging · Asked 1×When is monitors a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving time?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using travel?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using Apache Spark?🟡 Medium · Conceptual · Asked 1×When would you choose Spark Structured Streaming in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare Dagster and Prefect for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using Prefect?🟡 Medium · Conceptual · Asked 1×How would you compare Prefect and dbt for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare Kafka consumer groups and Kafka offsets for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using Parquet?🟡 Medium · Conceptual · Asked 1×What is the difference between star schema and snowflake schema, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving Debezium?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on Great Expectations?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Airbyte?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Apache Iceberg?🟡 Medium · Conceptual · Asked 1×When would you choose data warehouses in a real project?🟡 Medium · Conceptual · Asked 1×What is slowly changing dimensions, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does data quality work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Flink?🟡 Medium · Conceptual · Asked 1×How does BigQuery ingestion work at a high level?🟡 Medium · Conceptual · Asked 1×How does Spark Structured Streaming work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Apache Airflow?🟡 Medium · Conceptual · Asked 1×How does Apache Airflow affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Dagster?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Kafka partitions?🟡 Medium · Conceptual · Asked 1×When would you choose Kafka consumer groups in a real project?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands DAG?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using operators?🟢 Easy · Conceptual · Asked 1×How is executor typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure executor in a production environment?🟡 Medium · Coding · Asked 1×How would you optimize a system that depends on executor?🟡 Medium · System Design · Asked 1×What follow-up could reveal whether a candidate really understands executor?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving SLAs?🟡 Medium · Debugging · Asked 1×When would you use groups, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands groups?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving dynamic?🟡 Medium · Debugging · Asked 1×What security considerations apply to lakes?🔴 Hard · Conceptual · Asked 1×What are common mistakes when using medallion?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving architecture?🟡 Medium · Debugging · Asked 1×Explain the role of dimensional in production systems.🟢 Easy · Conceptual · Asked 1×What are common mistakes when using dimensional?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to changing safely?🔴 Hard · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using evolution?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where workload would be useful.🟡 Medium · Conceptual · Asked 1×Why is the use of cost important in production?🟢 Easy · Conceptual · Asked 1×How should a system using Snowflake be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for distribution?🟡 Medium · Conceptual · Asked 1×How should a system using pruning be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How should a system using monitors be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around monitors?🔴 Hard · System Design · Asked 1×What metrics would you monitor for time?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for time?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses travel?🟡 Medium · Other · Asked 1×How does ELT affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare ELT and data pipelines for a production system?🔴 Hard · Conceptual · Asked 1×When would you choose PySpark in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Delta Lake?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on star schema?🟡 Medium · Conceptual · Asked 1×How does star schema affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare star schema and snowflake schema for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving snowflake schema?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using data quality?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on watermarks?🟡 Medium · Conceptual · Asked 1×How does Presto affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does AWS Glue work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using AWS Glue?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Amazon EMR?🟡 Medium · Debugging · Asked 1×When would you choose BigQuery ingestion in a real project?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around dynamic?🔴 Hard · System Design · Asked 1×How does mapping compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with ETL?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where ETL would be useful.🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with DAG?🟡 Medium · Conceptual · Asked 1×How would you implement or configure instances in a production environment?🟡 Medium · Coding · Asked 1×How would you troubleshoot a problem involving lakes?🟡 Medium · Debugging · Asked 1×When would you use dimensional, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using star?🟢 Easy · Conceptual · Asked 1×How would you document a production design that uses schema?🟡 Medium · Behavioral · Asked 1×What security considerations apply to changing?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using data modeling?🟡 Medium · Conceptual · Asked 1×What is fact tables, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using exactly once processing?🟡 Medium · Conceptual · Asked 1×How would you compare Flink and Beam for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between Apache Spark and PySpark, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is Kafka offsets, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where distribution would be useful.🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses monitors?🟡 Medium · Other · Asked 1×How does monitors compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where time would be useful.🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where travel would be useful.🟡 Medium · Conceptual · Asked 1×How should a system using ETL be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How does ETL compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with lakes?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands SLAs?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for mapping?🟡 Medium · Conceptual · Asked 1×When would you use warehouses, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using warehouses?🟡 Medium · Debugging · Asked 1×What edge cases should an interviewer ask about for lakehouse?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses medallion?🟡 Medium · Other · Asked 1×What metrics would you monitor for dimensional?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around star?🔴 Hard · System Design · Asked 1×What security considerations apply to quality?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving sensors?🟡 Medium · Debugging · Asked 1×How would you implement or configure sensors in a production environment?🟡 Medium · Coding · Asked 1×How does sensors compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure SLAs in a production environment?🟡 Medium · Coding · Asked 1×Describe a realistic interview scenario where Snowflake would be useful.🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving Snowflake?🟡 Medium · Conceptual · Asked 1×When would you use travel, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure travel in a production environment?🟡 Medium · Coding · Asked 1×What is data catalogs, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses data validation?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Kafka Connect?🟡 Medium · Conceptual · Asked 1×How does Amazon EMR work at a high level?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using ETL?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Apache Airflow?🟡 Medium · Debugging · Asked 1×What is the difference between Apache Kafka and Kafka partitions, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Kafka consumer groups?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using ELT?🟡 Medium · Debugging · Asked 1×How would you explain the trade-off between correctness and performance when using task?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around workers?🔴 Hard · System Design · Asked 1×How is SLAs typically used in a real system?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where mapping would be useful.🟡 Medium · Conceptual · Asked 1×When would you use datasets, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses dimensional?🟡 Medium · Other · Asked 1×What security considerations apply to schema?🔴 Hard · Conceptual · Asked 1×When would you use slowly, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses CDC?🟡 Medium · Behavioral · Asked 1×How would you optimize a system that depends on quality?🟡 Medium · System Design · Asked 1×When would you use Snowflake, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with fact?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving distribution?🟡 Medium · Conceptual · Asked 1×Explain the role of monitors in production systems.🟢 Easy · Conceptual · Asked 1×What would you inspect first when time is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving travel?🟡 Medium · Debugging · Asked 1×How would you design for failure recovery around travel?🔴 Hard · System Design · Asked 1×What is the difference between Apache Airflow and Dagster, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does Apache Kafka affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is Kafka partitions, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare data lineage and data catalogs for a production system?🔴 Hard · Conceptual · Asked 1×When would you choose CDC in a real project?🟡 Medium · Conceptual · Asked 1×How does Debezium work at a high level?🟡 Medium · Conceptual · Asked 1×How does data validation affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare Amazon EMR and BigQuery ingestion for a production system?🔴 Hard · Conceptual · Asked 1×How would you implement or configure star in a production environment?🟡 Medium · Coding · Asked 1×Explain the role of snowflake in production systems.🟢 Easy · Conceptual · Asked 1×What would you inspect first when changing is slow or unstable?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where quality would be useful.🟡 Medium · Conceptual · Asked 1×When would you use catchup, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around catchup?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around datasets?🔴 Hard · System Design · Asked 1×When is ETL a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for ELT?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for DAG?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses task?🟡 Medium · Behavioral · Asked 1×Describe a realistic interview scenario where instances would be useful.🟡 Medium · Conceptual · Asked 1×When would you use scheduler, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands scheduler?🟡 Medium · Conceptual · Asked 1×What security considerations apply to retries?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for instances?🟡 Medium · Conceptual · Asked 1×How would you implement or configure scheduler in a production environment?🟡 Medium · Coding · Asked 1×When would you use executor, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What would you inspect first when snowflake is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you monitor and alert on failures involving slowly?🟡 Medium · Conceptual · Asked 1×How should a system using evolution be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Describe a realistic interview scenario where evolution would be useful.🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for ELT?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around ELT?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands ELT?🟡 Medium · Conceptual · Asked 1×What would you inspect first when SLAs is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you optimize a system that depends on catchup?🟡 Medium · System Design · Asked 1×What would you inspect first when mapping is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on Apache Hudi?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses data lakehouses?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using star schema?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving idempotent pipelines?🟡 Medium · Debugging · Asked 1×How does Presto work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Databricks?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses BigQuery ingestion?🟡 Medium · Conceptual · Asked 1×How does data pipelines work at a high level?🟡 Medium · Conceptual · Asked 1×How does Apache Spark affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does Spark SQL work at a high level?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for fact?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using distribution?🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using travel?🟢 Easy · Conceptual · Asked 1×How is datasets typically used in a real system?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where lakehouse would be useful.🟡 Medium · Conceptual · Asked 1×How would you implement or configure architecture in a production environment?🟡 Medium · Coding · Asked 1×How would you design for failure recovery around dimensional?🔴 Hard · System Design · Asked 1×Explain the role of star in production systems.🟢 Easy · Conceptual · Asked 1×How is changing typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you implement or configure evolution in a production environment?🟡 Medium · Coding · Asked 1×How would you implement or configure operators in a production environment?🟡 Medium · Coding · Asked 1×Why is the use of task important in production?🟢 Easy · Conceptual · Asked 1×What benefits and trade-offs come with task?🟡 Medium · Conceptual · Asked 1×What would you inspect first when scheduler is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you design for failure recovery around executor?🔴 Hard · System Design · Asked 1×How would you document a production design that uses retries?🟡 Medium · Behavioral · Asked 1×How would you explain the trade-off between correctness and performance when using pruning?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using ELT?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Kafka consumer groups?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Avro?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using fact tables?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses data quality?🟡 Medium · Conceptual · Asked 1×What is the difference between data catalogs and CDC, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare event time and watermarks for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using watermarks?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses idempotent pipelines?🟡 Medium · Conceptual · Asked 1×How does Fivetran affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose Delta Lake in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using idempotent pipelines?🟡 Medium · Conceptual · Asked 1×What is Fivetran, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using Apache Spark?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Apache Spark?🟡 Medium · Conceptual · Asked 1×When would you choose Apache Airflow in a real project?🟡 Medium · Conceptual · Asked 1×What security considerations apply to sensors?🔴 Hard · Conceptual · Asked 1×How would you monitor and alert on failures involving sensors?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on task?🟡 Medium · System Design · Asked 1×How would you optimize a system that depends on instances?🟡 Medium · System Design · Asked 1×How would you test a production implementation that uses workers?🟡 Medium · Other · Asked 1×What edge cases should an interviewer ask about for groups?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where dynamic would be useful.🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around mapping?🔴 Hard · System Design · Asked 1×How is medallion typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on architecture?🟡 Medium · System Design · Asked 1×How would you troubleshoot a problem involving dimensional?🟡 Medium · Debugging · Asked 1×How should a system using schema be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using Snowflake?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on travel?🟡 Medium · System Design · Asked 1×How does pruning compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using workload?🟡 Medium · Debugging · Asked 1×How would you implement or configure monitors in a production environment?🟡 Medium · Coding · Asked 1×How can you improve the performance of a system that uses Apache Spark?🟡 Medium · Conceptual · Asked 1×How would you compare PySpark and Spark SQL for a production system?🔴 Hard · Conceptual · Asked 1×How does Spark SQL affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Dagster?🟡 Medium · Conceptual · Asked 1×What is Parquet, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Delta Lake work at a high level?🟡 Medium · Conceptual · Asked 1×What is the difference between Apache Hudi and data lakes, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is data lakes, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does data modeling affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using data validation?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Great Expectations?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Fivetran?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Fivetran?🟡 Medium · Conceptual · Asked 1×What is Databricks, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using AWS Glue?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses SLAs?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for mapping?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where datasets would be useful.🟡 Medium · Conceptual · Asked 1×When is ELT a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using sensors?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving task?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to task safely?🔴 Hard · System Design · Asked 1×What benefits and trade-offs come with SLAs?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on lakes?🟡 Medium · System Design · Asked 1×What follow-up could reveal whether a candidate really understands medallion?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where changing would be useful.🟡 Medium · Conceptual · Asked 1×What is the difference between ORC and Delta Lake, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on data lakehouses?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using data lineage?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses data catalogs?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Debezium?🟡 Medium · Conceptual · Asked 1×How would you compare exactly once processing and idempotent pipelines for a production system?🔴 Hard · Conceptual · Asked 1×How does Kafka Connect work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Kafka Connect?🟡 Medium · Conceptual · Asked 1×How does Flink work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Beam?🟡 Medium · Conceptual · Asked 1×How would you compare Spark SQL and Spark Structured Streaming for a production system?🔴 Hard · Conceptual · Asked 1×What is the difference between Spark Structured Streaming and Apache Airflow, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose Dagster in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Kafka consumer groups?🟡 Medium · Debugging · Asked 1×How should a system using distribution be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What would you inspect first when pruning is slow or unstable?🟡 Medium · Debugging · Asked 1×What security considerations apply to time?🔴 Hard · Conceptual · Asked 1×How would you migrate an existing system to time safely?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on ETL?🟡 Medium · System Design · Asked 1×What edge cases should an interviewer ask about for catchup?🟡 Medium · Conceptual · Asked 1×When is datasets a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What security considerations apply to deferrable?🔴 Hard · Conceptual · Asked 1×Why is the use of lakehouse important in production?🟢 Easy · Conceptual · Asked 1×How would you design for failure recovery around lakehouse?🔴 Hard · System Design · Asked 1×How would you explain the trade-off between correctness and performance when using architecture?🟢 Easy · Conceptual · Asked 1×Why is the use of snowflake important in production?🟢 Easy · Conceptual · Asked 1×What security considerations apply to snowflake?🔴 Hard · Conceptual · Asked 1×How would you document a production design that uses changing?🟡 Medium · Behavioral · Asked 1×How would you optimize a system that depends on CDC?🟡 Medium · System Design · Asked 1×What benefits and trade-offs come with sensors?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to XCom safely?🔴 Hard · System Design · Asked 1×How would you monitor and alert on failures involving instances?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on scheduler?🟡 Medium · System Design · Asked 1×Which configuration choices matter most for workers?🟡 Medium · Conceptual · Asked 1×Why is the use of retries important in production?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving retries?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving distribution?🟡 Medium · Debugging · Asked 1×What follow-up could reveal whether a candidate really understands distribution?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with time?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using time?🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands time?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Apache Iceberg?🟡 Medium · Conceptual · Asked 1×How does data modeling work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose fact tables in a real project?🟡 Medium · Conceptual · Asked 1×What is data lineage, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between exactly once processing and idempotent pipelines, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving Airbyte?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on Airbyte?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Presto?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on AWS Glue?🟡 Medium · Conceptual · Asked 1×How would you compare AWS Glue and Amazon EMR for a production system?🔴 Hard · Conceptual · Asked 1×How would you test a component that depends on batch processing?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on dbt?🟡 Medium · Conceptual · Asked 1×How would you compare Kafka offsets and schema registry for a production system?🔴 Hard · Conceptual · Asked 1×How would you design for failure recovery around instances?🔴 Hard · System Design · Asked 1×How should a system using scheduler be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What would you inspect first when workers is slow or unstable?🟡 Medium · Debugging · Asked 1×What security considerations apply to SLAs?🔴 Hard · Conceptual · Asked 1×How would you migrate an existing system to SLAs safely?🔴 Hard · System Design · Asked 1×What are common mistakes when using deferrable?🟡 Medium · Debugging · Asked 1×When would you use lakehouse, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using medallion?🟢 Easy · Conceptual · Asked 1×What would you inspect first when dimensional is slow or unstable?🟡 Medium · Debugging · Asked 1×Explain the role of slowly in production systems.🟢 Easy · Conceptual · Asked 1×Explain the role of changing in production systems.🟢 Easy · Conceptual · Asked 1×How does dimensions compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around CDC?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for pruning?🟡 Medium · Conceptual · Asked 1×How does data pipelines affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare stream processing and Apache Spark for a production system?🔴 Hard · Conceptual · Asked 1×How would you compare Avro and Parquet for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving ORC?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using data modeling?🟡 Medium · Conceptual · Asked 1×What is the difference between fact tables and dimension tables, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Debezium?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on event time?🟡 Medium · Conceptual · Asked 1×How would you compare data validation and Great Expectations for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving Trino?🟡 Medium · Debugging · Asked 1×What is the difference between AWS Glue and Amazon EMR, and when would you use each?🟢 Easy · Conceptual · Asked 1×What would you inspect first when lakehouse is slow or unstable?🟡 Medium · Debugging · Asked 1×When is lakehouse a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on medallion?🟡 Medium · System Design · Asked 1×Why is the use of dimensions important in production?🟢 Easy · Conceptual · Asked 1×What would you inspect first when dimensions is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you implement or configure quality in a production environment?🟡 Medium · Coding · Asked 1×What are common mistakes when using catchup?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for groups?🟡 Medium · Conceptual · Asked 1×Explain the role of dynamic in production systems.🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using datasets?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for deferrable?🟡 Medium · Conceptual · Asked 1×How does DAG compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using DAG?🟢 Easy · Conceptual · Asked 1×What are common mistakes when using operators?🟡 Medium · Debugging · Asked 1×What would you inspect first when instances is slow or unstable?🟡 Medium · Debugging · Asked 1×Why is the use of DAG important in production?🟢 Easy · Conceptual · Asked 1×When would you use DAG, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What would you inspect first when operators is slow or unstable?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where warehouses would be useful.🟡 Medium · Conceptual · Asked 1×How is snowflake typically used in a real system?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using snowflake?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for snowflake?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for dimensions?🟡 Medium · Conceptual · Asked 1×When would you use quality, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How does quality compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How does ELT compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for SLAs?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where catchup would be useful.🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses mapping?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for datasets?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for datasets?🟡 Medium · Conceptual · Asked 1×How would you compare Parquet and ORC for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving star schema?🟡 Medium · Debugging · Asked 1×What is the difference between Debezium and event time, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses exactly once processing?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Presto?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Amazon EMR?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using PySpark?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Spark SQL?🟡 Medium · Conceptual · Asked 1×How does Prefect work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Apache Kafka?🟡 Medium · Conceptual · Asked 1×What would you inspect first when fact is slow or unstable?🟡 Medium · Debugging · Asked 1×Why is the use of distribution important in production?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on distribution?🟡 Medium · System Design · Asked 1×What security considerations apply to pruning?🔴 Hard · Conceptual · Asked 1×What security considerations apply to workload?🔴 Hard · Conceptual · Asked 1×How would you test a production implementation that uses time?🟡 Medium · Other · Asked 1×Explain the role of groups in production systems.🟢 Easy · Conceptual · Asked 1×How would you document a production design that uses groups?🟡 Medium · Behavioral · Asked 1×How is dynamic typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses mapping?🟡 Medium · Other · Asked 1×How would you monitor and alert on failures involving warehouses?🟡 Medium · Conceptual · Asked 1×How would you implement or configure schema in a production environment?🟡 Medium · Coding · Asked 1×How would you explain the trade-off between correctness and performance when using schema?🟢 Easy · Conceptual · Asked 1×How would you migrate an existing system to snowflake safely?🔴 Hard · System Design · Asked 1×How would you troubleshoot a problem involving slowly?🟡 Medium · Debugging · Asked 1×How would you monitor and alert on failures involving dimensions?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses operators?🟡 Medium · Other · Asked 1×How would you optimize a system that depends on XCom?🟡 Medium · System Design · Asked 1×What security considerations apply to instances?🔴 Hard · Conceptual · Asked 1×Explain the role of SLAs in production systems.🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving fact?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around pruning?🔴 Hard · System Design · Asked 1×What metrics would you monitor for workload?🟡 Medium · Conceptual · Asked 1×How should a system using time be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What is the difference between PySpark and Spark SQL, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on Prefect?🟡 Medium · Conceptual · Asked 1×When would you choose data lakes in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses data lakes?🟡 Medium · Conceptual · Asked 1×When would you choose data lakehouses in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using slowly changing dimensions?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on data quality?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving CDC?🟡 Medium · Debugging · Asked 1×What is change data capture, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving exactly once processing?🟡 Medium · Debugging · Asked 1×When would you choose Trino in a real project?🟡 Medium · Conceptual · Asked 1×What is AWS Glue, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is Apache Hudi, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Apache Hudi affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using star schema?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on snowflake schema?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving dimension tables?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using Databricks?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses ELT?🟡 Medium · Conceptual · Asked 1×How would you compare data pipelines and batch processing for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using Prefect?🟡 Medium · Conceptual · Asked 1×How does Kafka offsets affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for sensors?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with executor?🟡 Medium · Conceptual · Asked 1×How should a system using executor be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What metrics would you monitor for SLAs?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses datasets?🟡 Medium · Behavioral · Asked 1×How would you optimize a system that depends on lakehouse?🟡 Medium · System Design · Asked 1×When would you use architecture, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Why is the use of star important in production?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving star?🟡 Medium · Conceptual · Asked 1×How does snowflake compare with a common alternative?🟡 Medium · Conceptual · Asked 1×What security considerations apply to evolution?🔴 Hard · Conceptual · Asked 1×When would you use cost, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on time?🟡 Medium · System Design · Asked 1×What follow-up could reveal whether a candidate really understands Snowflake?🟡 Medium · Conceptual · Asked 1×What security considerations apply to distribution?🔴 Hard · Conceptual · Asked 1×When is workload a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving workload?🟡 Medium · Conceptual · Asked 1×How is time typically used in a real system?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with travel?🟡 Medium · Conceptual · Asked 1×What is the difference between ELT and data pipelines, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using PySpark?🟡 Medium · Conceptual · Asked 1×How does Kafka partitions affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare ORC and Delta Lake for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses Apache Iceberg?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data lineage?🟡 Medium · Debugging · Asked 1×How would you compare watermarks and late arriving data for a production system?🔴 Hard · Conceptual · Asked 1×What is late arriving data, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between Airbyte and Fivetran, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does Fivetran work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving AWS Glue?🟡 Medium · Debugging · Asked 1×Explain the role of catchup in production systems.🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using catchup?🟢 Easy · Conceptual · Asked 1×Why is the use of groups important in production?🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for ETL?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using XCom?🟡 Medium · Debugging · Asked 1×When would you use task, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How should a system using instances be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Why is the use of scheduler important in production?🟢 Easy · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands architecture?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with dimensional?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to dimensional safely?🔴 Hard · System Design · Asked 1×When would you use snowflake, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of CDC in production systems.🟢 Easy · Conceptual · Asked 1×Which configuration choices matter most for CDC?🟡 Medium · Conceptual · Asked 1×When is CDC a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for evolution?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Parquet?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on Parquet?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using Apache Hudi?🟡 Medium · Conceptual · Asked 1×What is star schema, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×When would you choose slowly changing dimensions in a real project?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on fact tables?🟡 Medium · Conceptual · Asked 1×What is exactly once processing, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you troubleshoot a problem involving Beam?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Beam?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Presto?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with distribution?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on workload?🟡 Medium · System Design · Asked 1×How would you document a production design that uses time?🟡 Medium · Behavioral · Asked 1×When would you use mapping, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you implement or configure deferrable in a production environment?🟡 Medium · Coding · Asked 1×How should a system using lakehouse be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you test a production implementation that uses snowflake?🟡 Medium · Other · Asked 1×When would you use changing, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of dimensions in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of CDC important in production?🟢 Easy · Conceptual · Asked 1×How would you monitor and alert on failures involving CDC?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses DAG?🟡 Medium · Behavioral · Asked 1×What security considerations apply to operators?🔴 Hard · Conceptual · Asked 1×What are common mistakes when using workers?🟡 Medium · Debugging · Asked 1×Describe a realistic interview scenario where pruning would be useful.🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using monitors?🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using cost?🟢 Easy · Conceptual · Asked 1×How does star schema work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving watermarks?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses watermarks?🟡 Medium · Conceptual · Asked 1×How does Great Expectations affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Kafka Connect?🟡 Medium · Conceptual · Asked 1×How does Apache Airflow work at a high level?🟡 Medium · Conceptual · Asked 1×What is the difference between dbt and Apache Kafka, and when would you use each?🟢 Easy · Conceptual · Asked 1×Explain the role of sensors in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of sensors important in production?🟢 Easy · Conceptual · Asked 1×Describe a realistic interview scenario where sensors would be useful.🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for sensors?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for XCom?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to instances safely?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands catchup?🟡 Medium · Conceptual · Asked 1×What would you inspect first when dynamic is slow or unstable?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with datasets?🟡 Medium · Conceptual · Asked 1×How is warehouses typically used in a real system?🟡 Medium · Conceptual · Asked 1×How does medallion compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around medallion?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around snowflake?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on changing?🟡 Medium · System Design · Asked 1×What edge cases should an interviewer ask about for CDC?🟡 Medium · Conceptual · Asked 1×Why is the use of evolution important in production?🟢 Easy · Conceptual · Asked 1×When is evolution a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using fact?🟡 Medium · Debugging · Asked 1×What metrics would you monitor for monitors?🟡 Medium · Conceptual · Asked 1×When would you choose ETL in a real project?🟡 Medium · Conceptual · Asked 1×How does Prefect affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How does Kafka partitions work at a high level?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Kafka partitions?🟡 Medium · Debugging · Asked 1×What is the difference between Parquet and ORC, and when would you use each?🟢 Easy · Conceptual · Asked 1×When would you choose ORC in a real project?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using slowly changing dimensions?🟡 Medium · Conceptual · Asked 1×How would you compare slowly changing dimensions and fact tables for a production system?🔴 Hard · Conceptual · Asked 1×How can you improve the performance of a system that uses fact tables?🟡 Medium · Conceptual · Asked 1×What is dimension tables, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between CDC and change data capture, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using Debezium?🟡 Medium · Conceptual · Asked 1×How does data validation work at a high level?🟡 Medium · Conceptual · Asked 1×How does AWS Glue affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving lakes?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses lakes?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for medallion?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with snowflake?🟡 Medium · Conceptual · Asked 1×How is slowly typically used in a real system?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with slowly?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with changing?🟡 Medium · Conceptual · Asked 1×When is changing a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How is dimensions typically used in a real system?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands dynamic?🟡 Medium · Conceptual · Asked 1×How is lakes typically used in a real system?🟡 Medium · Conceptual · Asked 1×When is XCom a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for scheduler?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for executor?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using retries?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses sensors?🟡 Medium · Behavioral · Asked 1×How would you troubleshoot a problem involving XCom?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to scheduler safely?🔴 Hard · System Design · Asked 1×How should a system using retries be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Which configuration choices matter most for retries?🟡 Medium · Conceptual · Asked 1×When would you use SLAs, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using lakes?🟢 Easy · Conceptual · Asked 1×Why is the use of architecture important in production?🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for dimensional?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for schema?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses snowflake?🟡 Medium · Behavioral · Asked 1×How would you document a production design that uses dimensions?🟡 Medium · Behavioral · Asked 1×Explain the role of lakes in production systems.🟢 Easy · Conceptual · Asked 1×How does SLAs compare with a common alternative?🟡 Medium · Conceptual · Asked 1×When is SLAs a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How would you migrate an existing system to groups safely?🔴 Hard · System Design · Asked 1×How would you optimize a system that depends on deferrable?🟡 Medium · System Design · Asked 1×How does ORC work at a high level?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using data lakehouses?🟡 Medium · Conceptual · Asked 1×What is the difference between dimension tables and data quality, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does CDC affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose Debezium in a real project?🟡 Medium · Conceptual · Asked 1×How does exactly once processing work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose Fivetran in a real project?🟡 Medium · Conceptual · Asked 1×What is the difference between Fivetran and Kafka Connect, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using Trino?🟡 Medium · Conceptual · Asked 1×How does BigQuery ingestion affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you compare Spark Structured Streaming and Apache Airflow for a production system?🔴 Hard · Conceptual · Asked 1×How would you troubleshoot a problem involving Prefect?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving dbt?🟡 Medium · Debugging · Asked 1×How would you test a component that depends on Kafka partitions?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Kafka offsets?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Kafka offsets?🟡 Medium · Conceptual · Asked 1×When would you use pruning, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for cost?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses cost?🟡 Medium · Behavioral · Asked 1×Why is the use of travel important in production?🟢 Easy · Conceptual · Asked 1×How should a system using travel be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What would you inspect first when travel is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you document a production design that uses travel?🟡 Medium · Behavioral · Asked 1×Describe a realistic interview scenario where SLAs would be useful.🟡 Medium · Conceptual · Asked 1×What would you inspect first when catchup is slow or unstable?🟡 Medium · Debugging · Asked 1×What benefits and trade-offs come with dynamic?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where architecture would be useful.🟡 Medium · Conceptual · Asked 1×When is architecture a poor choice for a production system?🟡 Medium · Conceptual · Asked 1×How is star typically used in a real system?🟡 Medium · Conceptual · Asked 1×How should a system using star be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How is schema typically used in a real system?🟡 Medium · Conceptual · Asked 1×Describe a realistic interview scenario where snowflake would be useful.🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses slowly?🟡 Medium · Behavioral · Asked 1×How would you monitor and alert on failures involving changing?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands CDC?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving DAG?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses sensors?🟡 Medium · Other · Asked 1×What security considerations apply to ETL?🔴 Hard · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands cost?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on data pipelines?🟡 Medium · Conceptual · Asked 1×When would you choose Spark SQL in a real project?🟡 Medium · Conceptual · Asked 1×What is Spark Structured Streaming, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What is the difference between Apache Iceberg and Apache Hudi, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you compare Apache Hudi and data lakes for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using data lakes?🟡 Medium · Conceptual · Asked 1×How would you compare data warehouses and data lakehouses for a production system?🔴 Hard · Conceptual · Asked 1×What are common mistakes engineers make when using data quality?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data catalogs?🟡 Medium · Debugging · Asked 1×What is the difference between change data capture and Debezium, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is Debezium, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does Kafka Connect affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses AWS Glue?🟡 Medium · Conceptual · Asked 1×What is Delta Lake, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses star schema?🟡 Medium · Conceptual · Asked 1×How does snowflake schema work at a high level?🟡 Medium · Conceptual · Asked 1×How does CDC work at a high level?🟡 Medium · Conceptual · Asked 1×How would you compare Debezium and event time for a production system?🔴 Hard · Conceptual · Asked 1×When would you choose exactly once processing in a real project?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving data validation?🟡 Medium · Debugging · Asked 1×What is ETL, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does PySpark work at a high level?🟡 Medium · Conceptual · Asked 1×What is Spark SQL, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are common mistakes engineers make when using Apache Airflow?🟡 Medium · Conceptual · Asked 1×What is Prefect, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How does dbt work at a high level?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Avro?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using DAG?🟡 Medium · Debugging · Asked 1×When would you use sensors, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving XCom?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses XCom?🟡 Medium · Behavioral · Asked 1×How would you explain the trade-off between correctness and performance when using dynamic?🟢 Easy · Conceptual · Asked 1×How would you test a production implementation that uses deferrable?🟡 Medium · Other · Asked 1×What metrics would you monitor for schema?🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands changing?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for quality?🟡 Medium · Conceptual · Asked 1×How is Snowflake typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on Snowflake?🟡 Medium · System Design · Asked 1×When would you use fact, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on fact?🟡 Medium · System Design · Asked 1×How can you improve the performance of a system that uses Spark SQL?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using dbt?🟡 Medium · Conceptual · Asked 1×What is the difference between data warehouses and data lakehouses, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is the difference between snowflake schema and slowly changing dimensions, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does slowly changing dimensions affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×When would you choose data quality in a real project?🟡 Medium · Conceptual · Asked 1×What is the difference between data quality and data lineage, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you test a component that depends on data catalogs?🟡 Medium · Conceptual · Asked 1×What is the difference between watermarks and late arriving data, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is the difference between data validation and Great Expectations, and when would you use each?🟢 Easy · Conceptual · Asked 1×How can you improve the performance of a system that uses Fivetran?🟡 Medium · Conceptual · Asked 1×What is the difference between Flink and Beam, and when would you use each?🟢 Easy · Conceptual · Asked 1×How would you implement or configure dynamic in a production environment?🟡 Medium · Coding · Asked 1×How would you migrate an existing system to dynamic safely?🔴 Hard · System Design · Asked 1×What are common mistakes when using datasets?🟡 Medium · Debugging · Asked 1×Explain the role of DAG in production systems.🟢 Easy · Conceptual · Asked 1×Why is the use of instances important in production?🟢 Easy · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using instances?🟢 Easy · Conceptual · Asked 1×How does scheduler compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses workers?🟡 Medium · Behavioral · Asked 1×What security considerations apply to dimensional?🔴 Hard · Conceptual · Asked 1×What are common mistakes when using schema?🟡 Medium · Debugging · Asked 1×How would you troubleshoot a problem involving schema?🟡 Medium · Debugging · Asked 1×What edge cases should an interviewer ask about for changing?🟡 Medium · Conceptual · Asked 1×When would you use dimensions, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on evolution?🟡 Medium · System Design · Asked 1×How does Apache Iceberg work at a high level?🟡 Medium · Conceptual · Asked 1×When would you choose snowflake schema in a real project?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using fact tables?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using CDC?🟡 Medium · Conceptual · Asked 1×How does watermarks affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×What is the difference between Azure Data Factory and AWS Glue, and when would you use each?🟢 Easy · Conceptual · Asked 1×How does ETL affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses stream processing?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Apache Spark?🟡 Medium · Debugging · Asked 1×How does Kafka consumer groups affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you document a production design that uses pruning?🟡 Medium · Behavioral · Asked 1×What are common mistakes when using monitors?🟡 Medium · Debugging · Asked 1×When would you use ETL, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×What edge cases should an interviewer ask about for ETL?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around warehouses?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to warehouses safely?🔴 Hard · System Design · Asked 1×Explain the role of lakehouse in production systems.🟢 Easy · Conceptual · Asked 1×How does lakehouse compare with a common alternative?🟡 Medium · Conceptual · Asked 1×Which configuration choices matter most for lakehouse?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with star?🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around changing?🔴 Hard · System Design · Asked 1×When would you use CDC, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How is evolution typically used in a real system?🟡 Medium · Conceptual · Asked 1×How should a system using quality be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you design for failure recovery around task?🔴 Hard · System Design · Asked 1×What edge cases should an interviewer ask about for retries?🟡 Medium · Conceptual · Asked 1×Why is the use of fact important in production?🟢 Easy · Conceptual · Asked 1×How would you document a production design that uses workload?🟡 Medium · Behavioral · Asked 1×Why is the use of monitors important in production?🟢 Easy · Conceptual · Asked 1×What are common mistakes when using cost?🟡 Medium · Debugging · Asked 1×What are common mistakes engineers make when using Delta Lake?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using Apache Hudi?🟡 Medium · Conceptual · Asked 1×What are common mistakes engineers make when using data lakes?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses slowly changing dimensions?🟡 Medium · Conceptual · Asked 1×What are the main trade-offs of using change data capture?🟡 Medium · Conceptual · Asked 1×When would you choose Airbyte in a real project?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses ETL?🟡 Medium · Conceptual · Asked 1×What is the difference between Dagster and Prefect, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is the difference between Kafka partitions and Kafka consumer groups, and when would you use each?🟢 Easy · Conceptual · Asked 1×What is Kafka consumer groups, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What would you inspect first when DAG is slow or unstable?🟡 Medium · Debugging · Asked 1×How would you migrate an existing system to DAG safely?🔴 Hard · System Design · Asked 1×When would you use operators, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on sensors?🟡 Medium · System Design · Asked 1×What follow-up could reveal whether a candidate really understands sensors?🟡 Medium · Conceptual · Asked 1×Explain the role of task in production systems.🟢 Easy · Conceptual · Asked 1×What edge cases should an interviewer ask about for instances?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving catchup?🟡 Medium · Conceptual · Asked 1×What are common mistakes when using groups?🟡 Medium · Debugging · Asked 1×How would you optimize a system that depends on dynamic?🟡 Medium · System Design · Asked 1×How should a system using warehouses be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×How would you migrate an existing system to star safely?🔴 Hard · System Design · Asked 1×What follow-up could reveal whether a candidate really understands schema?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on snowflake?🟡 Medium · System Design · Asked 1×How would you test a production implementation that uses slowly?🟡 Medium · Other · Asked 1×What would you inspect first when slowly is slow or unstable?🟡 Medium · Debugging · Asked 1×What are common mistakes when using changing?🟡 Medium · Debugging · Asked 1×How would you test a production implementation that uses changing?🟡 Medium · Other · Asked 1×How would you migrate an existing system to fact safely?🔴 Hard · System Design · Asked 1×How would you implement or configure distribution in a production environment?🟡 Medium · Coding · Asked 1×How would you troubleshoot a problem involving data pipelines?🟡 Medium · Debugging · Asked 1×When would you choose Prefect in a real project?🟡 Medium · Conceptual · Asked 1×What is dbt, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Avro?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Avro?🟡 Medium · Debugging · Asked 1×How can you improve the performance of a system that uses Parquet?🟡 Medium · Conceptual · Asked 1×What is data warehouses, and what problem does it solve?🟢 Easy · Conceptual · Asked 1×How would you compare data modeling and star schema for a production system?🔴 Hard · Conceptual · Asked 1×What are the main trade-offs of using Debezium?🟡 Medium · Conceptual · Asked 1×When would you choose data validation in a real project?🟡 Medium · Conceptual · Asked 1×When would you choose Great Expectations in a real project?🟡 Medium · Conceptual · Asked 1×How would you compare Kafka Connect and Flink for a production system?🔴 Hard · Conceptual · Asked 1×How does Beam affect reliability or scalability?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses lakes?🟡 Medium · Other · Asked 1×How should a system using lakes be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×Describe a realistic interview scenario where lakes would be useful.🟡 Medium · Conceptual · Asked 1×How would you design for failure recovery around lakes?🔴 Hard · System Design · Asked 1×Explain the role of warehouses in production systems.🟢 Easy · Conceptual · Asked 1×What would you inspect first when warehouses is slow or unstable?🟡 Medium · Debugging · Asked 1×Which configuration choices matter most for warehouses?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with medallion?🟡 Medium · Conceptual · Asked 1×How is architecture typically used in a real system?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving architecture?🟡 Medium · Conceptual · Asked 1×How would you optimize a system that depends on star?🟡 Medium · System Design · Asked 1×What edge cases should an interviewer ask about for star?🟡 Medium · Conceptual · Asked 1×What benefits and trade-offs come with schema?🟡 Medium · Conceptual · Asked 1×How would you implement or configure slowly in a production environment?🟡 Medium · Coding · Asked 1×How would you document a production design that uses evolution?🟡 Medium · Behavioral · Asked 1×What metrics would you monitor for groups?🟡 Medium · Conceptual · Asked 1×What security considerations apply to datasets?🔴 Hard · Conceptual · Asked 1×Which configuration choices matter most for datasets?🟡 Medium · Conceptual · Asked 1×When would you use ELT, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving DAG?🟡 Medium · Conceptual · Asked 1×How is operators typically used in a real system?🟡 Medium · Conceptual · Asked 1×Why is the use of XCom important in production?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on workers?🟡 Medium · System Design · Asked 1×Describe a realistic interview scenario where DAG would be useful.🟡 Medium · Conceptual · Asked 1×What follow-up could reveal whether a candidate really understands operators?🟡 Medium · Conceptual · Asked 1×How should a system using sensors be designed for high load or concurrency?🔴 Hard · System Design · Asked 1×What metrics would you monitor for dynamic?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for deferrable?🟡 Medium · Conceptual · Asked 1×How does architecture compare with a common alternative?🟡 Medium · Conceptual · Asked 1×How would you test a production implementation that uses star?🟡 Medium · Other · Asked 1×What metrics would you monitor for star?🟡 Medium · Conceptual · Asked 1×How would you monitor and alert on failures involving schema?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for snowflake?🟡 Medium · Conceptual · Asked 1×What metrics would you monitor for dimensions?🟡 Medium · Conceptual · Asked 1×How would you explain the trade-off between correctness and performance when using quality?🟢 Easy · Conceptual · Asked 1×How would you optimize a system that depends on ELT?🟡 Medium · System Design · Asked 1×When would you use lakes, and when would you choose an alternative?🟡 Medium · Conceptual · Asked 1×Explain the role of fact in production systems.🟢 Easy · Conceptual · Asked 1×What is the difference between data pipelines and batch processing, and when would you use each?🟢 Easy · Conceptual · Asked 1×What are the main trade-offs of using Spark SQL?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on Kafka consumer groups?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses Delta Lake?🟡 Medium · Conceptual · Asked 1×How would you troubleshoot a problem involving Apache Iceberg?🟡 Medium · Debugging · Asked 1×What are the main trade-offs of using snowflake schema?🟡 Medium · Conceptual · Asked 1×How does data catalogs work at a high level?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on change data capture?🟡 Medium · Conceptual · Asked 1×How can you improve the performance of a system that uses event time?🟡 Medium · Conceptual · Asked 1×How would you test a component that depends on data validation?🟡 Medium · Conceptual · Asked 1×What is your experience with Airflow and data grid?🟡 Medium · Behavioral · Asked 1×

🎤 Get Data Engineering questions answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500

Browse Other Topics

Devops (2903) Ai Machine Learning (2177) Cloud Devops (2007) Databases Sql (1479) Algorithms Data Structures (1411) Frontend (1233) Python (1180) Javascript Typescript (1178) Java (1172) Backend Apis (1054) Security (794) System Design (791) Php (766) Behavioral (420) Testing (419) Data Science (417) Streaming (417) Systems Networking (416) Databases Nosql (416) Big Data Spark (416) Mobile (416) Go (416) Rust (416) Software Engineering (416)