Real questions from top companies in General/Other · medium
How would you read data from a web API? What steps would you follow after reading the data?
What is the difference between SQL and NoSQL databases?
APPLY Operator - CROSS APPLY and OUTER APPLY
An existing job running longer suddenly: how to analyze the issue?
Calculate a 7-day moving average of clicks for each user_id
Calculate a 7-day moving average of orders for each city in the Swiggy database.
Calculate cumulative sales for each product in each store, ordered by sale_date
Calculate the total number of transactions (units sold) for each product.
Calculate the total sales amount for customers born between 1998-01-15 and 2000-01-15.
Compute the moving average of daily transactions over a 7-day window.
Data Shuffling Causes and Techniques
Describe a time when you had to deal with a major data quality issue. How did you handle it?
Describe the concept of data sharding and when to use it.
Describe your approach to managing data deduplication.
Discuss Primary, Foreign, and Composite Keys.
Discuss the average data volume handled and strategies used for efficient processing.
Explain how you would implement a caching mechanism for frequently accessed video metadata.
Extract insights from given JSON data using your preferred framework.
Fetch the rows with the highest scores for each student in a year.
Find All Numbers that Appear at Least Three Times Consecutively
Type or paste your answer to any of these questions and our AI Coach scores it, highlights gaps, and rewrites it at FAANG quality. Free to try.