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?
Calculate a 7-day moving average of orders for each city in the Swiggy database.
Calculate the total number of transactions (units sold) for each product.
Data Shuffling Causes and Techniques
Describe the concept of data sharding and when to use it.
Fetch the rows with the highest scores for each student in a year.
Find All Numbers that Appear at Least Three Times Consecutively
Find the names of managers who have at least 7 employees directly reporting to them.
Find top 3 products sold based on total quantity.
Given the data with id, name, and department, how would you calculate how many employees are in each department?
How does cluster size impact parallelism limits?
How would you optimize a slow-running SQL query?
How would you implement custom alarms for data delays or job failures?
Reverse operation for splitting values back to original format
Shell commands for renaming a file?
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.