1 of 87
Term
Which of the following correctly describe Snowpipe?
Give this one a try later!
Snowpipe is used to load a
Snowpipe is a method for exporting small volume of data that
data to external systems arrives frequently and
continuously
, Snowpipe is a tool for archiving Snowpipe is a feature for managing
large datasets user permissions
Don't know?
2 of 87
Term
Which of the following Snowflake edition doesn't support Snowflake
Marketplace?
Give this one a try later!
PBI FWA
VPS RSW
Don't know?
3 of 87
Term
True/False: Snowflake customers can control the format using which
Snowflake stores the data for a table.
Give this one a try later!
, True False
Don't know?
4 of 87
Term
Which of the following criteria must be met for Snowflake to reuse
the query result cache for a query?
Give this one a try later!
, - The table micro-partitions have NOT altered as a result of reclustering or
consolidation.
- The query does not make use of runtime functions.
- The underlying data that contributes to the query results has remained
unchanged.
- The query makes no use of user-defined or external functions.
- A new query matches an old query.
- Snowflake rekeys encrypted data after 1 year
- Every 30 days, Snowflake rotates the keys used for encryption
- Snowflake manages encryption keys by default
- The query processing layer can run multiple compute clusters (virtual
warehouses) simultaneously
- The query processing layer is responsible for executing queries
- A Snowflake service that is invisible to users automatically maintains
materialized views in the background.
- Materialized views are used to boost query performance. They pre-compute
query results and physically store them
- A materialized view can provide pre-computed answers, enabling some
queries to be answered faster.
Don't know?
5 of 87
Term
Which one of the following is supported by Snowflake for the
purpose of auto-provisioning users and group membership?
Give this one a try later!
Term
Which of the following correctly describe Snowpipe?
Give this one a try later!
Snowpipe is used to load a
Snowpipe is a method for exporting small volume of data that
data to external systems arrives frequently and
continuously
, Snowpipe is a tool for archiving Snowpipe is a feature for managing
large datasets user permissions
Don't know?
2 of 87
Term
Which of the following Snowflake edition doesn't support Snowflake
Marketplace?
Give this one a try later!
PBI FWA
VPS RSW
Don't know?
3 of 87
Term
True/False: Snowflake customers can control the format using which
Snowflake stores the data for a table.
Give this one a try later!
, True False
Don't know?
4 of 87
Term
Which of the following criteria must be met for Snowflake to reuse
the query result cache for a query?
Give this one a try later!
, - The table micro-partitions have NOT altered as a result of reclustering or
consolidation.
- The query does not make use of runtime functions.
- The underlying data that contributes to the query results has remained
unchanged.
- The query makes no use of user-defined or external functions.
- A new query matches an old query.
- Snowflake rekeys encrypted data after 1 year
- Every 30 days, Snowflake rotates the keys used for encryption
- Snowflake manages encryption keys by default
- The query processing layer can run multiple compute clusters (virtual
warehouses) simultaneously
- The query processing layer is responsible for executing queries
- A Snowflake service that is invisible to users automatically maintains
materialized views in the background.
- Materialized views are used to boost query performance. They pre-compute
query results and physically store them
- A materialized view can provide pre-computed answers, enabling some
queries to be answered faster.
Don't know?
5 of 87
Term
Which one of the following is supported by Snowflake for the
purpose of auto-provisioning users and group membership?
Give this one a try later!
