Snowflake Knowledge check Quiz

Dynamic partition pruning is based on the JOIN columns of a query?

Data Encryption uses a Hierarchical key model?

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

Which of the below are examples of Structured data?

Each increase in Warehouse size i.e. from Small to Medium or Medium to larges uses a Snowflake internal logarithmic algorithm to determine the number of clusters to add?

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

A Resource Monitor consists of which of the following properties?

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

Resource Monitor notifications are sent to all Account Administrators?

Business intelligence (BI) can be described by which of the below?

Which of the below system Roles by default can create a Data Share?

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

A UDF can return a set of rows (UDFT), but a stored procedure can't?

A consumer will use their own Warehouse's compute when accessing a Data Share

The bigger a Warehouse the larger the cache that Warehouse has to use?

We can use CIDR notation to specify a subnet range for a whitelisted network policy?

We should Organise data being loaded into logical paths like by date, to better aid co-locating that data in the same micro partition?

Which best describes the accountadmin Role?

What are the types of Caching available in Snowflake?

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?