DataEngPrep.tech
QuestionsBlogStore
Get PDF Bundle

Interview Questions

Real questions from top companies in General/Other · medium

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

How would you read data from a web API? What steps would you follow after reading the data?

General/Othermediumetlpartition0.7 min read
AltimetrikInfosys
→
2

What is the difference between SQL and NoSQL databases?

General/Othermediumjoinsql0.7 min read
AareteDunnhumbyFragma Data Systems
→
3

APPLY Operator - CROSS APPLY and OUTER APPLY

General/Othermedium
4

An existing job running longer suddenly: how to analyze the issue?

General/Othermedium
5

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

General/Othermedium
6

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

General/Othermedium
7

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

General/Othermedium
8

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

General/Othermedium
9

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

General/Othermedium
10

Compute the moving average of daily transactions over a 7-day window.

General/Othermedium

+18 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
123Next