Powerweave Interview Questions and Answers

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.

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 of 90, 85, 85, 80 - Rank would be 1, 2, 2, 4. Dense Rank w...read more

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

Designing a book lending system involves creating a user-friendly platform for borrowing and returning books.

• Create a user-friendly interface for users to search and request books

• Implement a system for tracking book availability and due dates

• Include features for users to renew or return books online

• Establish a notification system for overdue books

• Set up a process for managing reservations and holds on popular books

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

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

Yes, I have knowledge about lab tests.

• I am familiar with various lab tests and their procedures.

• I understand the importance of accurate and timely lab test results.

• I have experience in coordinating with lab technicians and doctors to ensure proper testing and interpretation of results.

• For example, I have worked with a lab to conduct blood tests for cholesterol levels in patients and communicated the results to their physicians.

I would invest in real estate, start a business, travel the world, and donate to charity.

• Invest in real estate to generate passive income

• Start a business to create job opportunities

• Travel the world to experience different cultures

• Donate to charity to give back to the community