Real questions from top companies in General/Other
Have you worked on Data Warehousing projects?
How would you read data from a web API? What steps would you follow after reading the data?
Retrieve the most recent sale_timestamp for each product (Latest Transaction).
What is the difference between OLTP and OLAP?
What is the difference between SQL and NoSQL databases?
Calculate the total number of transactions (units sold) for each product.
Data Storage and Retrieval Optimization techniques
Data access strategy for clients
Deadlock: Definition and necessary conditions
Describe a project where you implemented a data quality framework.
Describe the ZS projects you worked on
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 orders exceeding $1,000 in the last 30 days.
Find the names of managers who have at least 7 employees directly reporting to them.
Given the data with id, name, and department, how would you calculate how many employees are in each department?
Highlight the tools and technologies you've used in your current project
How do you run one notebook in another notebook?
How do you secure API requests in this setup?
How would you implement custom alarms for data delays or job failures?
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.