Cloud Database Reliability and Uptime | Dataford Interview Questions

Explain your process for managing database reliability and uptime in a cloud-native environment (e.g., AWS or Azure). Use the provided database inventory and incident records to produce a January 2026 reliability report. Include databases with no incidents and exclude incidents outside the reporting period.

Output

One row per database, with database_name, provider, incident_count, downtime_minutes, and uptime_percentage
Calculate uptime using 44,640 minutes in January 2026, treating missing downtime as zero
Sort by uptime_percentage descending, then database_name ascending

Output details

Filter incidents whose started_at is on or after TIMESTAMP '2026-01-01 00:00:00' and before TIMESTAMP '2026-02-01 00:00:00'.
Round uptime_percentage to 2 decimal places.

Schema

cloud_databases

Column	Type	Description
database_idPK	INT	Unique database identifier
database_name	VARCHAR(100)	Cloud database service name
provider	VARCHAR(20)	Cloud provider
region	VARCHAR(40)	Cloud deployment region

reliability_incidents

Column	Type	Description
incident_idPK	INT	Unique incident identifier
database_id	INT	Affected database identifier
started_at	TIMESTAMP	Incident start timestamp
downtime_minutes	INT	Measured service downtime in minutes
status	VARCHAR(20)	Incident lifecycle status

Whenever you're ready, walk me through your approach or go straight to the code. The requirements and the two tables are in the Question tab.

Problem