Dataford
Dataford
Top 9
Prep plan
Updated weekly · Last refresh Oct 17

Google DeepMind Data Analyst Interview Questions

The questions to prepare for a Google DeepMind Data Analyst interview. Questions from real interview reports rank first. Updated daily.

9questions
~1htotal time
Track your progressSign up free to work through all 9 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 3 drills · ~86 min
Understanding SQL JoinsMedium

Evaluates your understanding of SQL joins and their appropriate use cases for combining datasets.

JoinssqlGoogle DeepMind
Top 10% Advertisers by SpendMedium

Tests SQL ranking/percentile logic for advertiser segmentation.

sql queryData AnalysisGoogle DeepMind
Rolling Advertiser RetentionMedium

Tests SQL skills for cohorting and rolling-window retention calculations in ad data.

sql queryData AnalysisGoogle DeepMind
Find Missing AttributionMedium

Tests SQL join logic and data quality investigation for attribution gaps.

Joinssql querydata integrityGoogle DeepMind
CTE vs Temporary TableMedium

Tests understanding of SQL execution patterns and performance considerations.

Google DeepMind
Optimize a Timing-Out QueryHard

Tests query optimization strategies for large-scale data and performance troubleshooting.

large datasetsperformancequery optimizationGoogle DeepMind
Window Functions for Running TotalsMedium
Practice
Practice drill

Use PostgreSQL window functions to calculate user running spend and rank users by total spend within each signup cohort.

Window FunctionsRankingRunning TotalsNewMarketDeloitteAllstate
SQL Conversion Rate by CampaignEasy
Practice
Practice drill

Calculate daily campaign conversion rates with conditional aggregation, a CTE, and a campaign dimension join.

Date FunctionsGroup ByAggregationsNianticBrazeOutschool
Top Marketing Channels with Window FunctionsMedium
Practice
Practice drill

Rank monthly marketing channels by ROAS and compare each channel with its prior month using advanced window functions.

Window FunctionsData ManipulationRankingGoogle DeepMind
More SQL & Data Manipulation questions with a free account
2
More topics2 questions · ~16 min
Define Success for Ad FeatureMedium

Tests product sense and metric design for evaluating AI-driven ad targeting outcomes.

success metricsGoogle DeepMind
Dashboard for AI Ad Model HealthHard

Tests product sense for monitoring, diagnostics, and operational metrics for AI ad models.

performance trackingdashboard designGoogle DeepMind

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 9 questions plus 3 hands-on drills to finish this plan.