Top 13
Topic roadmap
Updated weekly · Last refresh Nov 4

abuse tracking Interview Questions

The most frequently asked abuse tracking questions across all roles and companies, ranked by real interview frequency. Updated daily.

13questions
~4htotal time
11companies covered
Track your progressSign up free to work through all 13 questions and resume where you left off.
Start practicing free →
1
Window FunctionsStart here. 6 questions · ~114 min
SQL: Failed Transactions in WindowMedium
Practice

Use a time-based window to identify users with more than three failed attempts within five minutes.

Window Functionsabuse trackingfraud detectionByteDanceChime
Detect Multiple Card Linking AttemptsMedium
Practice
Recently asked

Identify Coinbase users linking more than three distinct cards within a rolling 24-hour period.

Window Functionsabuse trackingDate FunctionsCoinbase
Top Failed Payments in Rolling WindowHard
Practice

Identify Affirm accounts with the most failed payment attempts in any rolling 10-minute interval.

Window Functionsabuse trackingRankingAffirm
More Window Functions questions with a free account

Sign up to see every question

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

Get my prep plan
2
abuse tracking6 questions · ~114 min
SQL for Suspicious Account PatternsMedium
Practice
Recently asked

Identify TikTok devices associated with at least three account creations within any 24-hour window.

abuse trackingDate FunctionsData AnalysisTikTok
Join Tables for Device Linked AccountsMedium
Practice
Recently asked

Use joins and aggregation to flag TikTok users whose multiple accounts share the same device ID.

abuse trackingJoinssql queriesTikTok
SQL for Multiple Risk FlagsMedium
Practice
Recently asked

Find ByteDance users with at least two risk flags triggered within a 24-hour period.

abuse trackingDate FunctionsJoinsByteDance
Detect Consecutive Losing StreaksMedium
Practice
Recently asked

Identify bet365 users with consecutive losing bets above a risk threshold using ordered streak grouping.

abuse trackingData Manipulationsql querybet365
More abuse tracking questions with a free account
3
More topics1 question · ~19 min
Detect Duplicate AccountsMedium
Practice

Use a self-join to find Robinhood account pairs sharing an IP address and exact sign-up timestamp.

deduplicationabuse trackingfraud detectionRobinhood
The finish line: interview-readyComplete all 13 questions to finish this plan.