Top 2
Prep plan
Updated weekly · Last refresh Oct 17C
Cactus Communications Data Analyst Interview Questions
The questions to prepare for a Cactus Communications Data Analyst interview. Questions from real interview reports rank first. Updated daily.
2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →1
Window FunctionsStart here. 1 question + 3 drills · ~38 min
RANK vs DENSE_RANK in LeaderboardsEasy
Explain how RANK() and DENSE_RANK() handle ties differently in ordered SQL results such as leaderboards.
Window FunctionsRankingData WranglingCCactus Communications
Top Credit Score Applicants by StateMedium
Practice
Practice drillIdentify the highest-credit-score 5% of applicants within each state using percentiles and window ranking.
Window FunctionsJoinsRanking
American Credit Acceptance
American Credit AcceptanceTop Daily Rides by VehicleMedium
Practice
Practice drillRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
Window FunctionsJoinsData Wrangling
Waymo
Cruise
WaymoCruiseDeduplicate Out-of-Order Replication EventsMedium
Practice
Practice drillUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Window FunctionsSubqueriesJoins
Replit
Quantcast
ReplitQuantcast2
Joins1 question · ~8 min
Difference Between WHERE and HAVING ClausesEasy
Explain the differences between WHERE and HAVING clauses in SQL and when to use each.
JoinsData WranglingAggregationsCCactus Communications
Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
The finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.