Dropbox SWE Intern (Summer 2026) Interview Experience | CodeSignal OA | Status: PENDING
- Location
- Canada
- Posted
- 16 Feb 2026
Summary
I just finished the Online Assessment for the Dropbox Summer 2026 internship. I received 4 questions total: one hard algorithmic problem (Candy), two SQL database questions, and one data manipulation task using Pandas. The time limit was tight, but overall doable.
How it went
Title: Dropbox | SWE Intern (Summer 2026) | Canada | OA Experience
Tags: Dropbox, Internship, Canada, Online Assessment, CodeSignal
Post Content:
I just finished the Online Assessment for the Dropbox Summer 2026 internship. I didn't see much info on the current pool of questions so I thought I'd drop a quick summary of what I got.
The test was on CodeSignal. It was 4 questions total with a 70 minute time limit.
1. Algorithm (Standard LeetCode)
The coding question was literally Candy (LeetCode 135)(Hard).
- You have
nchildren standing in a line and each has a rating. - You need to distribute candies so that every child gets at least one, and children with a higher rating than their neighbors get more candies.
- Goal is to find the minimum candies needed.
I solved this using the standard two-pass greedy approach (left-to-right then right-to-left). If you've done the problem before, it's pretty straightforward.
2. Database (2 SQL Questions)
These were decent but you have to be careful with the date filtering.
- Question 1: Find new user signups by country.
I was given adb_usertable and had to write a query to count how many new users came from each country for each month in Q1 2021. Just a standardGROUP BYand date range filter. - Question 2: Calculate Retention Rate.
This asked for the percentage of users who joined in Jan 2021 (fromdb_user) that were also active in Feb 2021 (based ondb_engagement). I used aLEFT JOINto map the users and calculated the ratio.
3. DevOps / Data Manipulation (Pandas)
The last question wasn't a standard coding problem but a data analysis task using Python's Pandas library.
- Goal: Read a CSV file of customer data and find the country with the largest number of contracts.
- The Catch: You had to handle tie-breaking carefully. If two countries had the same count, the one that came later alphabetically (e.g., Z before A) had to be chosen.
- Approach: I used
groupbyto sum the contracts, thensort_valueswith a specific order to handle the tie-breaker, and printed the result in the exact requested format.
Overall Thoughts
The time limit is a bit tight if you get stuck on the SQL syntax or maybe DevOps part, but otherwise, it's very doable. Make sure you brush up on your JOINs and basic greedy algorithms. It was kind of okay-ish, didn't expect a hard question in intern position's online assessment tbh.
Good luck to everyone applying!
Questions asked (4)
- 01
Candy Distribution
Data Structures & Algorithms · Hard
You have
nchildren standing in a line and each has a rating. You need to distribute candies so that every child gets at least one, and children with a higher rating than their neighbors get more candies. Goal is to find the minimum candies needed. - 02
Find New User Signups by Country (SQL)
Other
Given a
db_usertable, write a query to count how many new users came from each country for each month in Q1 2021. - 03
Calculate User Retention Rate (SQL)
Other
Calculate the percentage of users who joined in Jan 2021 (from
db_user) that were also active in Feb 2021 (based ondb_engagement). - 04
Find Country with Largest Number of Contracts (Pandas)
Other
Read a CSV file of customer data and find the country with the largest number of contracts. Handle tie-breaking: if two countries had the same count, the one that came later alphabetically had to be chosen.
How they prepared
Make sure you brush up on your JOINs and basic greedy algorithms.