Interview Questions

Praveena P. - "I have been with Cisco, I am trying to move into a technical project manager role so that I will not loose the touch of latest technologies and also that aligns my passion."See full answer

Tej prakash V. - "DNS is a service for resolving hostname and provide fully qualified domain name of the host."See full answer

Ankit P. - "SELECT order_amount FROM (SELECT o.order_amount, DENSERANK() OVER (ORDER BY o.orderamount DESC) as rnk FROM orders o JOIN departments d ON d.departmentid = o.departmentid WHERE d.department_name = 'Fashion' ) WHERE rnk = 2"See full answer

Shanti informatics - "Goals; Customer engagement/ acquisition; Persona: 60-70; User journey: Selecting the right flight → Adding details → Selecting the best coupon for payment; Web-Check in; At the airport: Luggage check-in; Boarding; Flight Travel; Arrival: Collecting the luggage from belt; I would be focusing on the first two steps: Selecting right flight + and web check-in → That seems the most challenging aspect an elderly; Pain Points/ Challenges: Selecting the right flight (Duration/ Pric"See full answer

Harshi B. - "SELECT DISTINCT title, ROUND(AVG(rating) over (partition by title),1) avg_rating, ROUND(AVG(rating) over (partition by genre),1) genre_rating FROM rating r JOIN movie m ON r.movieid=m.movieid ORDER by 1"See full answer

Mohit C. - "-- LTV = Sum of all purchases made by that user -- order the results by desc on LTV select u.user_id, sum(a.purchase_value) as LTV from user_sessions u join attribution a on u.sessionid = a.sessionid group by u.user_id order by sum(a.purchase_value) desc"See full answer

Exponent - "This question is a Diagnosis Question. It's used to test your ability to perform root cause analysis (RCA), identify many possible issues, come up with a theory of probable cause, and address how you would solve this issue. A drop in video engagement can signify either a technical issue (the video player is broken) or a product issue (recommendations performing poorly). Let's follow the template for answering Diagnosis Questions: Ask clarifying questions **List potential high level"See full answer

P D. - "Elderly Users Preventive Health checkups Alerting families and relatives in Emergency situations Easily calling relatives / friends - AR experience Reliving the past experiences Guiding them in case of crossing the road Making shopping easier for them by understanding their mood and ordering for them helping in deciding the song playlist based on emotions Kids Exercising and noticing the effort spent Fun based learning Help in social interactions Help parents understand"See full answer

Raja raghudeep E. - "There can be multiple effects on adjusting the context window of LLM, some I can think of are below: If window size is large then more tokens are in context which could increase memory and compute costs because of O(n2) attention complexity. Larger window can help in better responses in multi turn conversations but attention dilution can also happen."See full answer

Jenny L. - "I would target any demographic where their natural sense of "smell" is diminished or no longer available (consumer). I would also target commercial market opportunities in the food and cosmetics (specifically fragrance)."See full answer

Exponent - "This is a Technical question. It tests your ability to understand high level technical concepts. Even though your job won't have any coding involved, you'll still need to understand these concepts. Being able to cover all these topics with clarity communicates confidence in your interviewer. Unfortunately, there's no formula for technical questions, but some general tips are: Use analogies when you can Break your solution into clear, bite-size steps Don't be afraid to use examples to b"See full answer

Scott S. - "As a Data Engineer working in the derivatives domain, my role involves managing and optimizing data pipelines, ensuring data quality, and supporting data analytics for trading strategies. The fast-paced nature of the trading environment requires both proactive and reactive data management practices. Task: My daily tasks are focused on maintaining the integrity and availability of data, developing new data pipelines to support evolving trading strategies, and collaborating with both data scienti"See full answer