Apollo Hospitals Data Scientist Interview Questions and Answers

Q1. In depth project based qiestions
Add your answer

Q1. How do you do pruning
Ans. 
Pruning is a technique used in machine learning to reduce the size of decision trees by removing unnecessary branches.
• Pruning helps prevent overfitting by simplifying the model

• There are two main types of pruning: pre-pruning and post-pruning

• Pre-pruning involves setting a limit on the depth of the tree or the number of leaf nodes

• Post-pruning involves removing branches that do not improve the overall accuracy of the tree

• ...read more
Answered by AI
Add your answer

Q1. Hr questions about my background with company
Add your answer
Q2. About my technical skills
Add your answer

There were 2 SQL queries based on rank function and count aggregation. 1 python program based on array.

Q1. 2 sql questions. Was asked which technology I worked on- aws redshift.
Add your answer
Q2. Architecture of redshift. keys in redshift.
Ans. 
Redshift is a cloud-based data warehousing solution by AWS. It uses columnar storage and massively parallel processing.
• Redshift is based on PostgreSQL and uses SQL for querying data.

• It uses columnar storage which is optimized for analytical queries.

• Redshift is a massively parallel processing (MPP) system, which means it can distribute queries across multiple nodes for faster processing.

• It uses key-based sharding to dis...read more
Answered by AI
Add your answer
Q3. 1 python program on sliding window technique .
Ans. 
Sliding window technique is used to solve problems where we need to find a substring of a certain length in a larger string.
• Define the window size and slide it over the string

• Use two pointers to keep track of the start and end of the window

• Examples: Maximum sum subarray of size K, Longest substring with K distinct characters
Answered by AI
Add your answer

Q1. 3 sql queries. architecture for a data pipeline to display hour per activity in last 24 hra on a smartwatch .
Ans. 
Design a data pipeline to display hourly activity on a smartwatch for the last 24 hours using SQL queries.
• Create a table to store activity data with columns for timestamp and activity type.

• Use a SQL query to aggregate activity data by hour for the last 24 hours.

• Display the results on the smartwatch using a suitable visualization.
Answered by AI
Add your answer

Q1. Random forest splitting mechanisms details
Ans. 
Random forest uses decision trees to split data into subsets based on feature importance.
• Random forest builds multiple decision trees and selects the best split based on feature importance.

• Each decision tree splits data into subsets based on a randomly selected subset of features.

• The best split is determined by minimizing impurity or maximizing information gain.

• Random forest can handle missing values and outliers.

• Rando...read more
Answered by AI
Add your answer
Q2. ResNet architecture and skip connection related questions
Add your answer

Q1. OCR related bounding box detection from image
Add your answer
Q2. Deep learning based questions and details
Add your answer

Q1. Salary discussion, current salary and expected
Add your answer
Q2. About Optum, why you want to join
Add your answer

Q1. Tell me something about yourself?
Add your answer
Q2. What are your strengths?
Add your answer