COF-R02 Practice Questions

:

https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internalstages-7121cc3cc9

Reference: https://dwgeek.com/type-of-snowflake-stages-how-to-create-and-use.html/#SnowflakeInternal-

Named-Stage

Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-datawarehousedoesnt-

separate-storage-and-compute-65d2dffd450f

Which Objects Can Be Cloned?

Data Containment Objects. Databases. Schemas. Tables. Streams.

Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

Query result cache is all about fetching the data from cloud services layer and saving the cost by not

running the virtual warehouse.

Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the

queue in order to get its chance of running on the warehouse. The query will quit after reaching this

limit. By default, the value of this parameter is 0 which mean the queries will wait indefinitely in the

waiting queue

https://community.snowflake.com/s/article/Warehouse-Concurrency-and-Statement-TimeoutParameters#:~:text=The%20parameter%20STATEMENT_QUEUED_TIMEOUT_IN_SECONDS%20sets%

20the,indefinitely%20in%20the%20waiting%20queue.