How do I approach System Design interview questions?

System Design questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master system design interviews.

What difficulty level is this interview question?

This is a medium difficulty System Design question, commonly asked during Onsite rounds at Atlassian.

What role is this question designed for?

This question is commonly asked for Software Engineer candidates at Atlassian during technical interviews.

Compute top-N posts in a workspace | Atlassian Interview Question

Compute top-N posts in a workspace

Last updated: Mar 29, 2026

Quick Overview

This question evaluates skills in designing scalable, low-latency analytics and aggregation systems, covering event tracking, time-windowed ranking, stream processing, storage trade-offs (OLTP vs OLAP), caching, API design, and handling late or duplicate events.

Atlassian

Jan 5, 2026, 12:00 AM

Software Engineer

Onsite

System Design

Design a feature that returns the top-N posts (e.g., Confluence pages/blog posts) in a workspace.

Requirements:

Define what “top” means (e.g., views, likes, comments, or a weighted score).
Support queries like: top N posts for the last 24 hours / 7 days / 30 days.
Low latency for reads.
Handle high write volume of events (views/likes).

Deliverables:

Event tracking and aggregation design.
Storage choices (OLTP vs OLAP) and schema.
API design and caching.
Handling late/duplicate events and backfills.

Solution

Show

Comments (0)

Loading comments...

Browse More Questions

More System Design•More Atlassian•More Software Engineer•Atlassian Software Engineer•Atlassian System Design•Software Engineer System Design