Snowflake Knowledge check Quiz

Using Snowpipe we can scale compute for different workloads manually whereas COPY INTO uses a serverless compute model which we have no control?

By default Snowflake blacklists all IP Addresses?

Using Snowpipe does not require a customer started virtual warehouse?

What is the maximum size of each micro partition (compressed data)?

Storage is billed as uncompressed data?

Static partition pruning is based on columns in the WHERE clause?

When using a 'Group by' clause try to group on something that has many distinct values?

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

Multi Factor Authentication can be used with which of the below?

Snowpipe requires keypair authentication using JWT?

Snowflake uses natural clustering to co-locate similar column value data ranges?

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

Which of the below are examples of offerings Technical Partners provide?

Automatic table Clustering can be Suspended and Resumed?

External Stages are managed by the Customer?

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

What are the 2 methods for checking a PIPE and getting records into a table?

Data Consumers would create an Outbound Share?

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

Which of the below could we use to describe a Stream?