SQL, Modeling, and Streaming Design | Dataford Interview Questions

Tell me about your approach to SQL data modeling and designing a streaming data system, including how you would implement it. For the hands-on portion, use the supplied relational tables to identify each actor's latest processed event while preserving actors with no qualifying event.

Output

One row per actor, including actors without a qualifying event
Columns: actor_id, actor_name, event_type, event_ts, sequence_id
Order by actor_id ascending, with NULL event fields for actors without a qualifying event

Schema

actors

Column	Type	Description
actor_idPK	INT	Stable identifier for an actor
actor_name	VARCHAR(100)	Display name of the actor

stream_events

Column	Type	Description
sequence_idPK	BIGINT	Unique monotonically increasing event sequence
actor_id	INT	Actor associated with the event
event_type	VARCHAR(50)	Logical type of the event
event_ts	TIMESTAMP	Event occurrence timestamp
status	VARCHAR(20)	Processing status of the event

Your question is SQL, Modeling, and Streaming Design. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem