Dataford
Top 15
Prep plan
Updated weekly · Last refresh Sep 26

The Agency Software Engineer Interview Questions

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

15questions
~2htotal time
Track your progressSign up free to work through all 15 questions and resume where you left off.
Start practicing free →
1
System DesignStart here. 5 questions · ~41 min
Client vs Server RenderingMedium

Assesses your understanding of rendering models and their implications for performance and UX.

renderingThe Agency
Responsive Performance Across DevicesMedium

Assesses performance optimization techniques tailored to device capabilities and network conditions.

performance optimizationresponsive designThe Agency
More System Design questions with a free account
2
Execution5 questions · ~41 min
Balancing Graphics and SpeedMedium

Tests your ability to make performance-focused tradeoffs without sacrificing visual quality.

Trade-offsThe Agency
From Mock-Up to Pixel-Perfect ComponentMedium

Assesses your execution process for translating designs into accurate, working UI components.

workflowThe Agency
More Execution 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
More topics5 questions · ~41 min
Maintainable and Scalable Code as Project GrowsMedium

Tests your practices for architecture, refactoring, and sustainable development as complexity increases.

code qualitymaintainabilityscalabilityThe Agency
High-Availability Database DesignMedium

Assesses database design decisions for reliability, uptime, and performance at scale.

high availabilitydatabase designThe Agency
Web App Security VulnerabilitiesMedium

Evaluates your understanding of common web security risks and practical mitigation techniques.

security vulnerabilitiesmitigationThe Agency
AI Privacy for Client PlatformsHard

Evaluates privacy risk management and secure AI integration for a client-facing real estate platform.

data privacyThe Agency
More questions with a free account
Hands-on SQL practiceWrite and run real queries in the editor. 3 drills · ~30 min
Data Modeling in Oracle or SnowflakeMedium
Practice
Practice drill

Demonstrate data modeling and PostgreSQL performance practices by summarizing posted account activity for active accounts.

database optimizationperformance optimizationdatabase designJPMorganChase
Duplicate Detection QueryMedium
Practice
Practice drill

Identify duplicate trade records with aggregation and performance-aware filtering.

performance optimizationlarge datasetssql queryNomura
Database Trade-Offs for DetectionHard
Practice
Practice drill

Compare financial crime detection architectures using joined run metrics, aggregates, NULL handling, and ordered performance results.

fraud detectionTrade-offsdistributed databasesDeloitte
The finish line: interview-readyComplete all 15 questions plus 3 hands-on drills to finish this plan.