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.
157 results across 1 active filter
Page 6 of 7
Converts local-day boundaries to UTC once, preserving correct daylight-saving behavior and index use on stored UTC timestamps.
Uses an actual execution plan, row-flow evidence, runtime measurements, and representative parameters to diagnose a slow query without guessing.
Repairs a workflow when a remote operation may have succeeded but local state, messages, and callbacks disagree.
Replaces a parent query plus one status query per row with one server-side projection.
Ranks duplicate import rows, previews the deletion set, and removes older copies with deterministic retention.
Uses a database transaction and row lock to keep stock non-negative when reservations race.
Uses a conditional update and transaction to prevent overselling while recording the reservation consistently.
Wraps a complete explicit transaction in the provider execution strategy and creates fresh context state for each retry attempt.
Persists a job and outbox command before returning a status URL for long-running work.
Produces field-keyed validation errors through one reusable endpoint boundary.
Writes a left-join aggregate that keeps active customers with no paid orders and applies date filters without changing join semantics.
Uses ROW_NUMBER with a deterministic tie-breaker to return the complete latest status row per order.
Aggregates product sales and ranks independently inside each category with a deterministic top-N rule.
Reviews and stages destructive EF Core schema changes around live data, locks, mixed application versions, recovery, and rollback.
Persists business state and durable publication intent atomically, leaving broker delivery to an idempotent retrying publisher.
Persists business state and durable publication intent atomically while leaving broker delivery to an idempotent publisher.
Persists domain state and its outbox message in one SaveChanges transaction without publishing inside the request transaction.
Wraps a pooled DbContext factory so every request assigns tenant state before a global query filter can run.
Shapes an API list from its contract and cardinality, projecting only required values while preserving authorization, stable pagination, bounded nesting, index support, and measurable query cost.
Authorizes metadata before opening storage and streams the file with safe headers and range support.
Adds a stable query tag and inspects generated SQL without embedding user data or enabling unsafe global logging.
Attaches a key-only stub and marks one property modified for a narrow update while naming the rules this pattern bypasses.
Explains saturation signals and how systems shed, queue, throttle, or degrade before cascading failure.
Uses EF Core context pooling only when reusable context state, tenant isolation, and underlying connection state are controlled and tested.