Search the practice set
275 questions, 991 terms and 600 topics in 30 areas.
60 results for “Real-Time Analytical Stores”
Sub-Second Aggregation Store
A database built to ingest continuously and answer aggregate queries over recent data in milliseconds, occupying the gap between OLTP and the warehouse.
Clock Drift
Device clocks diverging from real time, which corrupts ordering, expires certificates early or late, and produces data that appears to arrive from the past.
Serving Latency Budget
The end-to-end time from an event occurring to its effect being queryable, allocated across ingest, processing and serving.
Unbounded Dataset
Input with no known end, which removes the option of waiting for completeness and forces every aggregate to be provisional.
Analytical Estate Topology
The full picture of where analytical data lands, is transformed and is served, including the paths that bypass the intended one.
Bake Time
The deliberate wait between rollout steps, sized by how long the fault you are watching for takes to appear.
Dwell Time
The period between an attacker gaining access and being detected — the metric that determines how much damage an intrusion can do.
Event Time Versus Processing Time
The distinction between when something happened and when the system saw it, which determines whether results are reproducible.
Lead Time to Value
The elapsed time from identifying an opportunity to delivering measurable benefit, which is usually dominated by waiting rather than by building.
Operational vs Analytical Store
The separation between the store serving the application's transactions and the one serving reporting and analysis, and the mechanism connecting them.
Point-in-Time Recovery
Restoring a database to any moment within a retention window by replaying transaction logs onto a base backup, rather than only to a snapshot boundary.
Queue Time Attribution
Splitting elapsed lead time into work and waiting, and naming which queue each wait sat in.
Recovery Time Objective
The maximum acceptable duration between a failure and restored service, agreed with the business rather than chosen by engineering.
Round-Trip Time
The time for a packet to travel to a destination and back — a physical floor that no application optimisation can reduce.
Time Travel
Querying a table as it existed at a previous version or timestamp, made possible by keeping the metadata and files of prior commits.
Time to Interactive Gap
The interval between a page appearing complete and actually responding to input, during which the user's taps do nothing.
Time to Market
How long it takes to get a capability in front of customers — often the constraint that dominates every other architectural quality.
Time-Boxed Waiver
An approved deviation from a standard that carries an owner, a justification, a compensating control and an expiry date after which it is reconsidered.
Adoption Curve
The proportion of teams actually using a platform capability over time, which is the only honest measure of whether the platform is working.
Alert Fatigue
The desensitisation that follows from alerts that are frequent, non-actionable, or not tied to user impact — after which real alerts are missed too.
A business sponsor asks for a real-time data platform because "the competition has one". Reporting is currently a nightly batch that lands at 06:00 and nobody has complained. How do you handle this?
Do not answer the technology question "Real time platform" is a solution, and it has arrived without a problem attached. Answering it directly leads either to a
A core mainframe system with no API supports nightly batch file exchange only. The business needs near-real-time order status. Design the integration.
Establish the real constraint "No API" usually means no API the mainframe team will build on your timeline . Find out what exists: message queue interfaces, dat
Quarterly access reviews take two weeks of manager time and everyone approves everything. How do you make this a real control?
Recognise what it currently is A review where everything is approved is not producing a decision; it is producing a record of a decision shaped activity. Two we
An e-commerce platform stores card numbers to support repeat purchases. How do you reduce PCI scope?
Stop the card number reaching your systems at all The strongest reduction is not storing cards more safely; it is never receiving them. A hosted field or an ifr
An end-to-end suite of 340 tests takes four hours and fails spuriously about half the time. The team wants to parallelise it. Is that the right move?
Parallelising treats the symptom It might halve the runtime. It will not touch the flakiness — in fact parallelisation often worsens it, by exposing shared stat
An executive asks why the new system "feels slower" when your dashboards show average response time improved. How do you explain it?
The average is the problem, and that is the explanation Averages hide the tail. A system where most requests got faster and the slowest ten percent got much slo
Delivery leadership says releases are too slow and wants the engineering team to "move faster". Lead time from commit to production is 21 days. How do you investigate, and what do you expect to find?
Do not accept the framing "Move faster" assumes the constraint is how fast code is written. That is almost never where the twenty one days went, and starting an
Design a URL shortener handling 100 million new links per month and 10 billion redirects. Where is the real difficulty?
What the interviewer is testing The classic warm up. What is being assessed is not whether you can shorten a URL — it is whether you do capacity arithmetic befo
Discord stores trillions of messages. What is their partition key, and what problem does the second half of it solve?
The key (channel id, bucket) — where bucket is a fixed time window. What each half does channel id matches the read pattern. Clients read messages within a chan
Netflix personalises an entire home page in the time a TV takes to draw a screen. How, given that scoring every title for every member on request is impossible?
What the interviewer is testing Whether you reach for the offline/online split — the single most reusable idea in latency critical personalisation — rather than
Partner integrations take four months from contract signature to production traffic. Engineering says the work is three days. Where does the time go and how do you cut it?
Map the elapsed time honestly The engineering estimate is correct and irrelevant. The four months are: Legal and contractual review. Security questionnaires and
Precompute every user's timeline at write time, or assemble it at read time? Explain why the answer for a social feed is neither.
Why each pure strategy fails Fan out on read. Store each post once; on timeline load, query the posts of everyone the user follows and merge. Writes are trivial
Your cluster fails over spuriously under load, but a real leader failure takes 45 seconds to detect. How do you resolve the tension?
The tension Detection time is set by the heartbeat interval times the failure threshold. Shorten it and you detect real failures faster and mistake slow but ali
A startup asks you to architect their product "to handle millions of users". They currently have none. What do you actually build?
What the interviewer is testing Whether you can identify the real constraint. The stated requirement is scale; the actual constraint is survival, and an archite
A streaming aggregation reports lower totals than the batch job it replaced. Both read the same source. What is likely happening?
The likely cause: late events dropped past the watermark The batch job reads a completed day and sees everything, including records that arrived hours after the
A team wants to move a workload from PostgreSQL to a document store because "the schema keeps changing". What do you ask?
The questions 1. What is actually changing — the shape, or the schema management process? "The schema keeps changing" usually means migrations are painful, not
Real-Time Analytical Stores
Druid, Pinot and ClickHouse — ingest-and-query engines for sub-second aggregation.
Real-Time Serving Layer
Where a low-latency read of a streaming aggregate actually lands.
Streaming & Real-Time Data
General material on continuous processing of unbounded data.
Backfill & Reprocessing
Replaying history through changed logic without double-counting the live output.
CDC to Stream
Turning database changes into an event log, and how that differs from a domain event.
Dead Letter Handling
The poison message that blocks a partition, and the queue nobody reads.
Exactly-Once Semantics
What the phrase really means, where it holds, and the idempotent sink underneath it.
Feature Freshness
How stale a feature can be before the model degrades, and the pipeline that follows.
Kappa vs Lambda
One pipeline replayed versus two pipelines reconciled, and the maintenance each carries.
Partition Keys & Ordering
Ordering guaranteed only within a partition, and choosing the key that makes that enough.
Stateful Stream Processing
Keyed state, state backends, checkpoint size, and the restore time that follows.
Stream Processing Frameworks
Flink, Kafka Streams, Spark Structured Streaming — state, checkpointing and recovery.
Stream-Table Duality
A changelog and a table as two views of the same thing, and materialising between them.
Streaming Cost
Always-on compute, retention and cross-zone traffic as the three bills that surprise.
Streaming Joins
Joining two unbounded streams, the buffering it needs, and the enrichment alternative.
Streaming SLOs
End-to-end latency, consumer lag and completeness as commitments rather than dashboards.
Streaming Schema Evolution
Changing an event's shape while a retained log still holds every older version of it.
Streaming vs Batch
The freshness requirement that actually justifies streaming, and the cost of assuming one.
Watermarks & Late Data
Deciding a window is complete when events can still arrive, and what to do when they do.
Windowing
Tumbling, sliding and session windows, and the aggregation each one answers.
NoSQL Stores
Key-value, document, wide-column and graph — what each buys and forbids.
Real User Monitoring
Field data from real devices and networks, against the synthetic run that looked fine.
Time to Market
The constraint that dominates most products, and how to trade against it.