Interview Questions

Bg - "Clarifying question: Am I the first one to notice the fire, or there are people already on it? Extent and source of fire - I am assuming it's localized and I am inside the data center, safe so far. Response: It is an emergency. I will do and coordinate the people to do the following in parallel, if I am the first one to know. Get immediate attention of folks in the data center. Get someone and many people to call 911 and security. Coordinate to have people in need evacuated. Turn off th"See full answer

Ilnur I. - "I really appreciate how he clearly explains every term he uses!"See full answer

Darpan D. - "Clarifying questions and Assumptions ChatGPT search means the search function inside the chat app? OR ChatGPT search Chrome extension? Assumption: Search inside the chat app. Is there any location restriction in this analysis? Assumption: USA only. Is there any user segment restriction in this analysis? Assumption: All user segments. Are we assuming the ChatGPT search already exists or going back in time before the ChatGPT search existed? Assumption: Go back in time"See full answer

Priyansh J. - "By increasing the number of paid users, I assume we mean that we want to increase the % of DAUs who pay for YT Music. First, we need to understand the Youtube Music play here. Youtube Music was carved out of Youtube because Spotify and Apple Music were getting popular. Users were listening to music on Spotify instead of on Youtube, threatening ad revenue for Youtube. Therefore, Youtube Music was born as a standalone app, where users could listen to the music ad free from anywhere anytime. In"See full answer

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

M D. - "Understand the business problem: Identify the business problem that the AI data product is intended to solve. Identify the target audience: Understand who will be using the data and what problem they will be solving for using the data. This will inform the features and functionality that should be included in the product. Gather and preprocess the data: Collect and preprocess the data that is relevant to the problem that it is being solved for. This will inform the AI algorithm"See full answer

Alexander R. - "In my previous role as a Team Leader at XYZ Corporation, our department was facing high turnover rates, and the skill levels within the team were not meeting the company's evolving demands. We were in the midst of a major project that required a skilled and cohesive team to deliver on tight deadlines. My primary responsibility was to enhance team development and retention. Specifically, I needed to reduce turnover by 20% within six months and improve team competency to handle new project requir"See full answer

Christopher K. - "Background Context I'm a PM at a venture-backed SaaS in the legal tech space. We provide end-to-end contract management experience for our customers with the following features: Upload - Contracts signed in DocuSign, etc. automatically uploaded to our system through API integrations. Data Extraction - Contract terms such as payment terms and key dates are automatically OCRed and extracted using ML. Analytics - Contract terms are searchable, filter, and customize for reporting. Work"See full answer

Anonymous Possum - "#inplace reversal without inbuilt functions def reverseString(s): chars = list(s) l, r = 0, len(s)-1 while l < r: chars[l],chars[r] = chars[r],chars[l] l += 1 r -= 1 reversed = "".join(chars) return reversed "See full answer

Daniel L. - "You're the PM for all of Instagram Stories. What is your North Star metric? Meta's Mission: Give people the power to build community and bring the world closer together. IG's Mission: To capture and share the world's moments User Types Marketplace / 2-sided ecosystem Creators and the Consumers Metric Categories Adoption Engagement Retention [not pictured]: create a table with 2 columns: Creators and Consumers and 3 rows: Adoption, Engagement, Retention. Talked through and priori"See full answer

Anonymous Krill - "Clarify the question. Any specific system? Will study the related systems in the environment. Will define the goal, attributes of the system, stakeholders expectations, problems this system is going to address in case these things don't exist already. With the above two steps, I Will come up with a draft of the System KPI. Will run it with leadership, stakeholders and will incorporate feedback. In parallel, will come up with quantification on these performance factors. Fina"See full answer

Surbhi G. - "Hi Team, where can I see sample answers for this question?"See full answer

Christina Z. - "That is a great product opportunity. I see the vision to drive engagement by building a reward based experience to encourage kids to login to the app and track their books and trigger a visual pleasing experience when the child completes a book. The more complex the book, the bigger the reward."See full answer

Anonymous Deer - "This interviewee had a decent framework but the specifics weren't impressive. I wouldn't post this as an example and would appreciate if you could replace this video."See full answer

Satesh A. - "I dont know is good and you should use however than but."See full answer

James W. - "I've recently worked closely with a product that had both the best and worst performing teams. The situation is that one team is struggling to deliver within a reasonable timeframe, a few stronger members of the team are carrying the weaker. Work is taking a long time. They aren't listening to each other. They aren't helping each other to get work over the line. They are getting stuck down rabbit holes. They aren't continually improving their processes. They are getting frustrated and at risk o"See full answer