1- What is Snowflake & How it is different than On prem Data warehouses?
2- Explain the Snowflake Architecture or How Snowflake Compute & Storage separate
Architecture help us?
3- What are the type of caching available in Snowflake, How would you identify if
your query is returning result from Query Cache/ Metadata cache or VW cache?
4- What are common types of Tables we have in Snowflake?
5- Can you explain, when would you prefer Transient tables over Permanent Table in
Snowflake?
6-How does Snowflake handle data storage & Processing?
7-What is Snowflake Stages & When would you use which Stage?
8- Why Cloning in Snowflake known as Zero copy clone?
9- What is Time Travel and How it works under the hood?
10- What is the role of virtual warehouses in Snowflake, and how do they affect
performance
11- What are the limitation of Materialized views we have in Snowflake?
12- Can you explain the Query Execution flow in Snowflake?
13- What is Scale up vs Scale out in Snowflake?
14- How Snowflake processes queries using micro-partitions.
15- What are the size range of Micro Partition in Snowflake?
--------------------------------------------------------------------
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 , Where
you will use SOS over Clustering?
5- How do you troubleshoot and optimize the slow running queries in Snowflake?
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 do you Integrate S3,ADLS or GCS with Snowflake? If i integrate AWS S3 with
Access keys then will you face any challenges?
--------------------------------------------------------
What are streams in Snowflake, Also explain the type of streams.
2- If I have created stream on one table and now if someone else has consumed that
stream then i wont be able to see those DML changes, How would you implement this
scenario where anyone can see those changes.
3- What is Slowly changing dimension & How would you implement SCD type 1 & 2 in
Snowflake?
4- What is INCLUDE_METADATA property in COPY INTO command & what should be the
prerequisite to use this parameter?
5- What will be the Storage cost associated with Streams in Snowflake? Also What is
the maximum Stale period we can set for any Stream.
6- What is the difference between Resource Monitor and Budgets?
None
7- How would you find out the base table used to create all views in particular
schema? or In other words How would you find all dependent child objects.
8- How would you handle schema evolution in Snowflake?
9- How does Snowflake handle the concept of "data sharing" between different
accounts, and what are the security considerations?
10- How would you implement data encryption in Snowflake, and what types of
encryption does Snowflake support?
11- What is the difference between "Cloning" and "Copying" data in Snowflake?
12-What is the role of "Data Pruning" in Snowflake, and how does it improve query
performance?
13- You fire one statement, which took long to time complete when you open query
profiler, you found lot of data is spillage to remote disk , what may have caused
this and how would you fix this?
14-What are the some data types which Snowflake does not support?
15- What all metadata columns we have for any Named Stages?
-----------------------------------------------------------
