Interview Questions

Abbas M. - "`select employeeid, employeename, sum(maxscore) totalscore from ( select e.id employeeid, e.name employeename, tr.testid , max(tr.score) maxscore from employees e join test_results tr on e.id = tr.employee_id group by tr.employeeid, tr.testid order by 1 ) group by 1,2 order by 3 desc` `"See full answer

Anonymous Flamingo - "Handling projects out of my expertise: When faced with a project that falls outside of my expertise, I take the following steps: Identify my skills and knowledge gaps: I assess my own strengths and limitations, and determine which areas of the project may be outside of my comfort zone or expertise. Seek guidance and mentorship: I reach out to colleagues or subject matter experts who have relevant knowledge or experience, and ask for their advice and guidance on the project. Learn and adapt"See full answer

Pramod S. - "Engineering Managers (EMs) juggle multiple responsibilities, which can vary significantly depending on the company, team, and organizational needs. One of the most critical skills for an EM is strategic thinking. This includes setting a clear vision for the team, participating in roadmap planning meetings, and crafting actionable roadmaps to guide the team toward its goals. In addition to strategic thinking, an EM must excel in three key areas: People Management: This involves ensuring te"See full answer

Anonymous Muskox - "User Persona Individual heavy Users Casual users Enterprise Users Occasional Users I would like to think more about the Enterprise users, because they are the power users and the maximum revenue of the Google may come up with the enterprise solutions. It is my hypothesis that despite of improvement of the Google drive, common individual users are highly unlikely to use the premium version of the G Suite User Journey of the person using Google Drive Want to work on the new document"See full answer

Esha - "Clarifying Questions What do we mean by ‘improve’? Is there a certain goal that we are trying to attain? Is there a target user that we are going for? Any constraints or things to keep in mind when building this? Assumptions Only focused on google docs and not collaboration on other G-suite products such as PPT or sheets What is Google Docs? Web-based productivity tool that allows you to access your files from any computer through your gmail account. You can also share and"See full answer

Anonymous Unicorn - "Count items between indices within compartments compartments are delineated by by: '|' items are identified by: '*' input_inventory = "*||||" inputstartidxs = [1, 4, 6] inputendidxs = [9, 5, 8] expected_output = [3, 0, 1] Explanation: "*||||" 0123456789... indices ++ + # within compartments ^ start_idx = 1 ^ end_idx = 9 -- - # within idxs but not within compartments "*||||" 0123456789... indices "See full answer

Rahul J. - "Assumptions: User type: school children living in the USA. Form factor: mobile app on iOS and Android Problem statement School children all across the country visit museums 2-4 times in a year. The museums have info on the contents and layout but that is static. Key value proposition of product is to guide users through the museum Internal company assessment Let's assume the interview is at Google. Google's mission is to organise the world's information so this problem aligns with"See full answer

Valentin B. - "Let me first ask some clarification questions / make assumptions: Any specific geographic region? => USA How do we measure bandwith? a. Bandwith is the maximum internet speed required for our google maps servers to support all google maps traffic in the USA. At which point do we measure bandwith? => at the “entrance” of each google server center Do we talk about maximum bandwith required? a. Yes, the maximum BB required to support google maps in the USA (on side of Google) Outline: O"See full answer

Aruna D. - "Assumption #1: the deal is signed and the customer now will being the process of moving to GCP Assumption #2 : the deal includes Iaas as well as Paas (App Engine) - moving apps from on prem to cloud Objective : Design a product that will help the customer onboard and successfully plan the move to GCP. Customer is using on premise and is new to cloud. Lets assume the tool should include the roadmap planning too ie decisions such as moving all vs some applications etc . As in any onboarding to"See full answer

Batman X. - "def friend_distance(friends, userA, userB): step = 0 total_neighs = set() llen = len(total_neighs) total_neighs.add(userB) while len(total_neighs)!=llen: s = set() step += 1 llen = len(total_neighs) for el in total_neighs: nes = neighbours(friends, userA, el) if userA in nes: return step for p in nes: s.add(p) for el in s: total_neighs.add(el) return -1 def neighbours(A,n1, n2): out = set() for i in range(len(A[n2])): if An2: out.add(i) return out"See full answer

Jaswanth P. - "Proposed Solution: Awareness and Control Features Algorithm Awareness Campaign Educational Content: Create short videos explaining how the algorithm works to enhance user experience. Transparency Reports: Regular updates on algorithm changes to keep users informed. User-Controlled Engagement Settings Customizable Feed Options: Allow users to adjust content preferences and limit certain types of videos. Time Management Tools: Introduce reminders for screen time limits an"See full answer

Anonymous Flamingo - "As a product manager, my first step in designing a free product would be to define the product's target audience and the problem it aims to solve. Once these factors are established, I can then determine the best way to monetize the product. One way to monetize a free product is through advertising. This involves displaying ads to users as they use the product, and earning revenue based on the number of clicks or impressions the ads receive. This model is commonly used by social media platforms,"See full answer

Maria T. - "Clarifying questions: Will it be a separate app of Google maps or integrated into an existing one? Let's say it will be integrated into an existing app. Which disabilities users have? Any of your choice. For which audience are we building this product? Any exact geo, age, gender? Any of your choice. How many resources we have? Any timeline for the product to be launched? Need to launch a product in a year and any resources required. Google's mission is to organize the world's"See full answer

Zacharias E. - "SELECT pro.id, pro.title, pro.budget, COUNT(employeeid) AS numemployees, SUM(e.salary) as total_salaries FROM projects pro JOIN employeesprojects ep ON ep.projectid = pro.id JOIN employees e ON e.id = ep.employee_id GROUP BY project_id; `"See full answer

Dinesh K. - "i dont know"See full answer

Pranav M. - "Statement: Improve the music experience at youtube Is the goal to improve the experience for any particular kind of user/music genre? Ans: No, nothing in particular Goal: I’m going to assume the goal is to improve the experience of listening to music generally Google’s mission is to organise the world’s information. Youtube is a platform that lets people discover videos, interesting content as tailored to their interests, thus serving Google’s mission Music on Youtube also contributes to"See full answer

Divya R. - "public static Integer[] findLargest(int[] input, int m) { if(input==null || input.length==0) return null; PriorityQueue minHeap=new PriorityQueue(); for(int i:input) { if(minHeap.size()(int)top){ minHeap.poll(); minHeap.add(i); } } } Integer[] res=minHeap.toArray(new Integer[0]); Arrays.sort(res); return res; }"See full answer