Top 41

Prep plan

Updated weekly · Last refresh Aug 30

CNN Software Engineer Interview Questions

The questions to prepare for a CNN Software Engineer interview. Questions from real interview reports rank first. Updated weekly.

41questions

~6htotal time

Track your progressSign up free to work through all 41 questions and resume where you left off.

Start practicing free →

1

CodingStart here. 14 questions · ~119 min

Longest Substring Without RepeatsMedium

Find the longest substring with all unique characters using a sliding window.

Hash TablesStringsTwo Pointers

Implement Binary SearchEasy

Tests algorithm implementation skills and correctness reasoning.

RecursionArraysSearching

CNN

More Coding questions with a free account

2

SQL & Data Manipulation3 questions + 3 drills · ~56 min

SQL vs NoSQL DifferencesMedium

Tests understanding of data modeling tradeoffs and when to use SQL versus NoSQL systems.

JoinsData Wrangling

7-Day Rolling Average ExportsMedium

Calculate a 7-day rolling average of Adobe Acrobat document exports using a window function.

Data AnalysisAggregations

AbbottOOura Ring

Monthly Sales Trends by CategoryMedium

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData Wrangling

Total Wine & More

Resolve Conflicting Customer AttributesMedium

Use joins, CTEs, and row ranking to resolve conflicting customer profile values across ACME House systems.

JoinsData WranglingQuality

Ramsey Solutions

More SQL & Data Manipulation 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

3

Security & Infrastructure3 questions · ~26 min

High Availability and Fault ToleranceHard

Tests infrastructure and reliability thinking for always-on, high-traffic web services.

InfrastructureQuality

CNN

More Security & Infrastructure questions with a free account

4

Behavioral & Leadership16 questions · ~136 min

More Behavioral & Leadership questions with a free account

5

More topics5 questions · ~43 min

Design a News APIMedium

Tests API design skills including endpoints, data modeling, and scalability considerations.

Feature StoreModel Serving

CNN

Improve Web App Load TimeMedium

Tests performance troubleshooting and optimization strategy for production web experiences.

Trade-offsRisk Assessment

CNN

Microservices Architecture ChoicesHard

Tests ability to reason about service boundaries, communication, operations, and reliability.

InfrastructureOrchestration

CNN

State Management in ReactMedium

Tests frontend architecture choices for predictable UI behavior and maintainability.

reactstate management

CNN

More questions with a free account

The finish line: interview-readyComplete all 41 questions plus 3 hands-on drills to finish this plan.