Snowflake Knowledge check Quiz

A UDF can return a singular scalar value OR if defined a UDTF can return a set of rows?

Snowpipe partially loaded files (based on ON_ERROR) can be combined/split into more transactions?

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

A Stored Procedure can only run as the owner and not the caller?

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

Users must manually refresh a Materialised View to keep it's data upto date?

How many days extra protection does FailSafe provide?

When loading files from a local filesystem using PUT the local host must have which of the below?

Scaling Out a Multi Cluster Warehouse support which options?

Pipes do not support semi structured data?

Which of the following Semi Structured formats does Snowflake support?

Which of the below are table types in Snowflake?

What determines the maximum file size for data unloads out of Snowflake?

Semi-Structured data has support for all SQL operations?

A secure view allows access to tables which are owned by the accountadmin role?

Why would we CAST data from a Variant?

Micro Partitions are created based on ingestion order of data within files to be loaded?

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?