Real questions from top companies · medium
Lambda vs. Glue: Discuss use cases for both services.
What alternatives to Kinesis would you consider for real-time data ingestion?
Calculate the total number of transactions (units sold) for each product.
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 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?
How would you implement custom alarms for data delays or job failures?
Reverse operation for splitting values back to original format
Shell commands for renaming a file?
Create a Python program to demonstrate the use of set operations (union, intersection).
GeoPandas - definition and features
Implement an algorithm to find the longest common prefix among an array of strings.
List customers with more than 5 orders.
List every combination of dept_name, employee_name, and city such that the employee belongs to the department and the same city in which the department is located.
Reverse a string with special characters preserved.
Compare Airflow's @daily vs once trigger scheduling.
Compare OLTP and OLAP systems in the context of financial transactions.
Compare PostgreSQL vs Snowflake. How do they handle duplicate record errors?
Compare the star schema and snowflake schema. Which one would you use for reporting at Swiggy, and why?
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.