Magenta Mobility Marketing Interview Questions and Answers

Q1. Explain Joins in SQL?
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• ...read more
Answered by AI
Add your answer
Q2. What is Normalisation?
Ans. 
Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalisation involves breaking down data into smaller, more manageable tables

• It helps in reducing data redundancy by storing data in a structured way

• It improves data integrity by ensuring that each piece of data is stored in only one place

• Normalization is usually done in multiple stages (1NF, 2NF, 3NF, etc.) t...read more
Answered by AI
Add your answer

Questions mostly revolved around pandas and numpy.

Q1. React and redux and more of frnd end
Add your answer

It was about common analytics concepts

Q1. How many red cars estimate in bangalore
Ans. 
It is impossible to accurately estimate the number of red cars in Bangalore without specific data.
• Estimating the number of red cars in Bangalore would require access to vehicle registration data, which is not readily available.

• Factors such as the total number of cars in Bangalore, the percentage of red cars among them, and the distribution of red cars across the city would need to be considered.

• One could potentially co...read more
Answered by AI
Add your answer
Q2. What will be approach to estimate next year revenue
Ans. 
To estimate next year revenue, I would analyze historical data, market trends, and potential growth opportunities.
• Analyze historical revenue data to identify patterns and trends

• Consider market trends and economic indicators that may impact revenue

• Evaluate potential growth opportunities such as new product launches or market expansions

• Use forecasting techniques such as regression analysis or time series analysis

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

Twisted Dsa questions were asked .. pretty interesting was a fun interview

Q1. The had asked questions about the field SQL etc
Add your answer

Q1. Array question, Tree question
Add your answer

Q1. ROR questions, System Design
Add your answer

Q1. Scenario Based, HR questions
Add your answer

Q1. It was regarding the tools and technologies we worked on. AWS services we worked on. How deployment happens.
Add your answer
Q2. What was the project you worked on.
Add your answer

Q1. Exploratory discussion
Add your answer

Q1. SQL Excel and Tableau
Add your answer

Q1. Why are you looking for a change?
Add your answer
Q2. Tell me about yourself.
Add your answer
Q3. What are your salary expectations?
Add your answer
Q4. Share details of your previous job.
Add your answer