Company: Flipkart Grid SDEintern_19july

Difficulty: hard

Problem Statement

A cloud provider wants to identify cloud regions that are becoming unreliable. The company records region details, region-type capacity limits, resource usage logs, customer deployment records and incident reports. Your task is to analyse the available data and print all regions whose reliability risk level is HIGH or MEDIUM . Data Structures Regions Table — regionId (unique identifier), regionName , regionType (such as EDGE, CORE, AI or DR). Region Type Profiles Table — regionType , maxCpuUsage (maximum acceptable CPU usage), maxMemoryUsage (maximum acceptable memory usage). Every regionType present in the Regions table has exactly one matching record here. Resource Usage Logs Table — usageId , regionId , usageDay , cpuUsage , memoryUsage . Customer Deployments Table — deploymentId , regionId , deploymentDay , deploymentStatus (ACTIVE or INACTIVE). Incident Reports Table — incidentId , regionId , incidentDay , severity (LOW, MEDIUM or HIGH). Valid Record

More Flipkart Grid SDEintern_19july OA questionsInterview experiences