Managing Databases Experience | Dataford Interview Questions

Share your experience managing databases for data science work.

Demonstrate your approach by querying the supplied metadata for datasets and model runs. Return the latest completed run for every dataset, including datasets without a completed run.

Output

One row per dataset with dataset_name, run_id, model_name, started_at, and rmse.
Include missing run or metric values as NULL.
Sort alphabetically by dataset_name.

Schema

datasets

Column	Type	Description
dataset_idPK	INT	Unique dataset identifier
dataset_name	VARCHAR(100)	Dataset display name
domain	VARCHAR(50)	Business or analytical domain

model_runs

Column	Type	Description
run_idPK	INT	Unique model run identifier
dataset_id	INT	Dataset used by the run
model_name	VARCHAR(100)	Model or experiment name
status	VARCHAR(20)	Run lifecycle status
started_at	TIMESTAMP	Run start timestamp

run_metrics

Column	Type	Description
metric_idPK	INT	Unique metric record identifier
run_id	INT	Model run associated with the metric
metric_name	VARCHAR(30)	Metric name
metric_value	DECIMAL(10,4)	Measured metric value

Your question is Managing Databases Experience. Start with the requirements and the three 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