Bank / cards
Capital One interview themes
What people report studying for — not a take-home dump. Last editorial update 2026-08-10.
Rounds you should expect
SQL + warehouse
MERGE with a late CDC event. Masking vs row access. Resource monitors.
Controls
Who can UNDROP prod. Why ACCOUNTADMIN is not a dashboard role.
Recently added questions
2026-08-10 · Fan-out revenue
Revenue doubled after a “harmless” dimension join. How do you prove it in five minutes?
Row counts before and after the join, then GROUP BY the join key HAVING count(*) > 1 on the dimension. Fix the grain or aggregate the dim. Never DISTINCT the fact.
From the question bank
medium · SQL · SQL
A join exploded revenue. How do you find the grain mismatch in five minutes?
Practice →easy · SQL · SQL
EXISTS vs IN for an anti-join. Which do you write first?
Practice →hard · SQL · SQL
PERCENTILE_CONT vs PERCENTILE_DISC. When does a hiring manager care?
Practice →medium · Warehouse · Snowflake
A Medium warehouse is slower but cheaper than Large. When is that true?
Practice →medium · Warehouse · Snowflake
Search Optimization vs a clustering key — one sentence each.
Practice →medium · Warehouse · Snowflake
SnowPro Specialty: Gen AI — where does COMPLETE belong?
Practice →medium · Warehouse · Snowflake
Auto-suspend 60s and a dashboard that ticks every 90s. What happens to the bill?
Practice →hard · Warehouse · Snowflake
ACCOUNTADMIN ran a Cortex call on a PII column. What was missing besides “don’t”?
Practice →hard · Data modeling · dbt
A unique test failed on fct_orders. What is your first query?
Practice →hard · Data modeling · dbt
Two marts both named fct_revenue. How did that happen, and how do you kill one?
Practice →medium · Orchestration · Airflow
Pools, priority_weight, and a Monday-morning stampede. Design the guardrail.
Practice →easy · Orchestration · Airflow
catchup=False forever. What history did you silently skip?
Practice →