Final assignment of Tech for Product Managers Course by HelloPM

Byaakritpatel

The complete playlist of all the lectures can be found here:

Here’s the question given for the assignment:

You are in the final round of the shortlisting process for the product manager position at Reddit

So far you have cracked the product sense, metrics, and behavioral round well and the team is impressed with your candidature.

As this role requires working with engineers in a tech-first company, the next would be a technical round with the CTO.

The following questions are given to you as a part of the on-site round, you can access a computer with the internet and any tool of your choice.

As a deliverable, you need to create a deck answering these questions, which you will present to the CTO at the end of the day.

Question 1:

What are the technologies Reddit uses to deliver its app and website experience? Categorize these into front-end, back-end, and database./

Question 2:

Pick any two technologies and provide alternative technologies along with possible trade-offs of using one over the other.

Question 3:

Design a database schema that should work for the following features of Reddit:

  1. User Registration
  2. A user posting something in a subreddit
  3. The user creating a new subreddit
  4. User liking a post in a subreddit
  5. User adding a comment on a post

Question 4:

Write SQL to:

  1. To show the recent 10 posts in a subreddit and information about the users who have posted those.
  2. Find the most-liked post ever
  3. Find the number of subreddits created by a particular user
  4. Find the user who has given the most likes
  5. Find all posts that have a URL in the description

Question 5:

DuckDuckGo (Search Engine) and Reddit are looking to get into a partnership, where every keyword search on DuckDuckGo would contain a link to a related post on Reddit on search results page. Reddit will share the revenue made from this traffic with DuckDuckGo.

What would an API that helps connect the two would look like?

Here’s the answer that I submitted:

https://docs.google.com/presentation/d/1W5Q14_W4ZygZtmBvRe-Xu6bW7uqg8NKu2GsW_HxVYnQ/edit#slide=id.p

You might also like