Top 28
Company roadmap
Updated weekly · Last refresh Aug 30
C

Clarksons Research Interview Questions

The questions to prepare for Clarksons Research interviews, across all roles. Questions from real interview reports rank first. Updated weekly.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 3 questions · ~26 min
Reverse a String in PythonEasy
Practice

Reverse a string in Python using character traversal and return the reversed result.

StringsfunctionspythonCClarksons Research
Asynchronous ProgrammingMedium

Assesses your ability to explain async concepts and justify their use in real software systems.

javascriptCClarksons Research
More Coding questions with a free account
2
Product Sense5 questions · ~43 min
Geopolitics and Trade RoutesMedium

Tests your ability to connect geopolitical developments to routing and trade impacts for Clarksons Research analysis.

CClarksons Research
Environmental Rules Client ExplanationMedium

Tests your communication skills and ability to translate regulatory changes into actionable insights for Clarksons Research clients.

client communicationCClarksons Research
Macroeconomics in Energy ShippingMedium

Tests your ability to link macroeconomic drivers to energy shipping market dynamics for Clarksons Research clients.

market analysisCClarksons Research
More Product Sense 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
SQL & Data Manipulation3 questions + 3 drills · ~56 min
SQL Server Join TypesMedium

Tests understanding of SQL join semantics and correct selection for data retrieval.

sqldatabase conceptsjoin typesCClarksons Research
Optimizing Complex SQLMedium

Tests query optimization techniques and performance reasoning for SQL Server workloads.

Performance Tuningquery optimizationsqlCClarksons Research
Clustered vs Non-Clustered IndexMedium

Assesses your SQL indexing knowledge and performance implications for data-heavy applications.

indexingdatabaseCClarksons Research
Top Users by Recent Transaction VolumeMedium
Practice
Practice drill

Find the top 3 users by completed transaction volume in the last 30 days using joins and aggregation.

Data Analysisquery optimizationsqlTTier 1 BankRevolutChime
Top Clinics by Patient VolumeMedium
Practice
Practice drill

Rank Oracle Health EHR clinics by distinct completed patients using aggregation and ROW_NUMBER().

Window Functionsquery optimizationsqlOOracle Health
SQL Query for Expected ResultsMedium
Practice
Practice drill

Use LEFT JOINs, a CTE, and aggregation to summarize 2025 claims and completed payments for active Guidewire PolicyCenter policies.

databasesqlGGuidewire Software
4
Behavioral & Leadership17 questions · ~148 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 28 questions plus 3 hands-on drills to finish this plan.