Real questions from top companies in General/Other
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 average session duration per user for the Expedia website.
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.
Can you describe a project you successfully accomplished? What did you do to achieve that success?
Can you describe the role of user groups in setting up these policies?
Can you elaborate on your Big Data project experience?
Can you share an example of a project you worked on that had a significant impact on your organization?
Combine records by name with concatenated course values
Command to Read JSON Data and Options
Compare batch processing and stream processing for financial data.
Compute the moving average of daily transactions over a 7-day window.
Count occurrences of a specific word in a file
Daily Data Volume - quantify
Data Security in BFSI - encryption, IAM, auditing
Data Shuffling Causes and Techniques
Data Storage and Retrieval Optimization techniques
Data access strategy for clients
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.