Apollo 247 Production Analyst Interview Questions and Answers

Q1. Basic SQL 2 table join question
Add your answer
Q2. Probability of bullet firing if 3 bullets are placed consecutively in a gun
Ans. 
The probability of a bullet firing when 3 bullets are placed consecutively in a gun is 1/3.
• The probability of each bullet firing is independent of the others, assuming the gun is functioning properly.

• Each bullet has a 1/3 chance of firing when the trigger is pulled.

• This is assuming all bullets are loaded and the gun is in working condition.
Answered by AI
Add your answer

Q1. Difference between rank, dense rank and row number
Ans. 
Rank assigns a unique number to each row based on a specified column, Dense Rank assigns consecutive numbers without gaps, Row Number assigns a unique number to each row in the result set.
• Rank function may have gaps in the ranking sequence if there are ties.

• Dense Rank function does not have gaps in the ranking sequence.

• Row Number function assigns a unique number to each row in the result set.

• Example: If we have scores ...read more
Answered by AI
Add your answer
Q2. 3 SQL window function questions
Add your answer

How would you explain XYZ to a layman?

then a guesstimate on no. of orders delivered by Swiggy in bangalore in a month

What are your strengths as a product analyst

Q1. Probality Questions and SQL difference between left join and join
Add your answer
Q2. Guesstimate: Number of orders on swiggy in day
Ans. 
Approximately 1 million orders per day on Swiggy
• Consider the population of the city where Swiggy operates

• Look at the average number of orders per person per day

• Factor in peak hours and weekends for higher order volumes
Answered by AI
Add your answer
Q3. Past experiences
Add your answer