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.
104 results across 1 active filter
Page 1 of 5
Explains how tenant query filters help, where they can be bypassed, and what extra safeguards protect tenant isolation.
Explains physical connection reuse, pool partitioning, short ownership, exhaustion causes, diagnostics, and why increasing the pool is not the first fix.
Pre-aggregates two one-to-many relationships before joining them to prevent fanout from corrupting financial totals.
Explains URL-backed filters, API query parameters, pagination, sorting, empty states, and shareable list views.
Explains admin list/edit/delete workflows with capability checks, audit events, confirmation, validation, and recovery.
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.
Maps business invariants and stale-data tolerance to strong or eventual consistency, explicit failure behavior, reconciliation, and user-visible state.
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.
Distinguishes instants, local calendar values, offsets, and named time zones so APIs and persistence survive daylight-saving and locale boundaries.
Designs an async export flow for large reports without blocking API requests or exhausting database and memory resources.
Designs dashboard APIs with precomputed metrics, freshness rules, query cost control, and drill-down support.
Designs explicit workflow states, allowed transitions, guard rules, audit history, idempotency, and operational repair paths.
Designs feature flag storage, targeting, safe defaults, auditability, and rollout observability for backend behavior.
Explains batching, tracking control, idempotency, validation, and operational safety for large EF Core imports.
Designs tenant isolation across API, data, cache, background jobs, search, and admin access.
Designs an activity feed with event capture, fan-out strategy, pagination, privacy, and read performance.
Designs immutable audit records for sensitive administrative changes with useful before/after context and safe retention.
Designs a checkout or order creation flow that survives client retries without duplicate orders, payments, or messages.