Part 1: Basic Concepts and Architecture

1. What is a stream in Snowflake, and what are the columns present in a stream?
2. What is the architecture of Snowflake?
3. What is a Snowpipe in the context of Snowflake?
4. Can you explain the concept of a warehouse in Snowflake?
5. What is the data flow, and how many layers are in our projects?
6. How do you convert JSON to the Snowflake VARIANT data type?
7. How are task dependencies managed in Snowflake?
8. Is there a specific table for maintaining notification history in Snowflake?
9. What are alternative methods for loading data into Snowflake without using JSON functions?
10. How can you set up error notifications in Snowflake?

Part 2: Data Management and ETL Processes

1. Could you explain the process of data sharing in Snowflake?
2. Explain the relationship between AWS and SF.
3. How do you move 100 GB of data into SF? Describe the steps you would follow.
4. Differentiate between a View and a Materialized View.
5. Explain the concept of a Merge statement in the context of a relational database.
6. What is the purpose of the pattern function in Snowflake?
7. Have you worked with Snowpipe? If so, describe your experience in creating and using Snowpipe.
8. How can you create a table in Oracle with a time/travel retention period to go back before 12 days?
9. What is the maximum size of a file that can be loaded into an S3 bucket?
10. What are the types of Slowly Changing Dimensions (SCD)?

Here, you can find Data Engineering Resources 👇
https://whatsapp.com/channel/0029Vaovs0ZKbYMKXvKRYi3C

All the best 👍👍