Loading
Pick a focused question that fits your time, stack, and interview goal.
123 results across 1 active filter
Page 1 of 6
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.
Pre-aggregates two one-to-many relationships before joining them to prevent fanout from corrupting financial totals.
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.
Builds several daily business metrics in one grouped query while keeping each metric definition explicit.
Explains composing dynamic LINQ filters while keeping query execution in SQL and index-friendly.
Uses an ordered window aggregate to calculate a deterministic running balance per account.
Combines daily aggregation, a calendar table, and a window frame to calculate true seven-calendar-day revenue.
Explains dependency duration, error rate, timeout rate, query tagging, Redis latency, HTTP downstream calls, and endpoint correlation.
Chooses constraints, conditional writes, optimistic conflicts, or stronger isolation to protect a limited-resource reservation without unnecessary blocking.
Chooses database test infrastructure by the provider behavior a test must prove.
Designs a narrow covering index from predicates and ordering, then weighs eliminated lookups against storage, write overhead, cache efficiency, overlap, and maintenance cost.
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.
Builds a race-safe upsert around database-enforced identity, explicit conflict semantics, retries, ordering, and side-effect boundaries.