Interview Questions

A K. - "Goal of Google: Clarify: What exactly is Google podcast? A place for people who create podcasts to host their podcast? Great with that in mind.... Google's mission is to organize the world's information and make it universally accessible and useful Goal: From a podcast perspective, you can imagine that Google’s wants to organize the world's information and make it universally accessible and useful through a podcast. Actions: Two-sided user base: People who listen"See full answer

Swaroop M. - "Formulate a draft format of idea, open to feedback, communicate your progress"See full answer

Priyal S. - "Clarifying questions: By no online presence, do you mean just no website for order or do you mean no searches showing up on Google/Bing as users are looking for supermarkets. Possibilities of declining revenue: For every product, i.e pantry, vegetables and fruits, are our prices much higher than our competitors? Are our competitors getting products from suppliers at a lower rate? Are we exhausting our economies of scale well? What % of people are shopping online for groceries? Are"See full answer

Aneesha K. - "Test case is wrong. It expects to sort in asc order of month_year. -- Write your query here SELECT strftime('%Y-%m', createdat) AS monthyear, COUNT(DISTINCT userid) AS numcustomers, COUNT(t.id) AS num_orders, SUM(price * quantity) AS order_amt FROM transactions t INNER JOIN products p ON t.product_id = p.id GROUP BY month_year ORDER BY month_year ; "See full answer

Anonymous Tortoise - "SELECT i.item_category, o.order_date, SUM(o.orderquantity) AS totalunits_ordered FROM orders o JOIN items i ON o.itemid = i.itemid WHERE o.order_date >= DATE('now', '-6 days') GROUP BY i.item_category, o.order_date ORDER BY i.item_category ASC, o.order_date ASC;"See full answer

Graig - "Reflect leadership quality in software engineering team"See full answer

Saket S. - "Project Schedule is a living document which is prepared based on inputs from the entire team including product, engineering, finance, sales, marketing, legal etc. It is owned by Project/Program Manager but it reflects progress of the whole team. Inputs required for the development of schedule includes project charter, list of stakeholders, project scope, WBS, freeze calendar, vendor SOWs etc. I will use the following approach for schedule development: Copy Milestone level plan from Project"See full answer

Arshad P. - "Schema is wrong - id from product is mapped to id from transactions, id from product should point to product_id in transcations table"See full answer

Varun - "Clarify question and state assumptions: Streetview from my understanding is compiled by a streetview car going out and taking multiple photos and then Google stitches this together to give us streetview. I'm only going to look at the streetview outdoor experience, I know for e.g Google also has full views of some businesses, malls, museums etc so for the purposes of this I'm not going to calculate this. For the purposes of this is it OK if we say how much storage required to store streetview"See full answer

Bhaskar B. - "This could be done using two-pointer approach assuming array is sorted: left and right pointers. We need track two sums (left and right) as we move pointers. For moving pointers we will move left to right by 1 (increment) when right sum is greater. We will move right pointer to left by 1 (decrement) when left sum is greater. at some point we will either get the sum same and that's when we exit from the loop. 0-left will be one array and right-(n-1) will be another array. We are not going to mo"See full answer

Anonymous Reindeer - "Clarifying Questions: Is it a chain of supermarkets? Or just an individual market? Is the revenue overall or just from one store? What are the reasons for the revenue growth? Pandemic? New buildings around? Other? What does the supermarket sell? Anything specialized? Local goods? Is there an app/website available to order stuff? 10,000 - 50,000 Vision: Be the most customer centric store Goals: Able to reach out to as many users as they can. Increase the user base while keeping th"See full answer

Anonymous Armadillo - "I couldn't follow the solution offered here, but my solution seemed to pass 6/6 tests. Any feedback is welcome, thank you! def encrypt(word): en_word = "" for i in range(len(word)): if i == 0: en_word += chr(ord(word[0])+1) else: num = ord(word[i]) + ord(en_word[i-1]) while num > 122: num -= 26 en_word += chr(num) return en_word def decrypt(word): de_word = "" for i in range(len(word)): if i == 0: de_word += chr(ord(word[i]"See full answer