Filter interviews by
Clear (1)
Snowflake Architecture is a cloud-based data warehousing platform that separates storage and compute for increased scalability and performance.
Snowflake uses a unique architecture with three layers: storage, compute, and services.
Data is stored in Amazon S3 or Microsoft Azure Blob Storage, separate from the compute resources.
Compute resources can be scaled up or down independently of storage, allowing for flexibility a...
Multi-clustering is a feature in Snowflake that allows data to be stored in multiple clusters for improved performance and scalability.
Improves query performance by distributing data across multiple clusters
Increases scalability by allowing more resources to be added as needed
Helps in workload isolation and resource management
Example: Storing customer data in one cluster and product data in another for better performan
Use regular expressions to extract numeric values from an alphanumeric string.
Use regular expression pattern '\d+' to match one or more numeric digits in the string.
Apply the regular expression pattern to the alphanumeric string to extract only the numeric values.
For example, if the input string is 'abc123def456', the output should be ['123', '456'].
Use a subquery to get the 3rd highest value from a table
Use a subquery to select distinct values from the table
Order the distinct values in descending order
Use LIMIT and OFFSET to get the 3rd highest value
Top trending discussions
I applied via Referral and was interviewed before Apr 2021. There were 2 interview rounds.
Puzzles, Psychometric Test
based on 2 interviews
Interview experience
based on 1 review
Rating in categories
Technical Lead
3.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
3.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
2.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Lead Engineer
2.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Analyst
2k
salaries
| ₹0 L/yr - ₹0 L/yr |
HCLTech
TCS
Tata Group
Wipro