Dataford
Interview QuestionsInterview GuidesExperiencesCoaching
New
Pricing
Get started
Dataford
Popular roles
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Browse
Browse All RolesEvery role hub, from analyst to MLBrowse All CompaniesCompany-specific interview loopsAll Interview GuidesThe full guide library
Top questions by role
Software EngineerData AnalystData ScientistData EngineerBusiness AnalystAI EngineerMachine Learning EngineerProduct Manager
Top questions by skill
SQLPythonStatisticsMachine LearningA/B TestingSystem DesignGenerative AIProduct SenseMetricsBehavioral
Browse all questions →Try a mock interview
Experiences
Practice
Mock InterviewsTimed interview simulations with feedbackCoaching1:1 coaching with people at your target companiesSuccess PathYour 6-week structured planModulesCurated lessons by topicWebinarsTalks from ex-Big Tech data leadsPlaygroundA free-form scratch editor
Learn
BlogInterview strategy and career adviceTech Job Market ReportHiring trends across data and AI rolesFor UniversitiesDataford for career centersAbout DatafordWho we are and how we build
Pricing
Build my plan
Cloud Database Reliability and Uptime
00:00
5 left

Cloud Database Reliability and Uptime

MediumSQL · PostgreSQL

Problem

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

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

Schema

cloud_databases
ColumnTypeDescription
database_idPKINTUnique database identifier
database_nameVARCHAR(100)Cloud database service name
providerVARCHAR(20)Cloud provider
regionVARCHAR(40)Cloud deployment region
reliability_incidents
ColumnTypeDescription
incident_idPKINTUnique incident identifier
database_idINTAffected database identifier
started_atTIMESTAMPIncident start timestamp
downtime_minutesINTMeasured service downtime in minutes
statusVARCHAR(20)Incident lifecycle status
Tablescloud_databasesreliability_incidents
Interviewer

Your question is Cloud Database Reliability and Uptime. 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.

You need to log in / sign up to run or submit.
CodePostgreSQL
Sign up free to run your codeLog inLn 1
Run your query to see results here.