Scribd
Upload
76 views4 pages

Snowflake Interview Questions

The document contains a list of advanced interview questions related to Snowflake, covering topics such as virtual warehouse sizing, cost optimization, data migration, and query performance. It also includes specific tasks like implementing Slowly Changing Dimensions (SCD) type 2 and handling data in AWS S3. The questions are designed to assess a candidate's technical knowledge and problem-solving skills in a Snowflake environment.

Uploaded by

varunsaxena149
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
76 views4 pages

Snowflake Interview Questions

The document contains a list of advanced interview questions related to Snowflake, covering topics such as virtual warehouse sizing, cost optimization, data migration, and query performance. It also includes specific tasks like implementing Slowly Changing Dimensions (SCD) type 2 and handling data in AWS S3. The questions are designed to assess a candidate's technical knowledge and problem-solving skills in a Snowflake environment.

Uploaded by

varunsaxena149
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Snowflake

Advance
Interview
Questions
SWIPE

VISHAL KAUSHAL
1- How would you choose the perfect size of
Virtual warehouse for your requirement ?

2- How can we Optimize the Storage &


Compute cost in Snowflake?

3- Suppose you have given a requirement to


migrate the Data from On prem to
Snowflake, What all check you will perform?

4- What is the difference between


Clustering vs Search Optimization Service ?

5- How will you optimize the query


performance?

6- Write a query to find out if this table is


being used in any View definition or not ?
7- How would you implement SCD type 2
in Snowflake?

8- My client is giving me files in date wise


folder in AWS S3 bucket, You need to
implement this COPY activity in such a
way that it should pick the file from
current date folder and load in Snowflake.

9- I have one Parquet file in AWS s3


bucket, Now create table for that file
without checking the Stage files.

10- How would you help your team to


identify the PII/ Sensitive data?
Thank
yo!
u !
Vishal kaushal

You might also like