Interview Questions

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

Freddie - "a) What metric should be focused on for improving customer value creation, and why? I may the metric is user engagement. We can dive into groups of users, and the newbies' actions will not be the same as the old hands. The engaging frequency and time must be defined and tracked because it shows whether users (as a workspace) are accustomed to Clickup or not. b) Share the potential feature points that can improve the above metric, explain your rationale for each and the expected"See full answer

Anjali M. - "Define Groups: Platform where users ( organizers and members) with shared interests can come together and express their thoughts and opinions. Meta's mission: To bring ppl closer together by giving them access to tools and technology. Groups Mission alignment: Gives Organizers and members to come closer together over shared interests and build community. Users : Organizers ( create a group-> invite people on the platform --> can accept or deny a member to the group --> Intera"See full answer

Techzen I. - "Implemented the Java code to find the largest island. It is similar to count the island. But in this we need to keep track of max island and compute its perimeter."See full answer

Jaim - "Whenever I find resistance to my idea, my general approach is to : Validate my idea Identify if it is a political reason or is it a valid engineering tech reason Assuming it is not political but it is resource/difference of opinions that are causing resistance. Then I would try to do a quick POC and show a value proposition for the idea to get the buy-in. One similar situation happened The situation was that stakeholders were promised a feature that would decrease their number of ticket"See full answer

Sneha D. - "Design a university voting app"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

Ben G. - "Ask Follow up Questions Is this for specific type of user or open? Do we have any past research that has been done? Do we have an idea of company and user goals? Do we have metrics of success? Are there any existing constraints? Why  |  5 min Why is this product or feature important? How does this product benefit customers? What business opportunities does it create? What is our hypothesis? What are our company goals? Who  |  3 min Who are the different types"See full answer

Anonymous Tapir - "After clarifying the question, answered in following way: Defined what is Google Map. Discussed its history and dominant #1 current market position Aligned with the Google's mission Listed few users segments and few features for roadmap and discussed technology advancements & need to continue to innovate and differentiate aggressively"See full answer

Srikanth A. - "Clarify - What is the product ? Autonomous driving capability Technology as a vehicle to drive man driver capability What is the current stage of project ? Technology is ready I will start by understanding the Goal, Intention behind this initiative as I am considering myself new PM joined this team and I have to come up with go to market strategy. Goal - More users to adopt and build trust with self driving car capability. Target user persona End user Businesses -Rideshare service -Food"See full answer

Arthur Y. - "Clarifying questions: Clarify what Facebook Lite is Assumed answer: It’s a slimmed down version of mobile FB app optimized for slower connections and uses less data than the primary mobile FB app by not offering features like videos and high resolution photos. It is only available on Android and primarily built by FB to the developing world can have access to FB. What is meant by “opens are down”? Assumed answer: The total amount of opens of the app on Android devices"See full answer

Aaron W. - "Clarification questions What is the purpose of connecting the DB? Do we expect high-volumes of traffic to hit the DB Do we have scalability or reliability concerns? Format Code -> DB Code -> Cache -> DB API -> Cache -> DB - APIs are built for a purpose and have a specified protocol (GET, POST, DELETE) to speak to the DB. APIs can also use a contract to retrieve information from a DB much faster than code. Load balanced APIs -> Cache -> DB **Aut"See full answer

Jaswanth P. - "I want to become a product manager because it allows me to leverage my UX and architectural design background while focusing on creating impactful digital products. My experience with design thinking has equipped me with a user-centered approach, essential for identifying and solving real problems.I’m excited about the opportunity to bridge user needs with business goals, overseeing a product from conception to launch. The iterative nature of digital products fascinates me, as it enables continu"See full answer

Exponent - "This type of question is a Technical problem. Although you will not need to actually code the feature, it's important to understand basic technical concepts. Being able to cover these concisely with clarity shows you're an effective communicator. Here, we'll go over the broad technical steps needed to implement a basic reactions feature on Facebook. Briefly, the steps required are the following: Migrate the database to support reactions Write API code to be able to react to a post, and"See full answer

Frank A. - "1) create the experimental and control groups. 2) Then calculate the proportion (mean) of the true conversion rates for both groups using the convert column which counts True as 1 and False as 0. This is their conversion rates 3) calculate the statistic of the two groups by subtracting the proportion and standardizing. 4) get the p-value and compare with 0.05. 5) conclude the difference is statistically significant if the p-value is less than 0.05 otherwise no statistical difference"See full answer