Interview Questions

Anonymous Amphibian - "Personally i like the simple and user friendly interface of Adobe XD software. Which i have been using since last year and i am very comfortable with that. Nearly i didn't noticed any improvement in the software."See full answer

Anzhe M. - "Not my answer, but rather the details of this question. It should include the following functions: int insertNewCustomer(double revenue) -> returns a customer ID (assume auto-incremented & 0-based) int insertNewCustomer(double revenue, int referrerID) -> returns a customer ID (assume auto-incremented & 0-based) Set getLowestKCustomersByMinTotalRevenue(int k, double minTotalRevenue) -> returns customer IDs Note: The total revenue consists of the revenue that this customer bring"See full answer

Tyler V. - "This is a very interesting question. First, I would like to ask a few clarifying questions about the premise, as I am not a bird expert! (pause for polite chuckle.) For the purposes of this question, I am going to assume some priors about you mean when you say "survival" and "adaptation". If we are discussing these in the evolutionary sense, it's very difficult to understand the time scale and actual causality that would be needed to bring about any sort of assessment of how this one aspect of"See full answer

Eshaa D. - "Clarifying Question: When you say user growth do you have in mind new user acquisition or also talk about user retention/engagement? Assuming New User acquisition is the main referral goal I will pick this for my answer. Netflix is a subscription-based video-on-demand service, available globally on mobile, web or Living room TV, offering a high-quality viewing experience to satisfy consumers' digital entertainment desires. User groups: I think of Netflix's large user base across three lenses: "See full answer

Hmj V. - "Designed and framework to conduct risk and control assessment of applications that are prone to fraud risk and designed a target roadmap of overarching controls that further mitigates the risk. I explained how I took incharge of coming up with the framework for the assessment and held sessions. Role played with my team to think all the use cases possible and explained the accomplishments and takeaways."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

Bg - "My use of Pinterest is somewhat limited. Pinterest is a social network that enables users to save and share ideas in a visual manner. So whether you are interested in fashion, health, lifestyle, decor, sports, you can learn about those in a visual manner. Am I correct? Of course, Pinterest provides recommendations for people to follow, makes it easy to save images as pins, categorize into various topics. The source of revenue is advertisements. That’s my understanding. Is there anything else I"See full answer

Scott S. - "Situation Our data engineering team was growing rapidly, and we needed to establish a more structured management layer to support this growth. One of our senior engineers, Sarah, had consistently demonstrated leadership qualities and technical expertise. The team was working on a critical project to enhance our real-time analytics capabilities, and it became clear that we needed additional management support to ensure the project's success. Task My task was to evaluate Sarah’s potential"See full answer

Tiago R. - "function findRotations(nums) { if (nums.length 0 && nums[mid] > nums[mid-1]) { left = mid; } else { right = mid; } } return rig"See full answer

Derrick M. - "SELECT u.id as user_id, u.name, COUNT(t.product_id) AS orders FROM users u JOIN transactions t ON t.user_id = u.id JOIN products p ON p.id = t.product_id GROUP BY u.id, u.name ORDER BY orders DESC LIMIT 1 `"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

Srisha K. - "I answered taking Restaurant as a sub product area and built the strategy around that."See full answer

Kushagra manish -. - " a. The above scenario leads us to believe that the project ClickUp suffers from customer engagement. It also leads us to believe that ClickUp has trouble on-boarding non-traditional customers, since most of the current users already have a taste of conventional PM tools like JIRA, Monday and Asana. This would lead us to believe that the customers have trouble on-boarding themselves, or find it much more difficult to use this app in the day-to-day. Hence what would help is to focus on the DAU/MA"See full answer