Fact Table Definition | Dataford Interview Questions

What is a fact table?

Explain what a fact table represents, including its grain, measures, and typical relationships to dimensions. Use the provided table to demonstrate the concept with a concise SQL result.

Output

One row per event_date
Columns: event_date, total_distance_km, and total_intervention_count
Include every date in the table, including dates whose distance value is NULL
Sort by event_date ascending

Schema

fact_vehicle_events

Column	Type	Description
fact_event_idPK	INT	Unique identifier for the recorded fact row
event_date	DATE	Date associated with the recorded event
vehicle_id	VARCHAR(20)	Identifier for the vehicle associated with the event
distance_km	DECIMAL(10,2)	Measured distance for the event in kilometers
intervention_count	INT	Number of recorded interventions for the event

Your question is Fact Table Definition. Start with the requirements and the one table 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