Real questions from top companies
How would you implement custom alarms for data delays or job failures?
How would you incorporate data security and access control?
How would you model customer transaction data for both analytical and operational use cases?
How would you model hierarchical data in a relational database?
How would you monitor and reduce disk-based queries (disk spilling)?
IPv4 vs IPv6
Identify the top 5 customers with the highest purchases in the last quarter.
Identify who is a manager and who is not.
Implement a rate-limiter to control API requests per user.
Initiatives taken that benefited the company.
Instances of significant mistakes and their resolutions.
Integrating an API with a Database - Steps
Lakehouse vs. Warehouse
Libraries for Data Wrangling
Light Bulb Problem: Three switches outside a room control three bulbs inside. Determine which switch controls which bulb with minimal trials.
Mapper and Reducer design for solving Two-Sum
Match countries in a pairwise format
Missed Timelines - instance of missing delivery timelines and how you communicated and delivered
Monads in Scala - define with Option example
Name the tools and technologies you have worked with to date.
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.