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.
94 results across 1 active filter
Page 1 of 4
Explains how tenant query filters help, where they can be bypassed, and what extra safeguards protect tenant isolation.
Explains audit fields and data change tracking with practical .NET data-access examples and production trade-offs.
Loads a resource once, evaluates owner-or-capability authorization, and avoids trusting route ownership claims.
Explains dynamic filters and SQL injection risk with practical .NET data-access examples and production trade-offs.
Implements bounded filtering and deterministic keyset pagination without accepting arbitrary query expressions.
Creates a resource through an explicit request DTO and returns typed 201, 409, and validation outcomes.
Explains composing dynamic LINQ filters while keeping query execution in SQL and index-friendly.
Explains dependency duration, error rate, timeout rate, query tagging, Redis latency, HTTP downstream calls, and endpoint correlation.
Chooses database test infrastructure by the provider behavior a test must prove.
Builds optional EF Core predicates while preserving server translation, stable ordering, and a bounded result.
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 database constraints versus application validation with practical .NET data-access examples and production trade-offs.
Uses deadlock evidence to correct EF Core transaction scope, query plans, and resource order, with bounded retries only for repeat-safe victims.
Explains database connection pool exhaustion with practical .NET data-access examples and production trade-offs.
Explains high database CPU after an API change with practical .NET data-access examples and production trade-offs.
Explains how to decide if caching is the right fix for a slow API endpoint instead of query tuning or contract changes.
Explains batching, tracking control, idempotency, validation, and operational safety for large EF Core imports.
Explains how EF Core SaveChanges, transactions, and an outbox keep database changes and messages consistent.
Explains soft delete in EF Core APIs with practical .NET data-access examples and production trade-offs.
Design list endpoints with pagination, filtering, sorting, limits, and database-aware performance behavior.
Uses unique namespaces and correctly scoped fixtures so parallel tests improve speed without creating collisions.
Diagnoses hidden per-row EF Core queries and replaces them with a bounded query shape without creating an oversized join.
Explains a telemetry-driven path from slow endpoint symptoms to database, cache, dependency, CPU, or payload root cause.