#snowflake

Questions tagged snowflake · medium

All easy (20+)medium (20+)hard (30+)

Explain the differences between Data Warehouse, Data Lake, and Delta Lake

SQLmediumbigquerypartitionsnowflake0.5 min read

FractalKPMGMatrixMeesho

→

Can you explain the difference between OLTP and OLAP?

SQLmediumbigquerysnowflakesql0.4 min read

AccentureCognizantEPAMYash Technologies

→

When would you choose a Snowflake schema over a Star schema?

SQLmediumjoinsnowflake0.6 min read

Goldman SachsMicrosoftZS Associates

→

What is the difference between OLTP and OLAP?

SQLmedium

How would you monitor and reduce disk-based queries (disk spilling)?

System Design/Architecturemedium

Identify the top 5 customers with the highest purchases in the last quarter.

General/Othermedium

Grouping and aggregation functions?

Python/Codingmedium

Write a Python program to calculate total spending, identify top 5 users by spending, and find the most purchased product

Python/Codingmedium

Compare OLTP and OLAP systems in the context of financial transactions.

SQLmedium

Compare PostgreSQL vs Snowflake. How do they handle duplicate record errors?

SQLmedium

Compare the star schema and snowflake schema. Which one would you use for reporting at Swiggy, and why?

SQLmedium

+17 More Questions with Expert Answers

Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.

Unlock Full Access Try AI Coach Free

1 2 Next

Other Tags

#join #partition #python #spark #optimization #sql #window #airflow #etl #bigquery #lakehouse

#snowflake

Questions tagged snowflake · medium

All easy (20+)medium (20+)hard (30+)

Explain the differences between Data Warehouse, Data Lake, and Delta Lake

SQLmediumbigquerypartitionsnowflake0.5 min read

FractalKPMGMatrixMeesho

→

Can you explain the difference between OLTP and OLAP?

SQLmediumbigquerysnowflakesql0.4 min read

AccentureCognizantEPAMYash Technologies

→

When would you choose a Snowflake schema over a Star schema?

SQLmediumjoinsnowflake0.6 min read

Goldman SachsMicrosoftZS Associates

→

What is the difference between OLTP and OLAP?

SQLmedium

How would you monitor and reduce disk-based queries (disk spilling)?

System Design/Architecturemedium

Identify the top 5 customers with the highest purchases in the last quarter.

General/Othermedium

Grouping and aggregation functions?

Python/Codingmedium

Write a Python program to calculate total spending, identify top 5 users by spending, and find the most purchased product

Python/Codingmedium

Compare OLTP and OLAP systems in the context of financial transactions.

SQLmedium

Compare PostgreSQL vs Snowflake. How do they handle duplicate record errors?

SQLmedium

Compare the star schema and snowflake schema. Which one would you use for reporting at Swiggy, and why?

SQLmedium

+17 More Questions with Expert Answers

Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.

Unlock Full Access Try AI Coach Free

1 2 Next

Other Tags

#join #partition #python #spark #optimization #sql #window #airflow #etl #bigquery #lakehouse