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.
140 results across 1 active filter
Page 5 of 6
Investigates a growing-data EF Core slowdown through one correlated request, generated SQL, representative parameters, execution plan, waits, query shape, measured repair, and guarded rollout.
Explains when LINQ is enough, when raw SQL is clearer, and how to keep raw SQL safe and maintainable.
Uses `AsSplitQuery` deliberately for a tracked aggregate with multiple collections and explains its consistency boundary.
Relies on a database unique constraint and translates only the expected provider error into a domain conflict.
Chooses between a modular monolith and microservices using domain boundaries, team ownership, scaling, deployment, data consistency, and operational cost.
Implements descending keyset pagination with a compound cursor and stable ordering.
Explains expand-and-contract migrations, backwards-compatible schema changes, backfills, rollout order, and rollback thinking.
Explains frontend guards, backend idempotency, pending state, retries, and duplicate-safe mutation design.
Updates only public mutable fields and leaves ownership, status, and audit values server-controlled.
Explains EF Core projections for API read models that need related names, counts, and summaries without loading full graphs.
Builds a read-only EF Core projection with aggregates, stable ordering, and bounded results instead of loading an entity graph.
Carries the ASP.NET Core request token into a bounded EF Core query while keeping cancellation separate from business rollback guarantees.
Maps a named capability to an ASP.NET Core policy and enforces it at the endpoint boundary.
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 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.