Dimension Table Definition | Dataford Interview Questions

What is a dimension table?

For the practical portion, use the provided Waymo vehicle dimension table. Write a SQL query that returns the descriptive attributes for currently active vehicle records.

Output

One row per active vehicle dimension record
Columns: vehicle_id, vehicle_model, vehicle_type, and operating_region
Exclude inactive records and sort by vehicle_id ascending

Schema

waymo_vehicle_dimension

Column	Type	Description
vehicle_idPK	INT	Unique identifier for the vehicle dimension record
vehicle_model	VARCHAR(50)	Vehicle model name
vehicle_type	VARCHAR(40)	Vehicle classification
operating_region	VARCHAR(60)	Region where the vehicle operates
is_active	BOOLEAN	Whether the dimension record is currently active

Your question is Dimension 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