Apollo 247 Interview Questions, Process, and Tips

Q1. Make a Media plan for specific use case. Assume budgets.
Ans. 
Create a media plan for a new skincare product launch with a budget of $100,000.
• Identify target audience (women aged 25-45)

• Select relevant media channels (social media, beauty magazines)

• Allocate budget accordingly (50% on social media ads, 30% on magazine ads, 20% on influencer partnerships)

• Create engaging content and visuals to attract attention

• Monitor and analyze campaign performance for optimization
Answered by AI
Add your answer

Q1. Salary expected
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the Sr. Manager Marketing role.
• I am open to discussing salary based on the overall compensation package offered

• I have researched the market rates for Sr. Manager Marketing positions in this industry

• I am looking for a salary that reflects my experience and contributions to the company

• I am also interested in benefits, bonuse
Answered by AI
Add your answer

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. About previous work experience, CTC, Why do I want to switch etc
Add your answer

Confendential cannot be disclosed have signed NDA

Q1. Questions based on case study
Add your answer
Q2. Questions based on excel
Add your answer

Q1. Telephonic round with HOD. What will it take to keep you here for 5 years
Add your answer

LC Easy type mostly on linear data structures.

Q1. System design a quick commerce. (HLD)
Ans. 
Quick commerce system design involves creating a platform for fast delivery of goods and services.
• Focus on real-time order processing and delivery logistics

• Implement efficient inventory management system

• Integrate with payment gateways for seamless transactions

• Utilize geolocation services for accurate delivery tracking
Answered by AI
Add your answer
Q2. In Depth Node.js questions
Add your answer