Real questions from top companies
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 Redshift, BigQuery, and Snowflake in terms of cost, performance, and scalability.
Compare the star schema and snowflake schema. Which one would you use for reporting at Swiggy, and why?
Connecting BigQuery with Linux
Consolidate hotel reviews and create a dashboard. Design a data model for the reviews.
Convert row-level records to column records.
Converting SCD0 to SCD3
Count occurrences of each character in a string
Count records for INNER JOIN and LEFT JOIN
Count the number of nulls in each column of a table.
Create Spark Session, read CSV, join, and write as table. Provide example code.
Create a SQL query to identify customers with purchases above a dynamic threshold.
Create data models for storing users, artists, and related data for music platform
Create partitioned table
Data Modeling and Airflow Scheduling - star schema, cron, backfill
Data Warehouse Design from scratch
Database vs Data Warehouse vs Data Mart vs Data Lake
Define cursors and stored procedures and their use cases.
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.