TabSquare.ai Interview Questions and Answers

Hacker rank DS algo test.

Q1. How would you handle real time data in mobile app?
Ans. 
Real time data in mobile apps can be handled using technologies like WebSockets, Firebase Realtime Database, or Push Notifications.
• Use WebSockets for bidirectional communication between client and server.

• Utilize Firebase Realtime Database for syncing data in real time across devices.

• Implement Push Notifications to notify users of real time updates even when the app is not open.
Answered by AI
Add your answer
Q2. OOPs and solid principle discussion
Add your answer

Q1. Salary discussion
Add your answer

Q1. Basics of react and JS concepts.
Add your answer

Q1. How to do Database Migration
Ans. 
Database migration involves transferring data from one database to another without losing any information.
• Plan the migration process carefully to minimize downtime and ensure data integrity

• Backup the existing database before starting the migration

• Use tools like AWS Database Migration Service or open-source tools like Flyway or Liquibase

• Test the migration process thoroughly before executing it on the production database

• ...read more
Answered by AI
Add your answer
Q2. How to perform Distributed Transactions using Saga
Ans. 
Saga pattern is used to manage distributed transactions by breaking them into smaller, independent transactions.
• Break the transaction into smaller steps or sub-transactions

• Each sub-transaction is executed by a service or component in the system

• Maintain a log of each sub-transaction's status to ensure consistency

• If a sub-transaction fails, rollback the changes made by previous sub-transactions

• Implement compensating tran...read more
Answered by AI
Add your answer

Q1. How to optimize Horizontally RDBMS
Ans. 
Optimizing horizontally RDBMS involves partitioning data across multiple servers to improve performance.
• Partition tables based on key ranges or hash values to distribute data evenly

• Use sharding to split data across multiple servers

• Implement caching mechanisms to reduce database load

• Optimize queries and indexes for efficient data retrieval

• Consider denormalizing data to reduce joins and improve performance
Answered by AI
Add your answer
Q2. System design of URL shorten
Ans. 
URL shortening system design involves generating short aliases for long URLs to save space and make sharing easier.
• Use a unique identifier for each URL to generate short alias

• Store mappings of short aliases to original URLs in a database

• Implement a redirect service to redirect short aliases to original URLs

• Consider scalability and performance for high traffic

• Implement analytics to track usage and performance
Answered by AI
Add your answer

Python & SQL Based HackerRank Coding Round

Q1. Resume Based Questions
Add your answer
Q2. Tools & Tech mentioned in resume will be asked
Add your answer
Q3. Past projects and what are your contributions
Add your answer

Q1. System design and architecture level discussions
Add your answer

Q1. Culture fit with the company
Add your answer