Horizontal scaling increases concurrency when we have to support additional users. We can utilize auto-scaling and raise the number of virtual warehouses to support and satisfy user queries immediately.
Vertical Scaling reduces processing When we have large workloads, and if we want to maximize it and make it run rapidly, we can explore selecting a large virtual warehouse size.
Posted Date:- 2021-10-07 05:50:02
Does Snowflake maintain stored procedures?
What are the different types of tables available in Snowflake?
How do we execute the Snowflake procedure?
How do we check the Snowflake history?
What is the purpose of the Storage Layer in Snowflake?
How many nodes exist in a big Snowflake warehouse?
What are the advantages of Snowflake Compression?
Differentiate Horizontal scaling and Vertical scaling
Explain about the different table Types available in Snowflake?
What is the database storage layer?
Explain data compression in Snowflake?
Explain zero-copy cloning in Snowflake?
Differentiate Star Schema and Snowflake Schema?
Explain Snowflake architecture
List of the different types of caching in Snowflake?
Briefly list the advantages of Snowflake compression?
What do you mean by a columnar database, and what is the advantage of using it?
What is zero copy cloning in Snowflake ?
What is the responsibility of the compute layer in Snowflake?
What is Auto-scaling in Snowflake?
What is the use of SQL in Snowflake?
What is Materialized view in Snowflake?
What are micro partitions in Snowflake?
What are the programming languages supported by Snowflake?
What are the benefits of using Snowpipe:
What is Snowpipe in Snowflake?
What are the different Connectors and Drivers available in Snowflake?
What do you know about zero-copy cloning in Snowflake?
What are the data sharing types in Snowflake?
What is the Data retention period in Snowflake?
Does Snowflake maintain stored procedures?
How can we execute Snowflake Procedure?
What is a clustering key in Snowflake?
How to create temporary tables in Snowflake Cloud Data Warehouse?
What are the temporary tables in Snowflake Cloud Data Warehouse?
What is default table created in Snowflake?
What are the different ways to access the Snowflake Cloud Datawarehouse?