Fortis Memorial Research Institute Associate Consultant Interview Questions and Answers

Q1. Snowflake sql data warehousing data lake azure
Add your answer
Q2. Data warehousing vs data lake? why is it useful
Ans. 
Data warehousing is structured and optimized for querying, while data lake is a more flexible storage solution for raw data.
• Data warehousing involves storing structured data in a relational database for optimized querying.

• Data lakes store raw, unstructured data in its native format for flexibility and scalability.

• Data warehousing is useful for business intelligence and reporting, providing a structured and organized da...read more
Answered by AI
Add your answer

A new product launch in France geography for a specific indication. Answer the Qs on the next 5 slides based on the details on slide 1. Calculate the metrics provided and share insights.

Q1. Asked more technical Questions related to my domain
Add your answer

Q1. Its mix of both technical and non technical
Add your answer

Q1. 1st round was interview
Add your answer

Writing a review article within 3000 words

Q1. General qu and company policy and culture
Add your answer

Q1. Salary expectations and location preference
Add your answer

Case study was mostly on DL since I'd some similar projects on my resume.

Q1. List out linear regression Assumptions
Ans. 
Linear regression assumptions include linearity, independence, homoscedasticity, and normality.
• Linearity: The relationship between the independent and dependent variables is linear.

• Independence: The residuals are independent of each other.

• Homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.

• Normality: The residuals are normally distributed.

• No multicollinearity: The ...read more
Answered by AI
Add your answer
Q2. Concept of KNN and how to decide optimal N
Ans. 
KNN is a machine learning algorithm that classifies data points based on the majority class of its k-nearest neighbors.
• KNN stands for K-Nearest Neighbors

• It is a non-parametric and lazy learning algorithm

• To decide the optimal value of N (number of neighbors), cross-validation techniques like Grid Search can be used

• Choosing a small value of N can lead to overfitting, while a large value can lead to underfitting
Answered by AI
Add your answer

Q1. Mostly based on Salary discussion
Add your answer

Q1. General introduction type questions
Add your answer
Q2. Discussion on work profile
Add your answer

Market Research and CI case study

Mix of Aptitude test and case study assignment

Basic array and strings questions. Apart from this data base section was most important.

Q1. OOP concepts in Java. Basic SQL questions about joins and unions
Add your answer
Q2. Difference between self join and full join
Ans. 
Self join is used to join a table to itself, while full join returns all rows from both tables.
• Self join is used when we want to compare records within the same table.

• Full join is used when we want to combine all rows from both tables, including unmatched rows.

• Self join can be used to find hierarchical relationships within a table.

• Full join can be used to find all records that match between two tables, as well as any u...read more
Answered by AI
Add your answer
Q3. What is Abstraction in oop
Ans. 
Abstraction is the process of hiding complex implementation details and showing only the necessary information to the user.
• Abstraction is a fundamental concept in OOP

• It helps in reducing complexity and increasing efficiency

• It allows the user to focus on the essential features of an object

• Examples include abstract classes, interfaces, and encapsulation
Answered by AI
Add your answer
Q4. Prime number using Java
Ans. 
A prime number is a number that is only divisible by 1 and itself.
• Iterate through numbers from 2 to n-1

• Check if n is divisible by any number in the range

• If not, n is a prime number
Answered by AI
Add your answer
Q5. Simple scenario based sql queries
Add your answer