TCS Snowflake Developer Interview Questions, Process, and Tips

Q1. Snowflake architecture, snowpipe, zero copy clone
Add your answer

Good questions with detailed interview

Q1. Explain Snowflake architecture
Ans. 
Snowflake architecture is a cloud-based data warehousing platform that separates storage and compute resources for scalability and performance.
• Snowflake uses a unique architecture with separate storage and compute layers.

• Data is stored in scalable and durable storage, while compute resources can be scaled independently for processing.

• Snowflake's architecture allows for automatic scaling, high performance, and concurren...read more
Answered by AI
Add your answer
Q2. Contains 3 layers
Add your answer

Q1. What is varient data type
Ans. 
Variant data type is a flexible data type in Snowflake that can store semi-structured and nested data.
• Variant data type can store JSON, Avro, ORC, and Parquet data formats.

• It allows for querying and manipulating semi-structured data without the need for schema changes.

• Example: A variant column can store a JSON object with nested arrays and objects.
Answered by AI
View 1 more answer
Q2. Difference between union and join
Ans. 
Union combines rows from two or more tables, while join combines columns from two or more tables.
• Union appends the rows of one table to another, while join combines columns of two tables based on a common column.

• Union does not require a common column, while join requires a common column to match the rows.

• Union removes duplicates, while join retains duplicates.

• Union can be used to combine tables with different columns, ...read more
Answered by AI
Add your answer
Q3. Explain snowflake architecture
Ans. 
Snowflake architecture is a cloud-based data warehousing solution that separates storage, compute, and services.
• Snowflake uses a unique multi-cluster, shared data architecture.

• It separates storage, compute, and services, allowing for independent scaling.

• Data is stored in a columnar format, allowing for efficient querying and analysis.

• Snowflake also offers automatic scaling and concurrency control.

• It supports multiple c...read more
Answered by AI
Add your answer
Q4. In bulk loading what is the size data gets loaded
Ans. 
The size of data loaded in bulk loading varies based on the file format and compression used.
• The size of data loaded can range from a few MBs to several GBs.

• The file format used can impact the size of data loaded.

• Compression can reduce the size of data loaded.

• Snowflake supports various file formats like CSV, JSON, Parquet, etc.

• Examples: A CSV file of 1 GB can be loaded in a few minutes.

• A compressed Parquet file of 10 G
Answered by AI
Add your answer
Q5. While creating a custom role which role should have the access to it
Ans. 
The role with the highest level of access should create the custom role.
• The role with the highest level of access should have the ability to manage roles and grant permissions.

• This ensures that the custom role is created with the appropriate level of access and permissions.

• For example, if the custom role is for a specific department, the department manager role should create it.
Answered by AI
Add your answer