SarthiQ

SarthiQ

Interview Preparation Guide

System Design
Questions & Answers

A comprehensive, expert-curated list of real interview questions to help you prepare effectively and land your dream job.

Document Details

Topic / Subject
System Design
Content Length
35 Curated Q&A
Generated On
November 20, 2026
Provided By
SarthiQ.com
Want to explore more questions & mock interviews? Click on 👉www.sarthiq.com
© 2026 SarthiQ Platform. All rights reserved.
www.sarthiq.com
Resume Upload Get Job in 90 Days Resume Builder AI Interview Coach Interview Questions Placement Committee Self Assessment Get Internship

Need Help?

[email protected]

Top System Design Interview Questions

NETFLIX
ORACLE
Adobe
NVIDIA
meta
IBM
wipro
TCS
cisco
intel
SAP
Uber

System Design Interview Questions

Practice with real System Design interview questions

01
A Full Stack Developer was asked
SarthiQ System Design
Hard
Asked in 2026
Q. Describe how you would implement a serverless solution for processing video uploads and transcoding in a cloud environment.
Ans. Implementing a serverless solution for video uploads and transcoding can be efficiently done using cloud services like AWS Lambda, S3, and media transcoding services. Here is how you can approach it: 1. File Upload: Set up an S3 bucket to handle video uploads directly from the frontend. The frontend can use presigned URLs to upload files securely. 2. Trigger Lambda Function: Configure the S3 bucket to trigger an AWS Lambda function when a new video is uploaded. 3. Transcoding: Use AWS Elemental MediaConvert or FFmpeg inside the Lambda function to transcode the uploaded video into different formats. 4. Storage of Transcoded Videos: Store the transcoded videos back in S3 or in a different bucket based on the output format. 5. Notify Completion: Optionally, use SNS (Simple Notification Service) to notify other services or users when the transcoding is complete. Example Code for Lambda Function:
python
import boto3
import subprocess
import os

s3 = boto3.client('s3')

**def lambda_handler(event, context):**
    bucket = event['Records'][0]['s3']['bucket']['name']
    key = event['Records'][0]['s3']['object']['key']
    # Download video from S3
    download_path = f'/tmp/{key}'
    s3.download_file(bucket, key, download_path)

    # Transcoding process using FFmpeg
    output_path = f'/tmp/transcoded-{key}'
    command = f'ffmpeg -i {download_path} -vcodec h264 {output_path}'
    subprocess.run(command, shell=True)

    # Upload the transcoded video back to S3
    s3.upload_file(output_path, bucket, f'transcoded/{key}')
    return {
        'statusCode': 200,
        'body': 'Transcoding completed successfully!'
    }
This serverless architecture automatically scales with the number of uploads and minimizes management overhead, as you only pay for the resources consumed during processing.
Full Stack DeveloperCore Concept
02
A Software Engineer was asked
SarthiQ System Design
Medium
Asked in 2024
Q. Explain the concept of normalization in DBMS and describe the different normal forms with examples.
Ans. Normalization is a database design technique that organizes tables to reduce redundancy and dependency. The different normal forms are: 1. First Normal Form (1NF): A table is in 1NF if it contains only atomic values and each column has unique names. For example, a table of student records should not have multiple values in a single column.
sql
CREATE TABLE Students (
       StudentID INT PRIMARY KEY,
       Name VARCHAR(100),
       Courses VARCHAR(255)
   );
To convert to 1NF, we would split 'Courses' into a separate table:
sql
CREATE TABLE Courses (
       CourseID INT,
       StudentID INT,
       CourseName VARCHAR(100),
       PRIMARY KEY (CourseID, StudentID)
   );
2. Second Normal Form (2NF): A table is in 2NF if it is in 1NF and all non-key attributes are fully functional dependent on the primary key. For example:
sql
CREATE TABLE Orders (
       OrderID INT PRIMARY KEY,
       ProductID INT,
       Quantity INT,
       ProductName VARCHAR(100),
       FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
   );
To convert to 2NF, we can move 'ProductName' to a separate table:
sql
CREATE TABLE ProductDetails (
       ProductID INT PRIMARY KEY,
       ProductName VARCHAR(100)
   );
3. Third Normal Form (3NF): A table is in 3NF if it is in 2NF and all the attributes are functionally dependent only on the primary key. For example:
sql
CREATE TABLE Employees (
       EmployeeID INT PRIMARY KEY,
       Name VARCHAR(100),
       DepartmentID INT,
       DepartmentName VARCHAR(100)
   );
To convert to 3NF, we separate the department details:
sql
CREATE TABLE Departments (
       DepartmentID INT PRIMARY KEY,
       DepartmentName VARCHAR(100)
   );
Normalization helps maintain data integrity and efficiency.
Software EngineerCore Concept
03
Software Engineer
SarthiQ System Design
Hard

Question:

How would you design a scalable system for XYZ...

04
Software Engineer
SarthiQ System Design
Hard

Question:

How would you design a scalable system for XYZ...