QUESTION BANK

530+ questions

Every question has a human-written rubric. Filter by topic, type, and difficulty.

Topic

Difficulty

Type

Access

530 questions

Ready to practice?

Get AI-powered feedback on your answers in real time.

Start Mock Interview

530+ questions

Clustered vs Non-Clustered Indexes

Window Functions Fundamentals

Slow Dashboard Query Debugging

Deduplication at Scale

Query Optimization with Skewed Joins

Sessionization with SQL

Slowly Changing Dimensions at Scale

Multi-Tenant Query Isolation

ETL vs ELT

Idempotent Pipeline Design

Multi-Source CDC Pipeline

Late-Arriving Data Handling

Data Quality Framework Design

Backfill Strategy for Historical Data

Star Schema vs Snowflake Schema

Fact Table Types

Modeling a Multi-Currency Fact Table

Data Vault vs Kimball for Enterprise DW

Modeling Many-to-Many Relationships

Data Catalog and Lineage System

Spark Transformations vs Actions

Partitioning in Spark

Debugging a Spark OOM

Handling Data Skew in Spark Joins

Small File Problem in Spark Output

Delta Lake vs Iceberg Architecture

PySpark SCD2 Implementation

Cost-Optimizing a Spark Cluster

Kafka Core Concepts

Kafka Consumer Lag Investigation

Real-Time Event Deduplication Pipeline

Kafka Topic Design for Event Sourcing

Cross-Region Kafka Replication

Generators vs Lists for Large Datasets

Concurrency for API Data Extraction

Building a Data Pipeline Framework

Memory-Efficient Processing of 100GB Files

Python Package Design for Shared ETL Logic

S3 Storage Classes for Data Lakes

Glue vs EMR Decision Framework

Serverless Real-Time Analytics Pipeline

Redshift Performance Troubleshooting

Multi-Account Data Mesh on AWS

Pipeline Failure in Production

Technical Disagreement with a Colleague

Scaling a System Beyond Its Limits

Bias-Variance Tradeoff

Precision vs. Recall

Feature Selection Strategy

Model Performance Degradation

A/B Testing an ML Model

Cross-Validation from Scratch

Transformer Architecture Basics

Backpropagation and Gradient Descent

Training Instability Debugging

Transfer Learning Strategy

Distributed Training Architecture

Embeddings and Vector Representations

Tokenization Strategies

Fine-Tuning vs. Prompting Decision

LLM Evaluation and Hallucination

LLM Fine-Tuning Pipeline

Multi-LLM Routing System

ML Pipeline Components

Model Serving Patterns

CI/CD for ML Models

GPU Cost Optimization

LLM Serving Infrastructure

Real-Time Recommendation System

Content Moderation at Scale

Real-Time Fraud Detection

Search Ranking System

Autonomous Driving Perception Pipeline

RAG Architecture Fundamentals

Chunking Strategies

RAG Quality Debugging

Multi-Modal RAG System

Embedding Model Selection and Optimization

Prompt Engineering Techniques