☁️

DevOps, Docker & AWS

The infrastructure side of a backend interview — AWS fundamentals (EC2, S3, VPC, IAM, RDS, DynamoDB, Lambda), and Docker from first principles through images, networking, volumes, and production security.

Git & GitHub

CI/CD Pipelines

Q

What is CI/CD? What does Continuous Integration and Continuous Delivery/Deployment actually mean in practice?

beginnerPro

Tests whether you know the distinction between Delivery (ready to deploy) and Deployment (auto-deployed) specifically.

Q

How do you write a GitHub Actions workflow that builds and tests a Spring Boot application?

intermediatePro

Tests whether you can actually write the YAML, not just describe CI/CD conceptually.

Q

How do you add a Docker build-and-push step to a GitHub Actions pipeline, and what's the difference between DockerHub, AWS ECR, and GitHub Container Registry?

intermediatePro

Tests whether you know how to wire the build step and where to actually push the resulting image.

Q

How do you securely pass secrets (AWS credentials, DB passwords) in a GitHub Actions workflow?

intermediatePro

Tests whether you know to use encrypted repository secrets rather than hardcoding credentials into workflow files.

Q

How do you implement a rollback strategy in your CI/CD pipeline if a deployment fails?

advancedPro

Tests whether you've actually planned for the failure path, not just the happy deploy path.

Q

How do you deploy a Dockerized Spring Boot app to AWS ECS/EKS from a GitHub Actions pipeline?

advancedPro

Tests whether you can connect the build, push, and deploy stages into one working end-to-end pipeline.

Q

What is the difference between blue-green deployment and rolling deployment in a CI/CD context?

advancedPro

Tests whether you know the tradeoff between instant-switch simplicity and gradual-rollout safety.

Object Storage (S3/MinIO)

Database Optimization Techniques

Q

How do you use EXPLAIN / EXPLAIN ANALYZE to find and fix a slow query?

intermediatePro

Tests whether you can actually read a query plan, not just know the command exists.

Q

What is a composite index, and when does column order inside it actually matter?

advancedPro

Tests whether you know a composite index is only useful for queries that filter on its leftmost columns first.

Q

Why should you always paginate large result sets, and what is keyset pagination?

advancedPro

Tests whether you know OFFSET-based pagination gets progressively slower on large tables, and keyset pagination avoids that.

Q

Why is a batch insert/update faster than doing it row by row, and how do you batch it in JPA?

advancedPro

Tests whether you know each round trip has fixed overhead, and batching amortizes that cost across many rows.

Q

What is a covering index and how does it eliminate table lookups entirely for a query?

advancedPro

Tests whether you know an index that already contains every selected column skips the extra trip to the actual table row.

Q

How does a type mismatch in a WHERE clause silently kill index usage?

advancedPro

Tests whether you know an implicit conversion on the indexed column forces a full scan even though an index exists.

Q

When is denormalization actually better than normalization for performance?

advancedPro

Tests whether you know read-heavy systems can trade some redundancy for avoiding expensive joins at query time.

Q

How do soft deletes (an is_deleted flag) hurt performance over time, and how do you mitigate it?

advancedPro

Tests whether you know a growing pile of never-really-deleted rows bloats indexes and slows every query that scans the table.

Q

How do you archive historical data to keep the working table small and fast?

advancedPro

Tests whether you know moving cold data to a separate archive table keeps hot-path queries fast on the active table.

Q

How do read replicas reduce load on the primary database, and what consistency tradeoff do they introduce?

intermediatePro

Tests whether you know replicas offload read traffic at the cost of potential replication lag on reads.

AWS Comparisons

Kubernetes & Container Orchestration