Vhunt4u Interview Questions and Answers

Q1. End to end architecture of current project
Add your answer
Q2. Basic spark code to read & write files
Add your answer
Q3. How to upsert data in table in spark
Add your answer
Q4. How do you handle sudden increase in data volume
Add your answer
Q5. Discussion on delta tables & ACID transactions
Add your answer
Q6. Explain autoloader and use case in Databricks
Add your answer
Q7. SQL question using window functions Lead, row number
Add your answer
Q8. Python question using hashmap & String
Add your answer

Q1. Current project understanding end to end
Add your answer
Q2. Data pipeline design for a ride sharing company, ask bunch of follow up questions on the conclude a particular design.
Add your answer
Q3. Explain how you follow SDLC(Agile, waterfall) ?
Add your answer
Q4. Why are you looking for a change now
Add your answer

Q1. Basic introductions
Add your answer
Q2. What kind of work are you looking for? what do you know about the company
Add your answer
Q3. Willing to relocate?
Add your answer
Q4. Personal hobbies and aspirations
Add your answer

What are the key principal you follow for telerehabilitation

Introduce your self ?

What all techniques and methode do you folow

Q1. What are your hobbies ?
Ans. 
My hobbies include hiking, playing tennis, and cooking new recipes.
• Hiking in local trails and national parks

• Playing tennis at the community courts

• Experimenting with new recipes in the kitchen
Answered by AI
Add your answer
Q2. Tell your work experience
Add your answer

Q1. How do you handle the cases where patietn is not responding properly
Add your answer
Q2. Please explain how do you treate a patient with chronic case ?
Add your answer

Q1. How do you builde rappo with new patient
Add your answer
Q2. What is your overall expericne c
Add your answer

Q1. What do you know about our company
Add your answer

Q1. What is your take on patietn ?
Add your answer

It took total 6 days for interview and revert

It was a coding round interview along with interviewer via Virtual mode. I was given 2 coding questions on HackerRank for the interview:

1. one was an easy problem on counting minimum replacements.
2. "pat is an ordinary kid who works hard to be a great runner...." this was a challenging problem (which I managed to solve).
3. I was asked some basic Python questions, as the role was for a Python Developer.

Q1. LLD for Parking Lot
Add your answer
Q2. Which database are you going to use for Parking lot and Why ?
Ans. 
I would use a relational database like MySQL for the Parking lot as it provides structured data storage and supports complex queries.
• Relational databases like MySQL offer structured data storage for parking lot information

• Supports complex queries for managing parking lot data efficiently

• Ability to handle large amounts of data and transactions

• Provides data integrity and security features

• Can easily integrate with other s
Answered by AI
Add your answer
Q3. Questions related to OOPs
Add your answer
Q4. Questions related to Multi Threading
Add your answer
Q5. Questions related to Projects
Add your answer

Q1. I hate this since i was informed that this round was a technical.
Add your answer
Q2. Usual Mangerial questions, Project Related, etc
Add your answer

Q1. Explain any 1 of your Project.
Add your answer
Q2. SQL: Explain difference between Delete, Truncate and Drop. Difference between Group by and Having. Asked to write a update query.
Add your answer
Q3. Python: Difference between Set and Dictionary. Can we update key in dictionary? Write solution for given python question (nums = [1,2,3,4,5,7,10] target = 9 output = [1,5])
Ans. 
Set is a collection of unique elements, while dictionary is a collection of key-value pairs. Keys in dictionary can be updated.
• Set does not allow duplicate elements, while dictionary allows duplicate values but not duplicate keys.

• Dictionary uses key-value pairs for storing data, while set only stores individual elements.

• Example: Set - {1, 2, 3}, Dictionary - {'a': 1, 'b': 2}

• Yes, keys in dictionary can be updated by ass
Answered by AI
Add your answer

Q1. Explain projects where you have implemented ETL. Difference between aws lambda and aws glue
Add your answer
Q2. Non-Technical questions
Add your answer

Q1. How many EBS can be attached to single EC2
Ans. 
The maximum number of EBS volumes that can be attached to a single EC2 instance is 40.
• Maximum of 40 EBS volumes can be attached to a single EC2 instance

• Each EBS volume can be up to 16 TiB in size

• EBS volumes can be attached and detached while the instance is running
Answered by AI
Add your answer
Q2. Prerequisites for S3 Cross Region Replication
Ans. 
Prerequisites for S3 Cross Region Replication include enabling versioning, configuring IAM roles, and ensuring proper bucket policies.
• Enable versioning on both source and destination buckets

• Configure IAM roles with proper permissions for replication

• Ensure proper bucket policies are in place for cross region replication
Answered by AI
Add your answer
Q3. Docker Restart will change which attributes of comtainer
Ans. 
Docker Restart changes the container's attributes like IP address, hostname, and uptime.
• IP address of the container will change after restart

• Hostname of the container may change

• Uptime of the container will be reset

• Any changes made to the container's filesystem will be lost
Answered by AI
Add your answer
Q4. S3 vs EFS scenario based use cases.
Ans. 
S3 is ideal for storing static files like images and videos, while EFS is better for shared file storage among multiple EC2 instances.
• S3 is object storage, suitable for storing large amounts of unstructured data like images, videos, backups, and logs.

• EFS is a file storage service that can be mounted on multiple EC2 instances, making it ideal for shared file systems and databases.

• Use S3 for static website hosting, data ...read more
Answered by AI
Add your answer
Q5. Linux Commands and Chmod Calculation
Add your answer

Q1. Difference between static and final
Ans. 
Static is used to define class-level variables and methods, while final is used to define constants that cannot be changed.
• Static variables belong to the class itself, while final variables are constants that cannot be modified.

• Static methods can be called without creating an instance of the class, while final methods cannot be overridden.

• Static variables are shared among all instances of a class, while final variables...read more
Answered by AI
Add your answer
Q2. ArraysList vs LinkedList
Ans. 
ArrayList is better for random access, LinkedList is better for frequent insertions/deletions.
• ArrayList uses dynamic array to store elements, LinkedList uses doubly linked list.

• ArrayList provides fast random access to elements using index, LinkedList provides fast insertion/deletion at any position.

• Example: ArrayList is suitable for scenarios where random access is required like searching, LinkedList is suitable for sc...read more
Answered by AI
Add your answer
Q3. Describe Java8 Features
Ans. 
Java8 introduced several new features including lambda expressions, functional interfaces, streams, and default methods.
• Lambda expressions allow you to write code in a more concise and readable way.

• Functional interfaces are interfaces with a single abstract method, which can be implemented using lambda expressions.

• Streams provide a way to work with collections of objects in a functional style.

• Default methods allow inte...read more
Answered by AI
Add your answer
Q4. Gave one scenario to solve using streams in java8
Ans. 
Using streams in Java 8 to filter and map a list of numbers
• Create a list of numbers

• Use stream to filter out even numbers

• Use map to square each number

• Collect the results into a new list
Answered by AI
Add your answer
Q5. Multithreading- Write program to print even and odd numbers from 1 to 20 using 2 threads. 1 thread will responsible for printing even and another for Odd. And print in such a manner it should be alternate....read more
Ans. 
Program to print even and odd numbers from 1 to 20 using 2 threads alternately.
• Create two threads, one for printing even numbers and one for printing odd numbers.

• Use wait(), notify(), and notifyAll() to ensure alternate printing.

• Ensure synchronization between the two threads to avoid race conditions.

• Example: Thread 1 prints even numbers (2, 4, 6, ...) and Thread 2 prints odd numbers (1, 3, 5, ...).
Answered by AI
Add your answer
Q6. Why strings immutable
Ans. 
Strings are immutable to ensure data integrity and security.
• Immutable strings prevent accidental changes to data

• Immutable strings allow for safe sharing of data between different parts of a program

• Immutable strings help prevent security vulnerabilities like SQL injection attacks
Answered by AI
Add your answer
Q7. Outer Join SQL query
Add your answer
Q8. What is the purpose of using default methods in java8?
Ans. 
Default methods in Java 8 allow interfaces to have method implementations, enabling backward compatibility and reducing code duplication.
• Default methods were introduced in Java 8 to provide a way to add new methods to interfaces without breaking existing implementations.

• They allow interfaces to have method implementations, which was not possible before Java 8.

• Default methods can be overridden in implementing classes to...read more
Answered by AI
Add your answer

Q1. 1 coding problem related to Anagrams
Add your answer
Q2. 1 Java8 streams problem
Ans. 
Using Java8 streams to solve a problem
• Use stream() method to convert a collection into a stream

• Use filter() method to filter elements based on a condition

• Use map() method to transform elements

• Use collect() method to collect the elements into a new collection
Answered by AI
Add your answer
Q3. What are checked exceptions
Ans. 
Checked exceptions are exceptions that must be either caught or declared in the method signature.
• Checked exceptions are subclasses of Exception (excluding RuntimeException and its subclasses)

• Checked exceptions must be either caught using try-catch block or declared in the method signature using 'throws' keyword

• Examples of checked exceptions in Java include IOException, SQLException, and ClassNotFoundException
Answered by AI
Add your answer
Q4. Purpose of @SpringBootApplication annotation?
Ans. 
Annotation used to mark a class as a Spring Boot application
• Combines @Configuration, @EnableAutoConfiguration, and @ComponentScan annotations

• Used to bootstrap and launch a Spring application

• Automatically scans for Spring components in the package and sub-packages
Answered by AI
Add your answer
Q5. Use of @Qualifier
Ans. 
Annotation used in Spring to specify which bean to autowire
• Used to disambiguate when multiple beans of the same type are present

• Can be used with @Autowired to specify which bean to inject

• Helps in resolving dependencies when multiple beans of the same type are available
Answered by AI
Add your answer
Q6. What are microservices?
Ans. 
Microservices are a software development technique where an application is composed of small, independent services that communicate with each other.
• Microservices are designed to be small, focused on specific tasks, and independently deployable.

• Each microservice typically runs its own process and communicates with other services through APIs.

• Microservices allow for easier scalability, flexibility, and maintenance compar...read more
Answered by AI
Add your answer
Q7. Design patterns
Add your answer
Q8. How microservices communicate with each other
Ans. 
Microservices communicate with each other through APIs, messaging queues, or service meshes.
• APIs: Microservices can communicate with each other by exposing APIs that allow them to send and receive data.

• Messaging queues: Microservices can use messaging queues like RabbitMQ or Kafka to send messages to each other asynchronously.

• Service meshes: Microservices can communicate through a service mesh like Istio, which handles...read more
Answered by AI
Add your answer

Q1. Asked about projects.
Add your answer
Q2. Complete flow and business use case of the project
Ans. 
The project involves creating a web-based platform for online shopping with features like user registration, product browsing, shopping cart, and payment processing.
• User registers on the platform with personal information

• User browses products by category or search

• User adds products to the shopping cart

• User proceeds to checkout and makes payment

• Order is confirmed and user receives a confirmation email
Answered by AI
Add your answer
Q3. Interviewer was more concerned about matching the tech stack with job description
Add your answer

Q1. How does a cell communicates between 2 sites.
Ans. 
Cells communicate between 2 sites through various signaling pathways, including direct cell-to-cell contact and chemical signaling.
• Cells can communicate through direct cell-to-cell contact, such as gap junctions or cell adhesion molecules.

• Cells can also communicate through chemical signaling, such as paracrine signaling (local signaling) or endocrine signaling (long-distance signaling).

• Examples include neurotransmitter...read more
Answered by AI
Add your answer
Q2. L3 layer details
Add your answer

Q1. DSA problem to find the count of characters in a string
Ans. 
Use a hashmap to count the occurrences of each character in the string.
• Create a hashmap to store character counts

• Iterate through the string and update counts in the hashmap

• Return the hashmap with character counts
Answered by AI
Add your answer
Q2. VOiP related questions
Add your answer

Mintu Babu lives in a smaller house than her brother and in a larger house than her parents. Her children reside with her, and she has no other relatives. If Mintu Babu's relative U lives in a larger house than her relative S, then all the following may be true except: \n\n1) S is U's father \n\n2) S is U's mother \n\n3) U is younger than S \n\n4) S is younger than U

Q1. 1. merge two linked list
Ans. 
Merge two sorted linked lists without creating new nodes by rearranging existing nodes.
• Traverse both linked lists simultaneously

• Compare the values of nodes and rearrange pointers accordingly

• Continue until one of the lists is fully traversed
Answered by AI
Add your answer
Q2. 2. reverse a linked list.
Ans. 
Reverse a linked list by changing the direction of pointers.
• Start with three pointers: current, previous, and next.

• Iterate through the linked list, updating pointers to reverse the direction.

• Update the head of the linked list to be the previous node once iteration is complete.
Answered by AI
Add your answer

Q1. SQL Questions on joining tables
Add your answer
Q2. SQL Questions on optimizing codes
Add your answer

How to approach a data base schema creation and optimization for BMS

Q1. What are your strenghts
Ans. 
My strengths include strong analytical skills, excellent communication abilities, and a proven track record of delivering successful business solutions.
• Strong analytical skills - able to analyze complex data and identify key insights

• Excellent communication abilities - able to effectively communicate with stakeholders at all levels

• Proven track record of delivering successful business solutions - have led multiple projec
Answered by AI
Add your answer
Q2. Questions on leadership skills and conflict resolution
Add your answer