Interview Questions

Anonymous Finch - "great answer!"See full answer

Chelsea F. - "Questions: Clarify: High school = grades 9-12? So roughly ages 15-18 (4 years)? Are we talking about all high-school aged kids, or kids who actually attend HS? Do we count home schoolers? Drop outs? Assumptions: Let's assume we're estimating the number of children in the U.S. who are enrolled in/attend HS Assuming a uniform distribution of the population across ages Approach: U.S. Population = 300m Average lifespan = 80 years 4 years represented by HS age = 5% of the populati"See full answer

Vidur K. - "Clarifying Questions First, let me try to clarify what kind of self-driving car are we talking about here. Let' say, we have the following top-level assumptions: Fully autonomous Family Sedan Car US Market This technology is only available with Google In a real face-to-face interview would pause to ask the interviewer to correct assumptions or ask for other features. Consumer Family - uses the autonomous ability of the car to spend time with kids while dropping them off to"See full answer

Abhishek T. - "I explained about a project that was technically very challenging and had tight deadline. We were working on a new technology with new team members but delay was not an option. When we hit a road block due to lack of knowledge on Content Management System and Database, we came up with an idea of hard coded JSON data to help continue building the front end and user experience while team is figuring out to unblock the CMS and DB blocker. That way we would still move forward and show progress in IT"See full answer

Alexey T. - "with t1 as (select employee_name, department_id, salary, avg(salary) over (partition by departmentid) as avgsalary, abs(salary - avg(salary) over (partition by department_id)) as diff from employees ) select employee_name, department_id, salary, avg_salary, denserank() over (partition by departmentid order by diff desc) as deviation_rank from t1 order by departmentid asc, deviationrank asc, employee_name `"See full answer

Anjan M. - "Product - Google Glass Undefined Core Segment & Jobs-to-Be-Done - Google pitched Glass to “everyone” but never clarified a must-have use case for any one group. Improper Category Context - It was positioned as a lifestyle product, but could not justify a use case that a mobile device could not already do. Premium Pricing of a Prototype- Explorer Edition cost 1500 usd. This gap alienated hobbyists and discouraged volume sales. Privacy Backlash- The Always-on camera r"See full answer

Ben G. - "A more senior answer -> influencing stakeholders Defining who stakeholders will be and roles and responsibilities early one Identifying timelines and roadmapping Identifying key business needs and how they related to core product Identifying how the project will be successful (KPIs) Identify business, user and product goals Speaking your stakeholder’s language, build empathy by discovery and understanding their motivations and make them a part of the co-creation process (ie calc"See full answer

Arnab R. - "Trying to find the reason for the low utilization. If it is systematic risk, I will down size the team temporarily. If is due to planning try to tweak details in order to bring 50-50 with a 90 days target time."See full answer

Ananya M. - "US population = 330M , 80M across 4 generations population that is physically able to travel, can afford travel, travels for business ranges between 20-60 year olds = 160M calculating maximum demand: long weekends in summer are peak travel times, lets assume 60% of population who are able and can afford travel, do so during long weekend = 0.6x160M lets say 60% of this population choses prefers domestic travel while 40% go international (consider Mexico, Canada, London are international"See full answer

Sayee M. - "talked about a time when customer is trying to go to cloud for first time and championing the effort.. it is strategic and also a risk because outside of the OEM, no one we know had implemented this product architecture on the cloud.. used first [principles, did a crawl, walk jog approach and implemented it. Risk because of lack of reference architecture, clodu tech was new to me . career making/breaking project for customer. result : project was successful. presented story in a conference."See full answer

Peter H. - "As a technology leader with enormous power and influence, Google has a significant role to play in global social responsibility. Right now, that means that Google must focus on how humanity can create a sustainable future. If I had unlimited resources, I would focus on the products that enable future mobility in sustainable cities. The success of Gogoro, the Taiwanese scooter manufacturer that has created a swappable battery pack system for small scooters, shows how green tech, consumer visib"See full answer

Soma R. - "SELECT a.marketing_channel, AVG(a.purchasevalue) AS avgpurchase_value, SUM(CASE WHEN a.purchasevalue > 0 THEN 1 ELSE 0 END) * 100 / COUNT(a.sessionid) AS conversion_rate FROM attribution a LEFT JOIN user_sessions u ON a.sessionid = u.sessionid GROUP BY a.marketing_channel ORDER BY conversion_rate DESC; "See full answer

Ali H. - "SQL databases are relational, NoSQL databases are non-relational. SQL databases use structured query language and have a predefined schema. NoSQL databases have dynamic schemas for unstructured data. SQL databases are vertically scalable, while NoSQL databases are horizontally scalable."See full answer

Arista V. - "Assumption: Considering the launch of a product r a service based company in a new market: 1) Need of the product / service - consumer needs 2) Presence of competitor and their market share 3) Consumer behaviour - can this be changed if such need doesn't exist explicitly( ex: ride hailing) 4) Existing price of the product 5) Marketing spend to launch in that market and opportunity to make revenue"See full answer

Amir R. - "The key feature of echo is voice assistance. The demography for that audience has the following key behavior or use cases: Tech-savvy folks Use the voice assistant for their work (dictation service like writers, doctors, etc) Use for the driving assistance Use for the disabled Security and home automation."See full answer

Arthur Y. - "Clarifying Questions: Clarify scenario My assumed answer: I walk through example flow of family watching YT via Chromecast on parent’s account, then an adult-themed video auto-plays What is goal? My assumed answer: From the prompt, the immediate goal is to prevent inappropriate videos from playing at inappropriate times. At a higher-level, since Google/YT has such a high market penetration % already, the goal is retention of existing users and not having them stop usin"See full answer

Roy C. - "Note: This is my answer that I generated loosely while I was practicing this question. I didnt want to go down the product design framework as this is more of an execution question, so I came up with my own zombified framework to focus more on strategy + execution. Open to feedback on my answer - understand its not the most perfect! Question: How would I launch a digital library product as a Google PM Clarifications: Standalone product? : standalone Region specific: No (up to me) Goa"See full answer