DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies in General/Other

700+ Easy450+ Medium650+ Hard
All CategoriesBehavioralSpark/Big DataSQLPython/CodingSystem Design/ArchitectureCloud/ToolsGeneral/Othereasymediumhard
1

Calculate a 7-day moving average of clicks for each user_id

General/Othermedium
2

Calculate a 7-day moving average of orders for each city in the Swiggy database.

General/Othermedium
3

Calculate cumulative sales for each product in each store, ordered by sale_date

General/Othermedium
4

Calculate the average session duration per user for the Expedia website.

General/Othereasy
5

Calculate the total number of transactions (units sold) for each product.

General/Othermedium
6

Calculate the total sales amount for customers born between 1998-01-15 and 2000-01-15.

General/Othermedium
7

Can you describe a project you successfully accomplished? What did you do to achieve that success?

General/Othereasy
8

Can you describe the role of user groups in setting up these policies?

General/Othereasy

+20 More Questions with Expert Answers

Get the complete 1,800+ question library with detailed, expert-level answers covering SQL, Spark, System Design, Python, Cloud, and Behavioral topics.

Get PDF Bundle — from $21Try Free Sample
Previous1234...13Next