Shivalik Small Finance Bank Interview Questions and Answers

To scale the app database over India, consider sharding, replication, and using cloud services.

• Implement sharding to distribute data across multiple servers based on geographic location or other criteria.

• Set up replication to ensure data consistency and availability in different regions.

• Utilize cloud services like AWS or Azure to easily scale resources based on demand.

• Optimize queries and indexes to improve database performance.

• Consider using a content delivery network (CDN) ...read more

The 3 basic components of a database are data, schema, and software. An RCA for a DB being down involves identifying the root cause of the issue.

• Data: the actual information stored in the database, such as customer records or product details.

• Schema: the structure that defines how the data is organized and related to each other, including tables, fields, and relationships.

• Software: the database management system (DBMS) that allows users to interact with the data, such as MySQL...read more

A multi-level parking system schema design involves creating a database to manage parking spots and their availability.

• Create a database to store information about parking spots, levels, and availability

• Design a user interface for customers to view available spots and reserve them

• Implement a system to track the entry and exit of vehicles

• Incorporate sensors or cameras to monitor parking spot availability

• Consider integrating payment processing for parking fees

We have used a combination of containerization and orchestration tools like Docker and Kubernetes for our microservices architecture.

• We have followed the principles of domain-driven design to identify the boundaries of our microservices.

• We have used RESTful APIs for communication between microservices.

• We have implemented fault tolerance and resilience patterns like circuit breakers and retries.

• We have used event-driven architecture for asynchronous communication between micro...read more

Sharding and partitioning are both techniques used in database management to improve performance and scalability by dividing data into smaller chunks.

• Sharding involves splitting a database into smaller, independent databases called shards, each responsible for a subset of the data.

• Partitioning involves dividing a database into smaller segments called partitions, each containing a subset of the data based on a defined criteria such as range or hash value.

• Sharding is typically ...read more

Design schema for a movie booking system.

• Create tables for movies, theaters, users, bookings, and payments.

• Use foreign keys to establish relationships between tables.

• Include attributes like movie title, showtime, seat number, user details, booking status, payment details, etc.

• Consider implementing a booking algorithm to handle seat selection and availability.

• Ensure data integrity and normalization for efficient data retrieval and storage.