Pick a focused question that fits your time, stack, and interview goal.
How much time do you have?
Show one-drill sessions you can finish now.
1225 drills fit a 20-minute session. Closest fits first.
Page 28 of 52
Diagnoses in-place mutation, equality rules, missing reactive reads, and incorrect use of untracked state.
Diagnoses lost struct mutations and explains how readonly access can trigger defensive copies.
Places validation, authorization, limits, state transitions, and approval outside the model while acknowledging that guardrails reduce rather than eliminate risk.
Uses reduction, thread-local state, atomic scalar updates, or indexed output instead of mutating a shared collection from parallel workers.
Explains trusted tenant context, membership checks, tenant-scoped queries, cache keys, and background job propagation.
Explains admin list/edit/delete workflows with capability checks, audit events, confirmation, validation, and recovery.
Explains caching and revalidation choices for static, dynamic, user-specific, and frequently changing data.
Chooses constraints, conditional writes, optimistic conflicts, or stronger isolation to protect a limited-resource reservation without unnecessary blocking.
Explains composite index column order with practical .NET data-access examples and production trade-offs.
Explains EF Core connection resiliency and retries with practical .NET data-access examples and production trade-offs.
Explains sampling, high-cardinality labels, retention, cost, and keeping enough signal for incident diagnosis.
Explains a practical debugging path across browser, Next.js layer, API, logs, database, and deployment changes.
Explains why server HTML and client render can disagree, how to debug it, and how to avoid mismatch-prone code.
Builds a race-safe upsert around database-enforced identity, explicit conflict semantics, retries, ordering, and side-effect boundaries.
Explains why message handlers must tolerate duplicate delivery and how idempotency protects side effects.
Protects transactional traffic from reporting load through freshness requirements, bounded asynchronous jobs, tuned summaries, workload isolation, replicas or warehouses, and explicit capacity gates.
Explains hot-key behavior, traffic concentration, partition pressure, payload size, and mitigation options.
Separates a live blocking chain from a deadlock victim, gathers the right database evidence, stabilizes the incident, and fixes lock duration or access order.
Explains split queries versus single joined queries with practical .NET data-access examples and production trade-offs.
Implements representation-aware ETags and conditional GETs correctly, including validators, 304 metadata, authorization, cache variation, generation cost, and tests.
Explains how consumer groups share event-stream work and how offset commits affect duplicate or lost processing.
Explains parameter sniffing, data skew, cached plans, symptoms, and cautious mitigation options in SQL Server.
Explains how statistics and cardinality estimates affect plan choice, joins, memory grants, and slow queries.
Explains why exactly-once claims do not remove the need for idempotent side effects and consistency boundaries.