Snowflake Knowledge check Quiz

Which of the below Cloud Storage offering are supported by Snowflake?

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

There is no limit on the number of Data Shares a Provider can provision?

Table Stages are created automatically by the system?

Only Standard Views can be created as secure?

Semi-Structured data has support for all SQL operations?

The COPY INTO command supports transaction control whereas Snowpipe does not?

Most trial accounts start with 3 letters followed by 10  numbers?

Which of the below are types of Stage in Snowflake?

It is generally a good sign if we see data  'Spilling' to local disk?

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

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

Which role will add the 'Account' icon on the Classic WebUI ribbon?

Resource Monitor notifications are sent to all Account Administrators?

Use of the LIMIT clause can have a large positive impact on performance?

Trial accounts can be converted to paid accounts?

What format does Snowflake store its data?

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

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

Files uploaded to staging area using PUT are auto encrypted?