Interview Questions

Arvind R. - "Goal: Increase adoption of HPC capabilities offered by Google within enterprise customer context Vision: Accelerate high computing needs of enterprise, driven by innovation and definitive business outcomes Does this align with Google's vision - YES Trend Analysis: Technology: a. Introduce Intraday liquidity calculations b. Improve fraud detection using much large volume of data c. Faster value added risk calculations. d. Graph analysis for entity linking for large volume of customer a"See full answer

Nayeem A. - "Talk about how the solution is gonna improve the problem presented and I believe showing success in steps instead of one huge leap. So I would present m current progress and would provide a road map for completion."See full answer

Ina K. - "HashMap supports insert, search, delete and retrieve in O(1). It stores data as key value pairs."See full answer

Ivan B. - "At Facebook, you notice a sudden spark in DAUs in Indonesia — how would you determine the cause of this? I'd like to clarify a few things before starting to brainstorm root causes to hopefully narrow down the number of possibilities if you don't mind? - Not at all, please go ahead... Over what time frame has this spark occurred? - DAU's have sparked over the past 3 weeks. Thank you! Next, what are we qualifying DAU as? Is it simply just a user opening the app at least once during the"See full answer

Reshma R. - "Solution: World population = 8B Assuming 10% of world population does not use detergent( using only soap or using only water) Remaining population = 90/100 * 8B = 7.2B ~ 7B Diving the users into 3 categories Users who wash everyday Users who wash twice a week Users who wash once a week Wash everyday --- Wash twice a week --- Wash once a week Used clothes < Used clothes < Used clothes 5gm --- 10gm --- 15gm (Detergent used"See full answer

D S. - "Clarification Question: First I would like to clarify my understanding of AirBnB. AirBnB is an online marketplace that lets people rent out their properties or spare rooms to guests. Airbnb takes 3% commission from hosts and around 6 to 12% from guests. Now, I believe payment collection experience is related to the host so they can visualize everything around their payments. Reason for designing this experience - to provide a better collection experience for hosts Marke"See full answer

Shivam S. - "We utilized AI and ML to improve the product’s accuracy and performance and to generate insights from customer data. We also leveraged the cloud to store and manage customer data securely. Additionally, we implemented smart assistants to automate customer support and help customers quickly resolve inquiries."See full answer

Sangeeta P. - "Since I am residing in Bangalore, I will consider the Bengaluru airport. The airport has 2 terminals. I am going to consider the security scan done at both the terminals for the estimation. Does it include security scans for both international and domestic flights? --> Both The airport crew members and pilots also go through the security scan. So, should I include only them as well or only the passengers in my calculation? --> Only the passengers Number of people going through the security scan"See full answer

Joohi M. - "Assume that US and Japan are exactly opposite to each other. If a flight takes 18 hrs to travel between US and Japan and it moves at approx 600km/hr, then the distance covered is 10,800 Km. This constitutes the semi arc of the circle, so we will double is to calculate full circumference which will be 21,600 km."See full answer

Derrick M. - "SELECT COUNT(DISTINCT o.customerid) AS customers, d.departmentname FROM orders o INNER JOIN departments d ON d.departmentid = o.departmentid WHERE d.departmentname IN ('Electronics','Fashion') AND o.orderdate BETWEEN '2022-01-01' AND '2022-12-31' GROUP BY d.department_name; `"See full answer

Sid S. - "Clarifying questions: What are the needs of the user ? What kind of changes were made that is expected to sync? Can you describe the calendar app for me? Is it a mobile app or web? To better understand the UI for solutioning Can we define "recently" - Is it in mins or days? Do we know the reasons for the sync issue yet? Can we supposed to expose the issue to the front end? Define the basic user story structure User personaAction expected Job to be achieved Would brea"See full answer

Jayveer S. - "SELECT p1.player_name AS player1, p2.player_name AS player2, ABS(p1.level - p2.level) AS level_disparity FROM players p1 JOIN players p2 ON p1.playername < p2.playername WHERE ABS(p1.level - p2.level) <= 5 ORDER BY level_disparity ASC;"See full answer

Aishwarya R. - "Need for this feature : A user who has to reach somewhere on time - probably someone commuting to the airport would use this feature. I would pilot this feature in a city where there is a high volume of users using uber to commute to the airport, as well as a high volume of drivers, so that we deliver on what we promise. There are 2 side to this - the end user side, and the driver side. To measure the success of this application, primarily, I would track the number of users who are booking sched"See full answer