Snowflake Quiz 2

Which of the following two statements are correct about fail safe?

• Fail Safe is same as Time Travel

• Failsafe provides a non configurable 7- days period during which historical data is recoverable by Snowflake

• Failsafe provides a non configurable 90 days period during which historical data is recoverable by Snowflake

• Failsafe ensures historical data is protected in the event of the system failure or other catastrophic event like hardware failure or security breach

When a multi-cluster warehouse is suspended, which of the following Snowflake cache will be purged?

• Local Disk cache

• Metadata

• Result set cache

• All of the above

What is the name of the parameter which is used to control the query result cache use?

• USE_CACHED_RESULT

• USE_RESULT_CACHE

• RESULT_CACHE_USE

• RESULT_SET_CACHE_USE

What is a responsibility of Snowflake’s virtual warehouses?(Select all that apply)

• Infrastructure management

• Metadata management

• Query parsing and optimization

• Query execution

• All of the above

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

• Auto-resume applies only for the queries which use Result set cache

• The ability to auto-suspend a warehouse is only available in the Standard and Enterprise edition.

• SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

• A user cannot specify a default warehouse when using the ODBC driver.

• The default virtual warehouse size can be changed at any time.

Data is duplicated when a table is cloned.

• True

• false

Failover and Failback is a feature of which edition?

• Enterprise

• Standard

• Business Critical

• VPS

Which Snowflake feature is used for both querying and restoring data?

• Cluster keys

• Failsafe

• Time travel

• Replication

What happens to the Result Cache if the underlying data changes?

• It is archived for historical reference

• It is retained but marked as outdated

• It gets invalidated and the query is re-executed

• It shows error

Which statement is true about Zero-Copy Cloning in Snowflake?

• It creates a full copy of the data, including all history.

• It creates a metadata-only copy that refers to the original data.

• It duplicates the data to another region

• It encrypts the data during the cloning process.