Snowflake Knowledge check Quiz

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

Using Snowpipe does not require a customer started virtual warehouse?

During a Data Unload which option can we specify so data is not split into separate files?

Which of these is not a database object in Snowflake?

Resource Monitor notifications are sent to all Account Administrators?

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

Which pipes are cloned with Zero Copy Cloning?

Data Shares can only be dropped once approved by a Consumer?

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

Customers can request a “Vanity” Account Logon URL?

When we Unload JSON data which of below are valid File Format Options?

Only a table can be created as transient?

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

Table Stages are created automatically by the system?

How many days maximum do Editions of Snowflake higher than STANDARD allow time travel to be set for

You can use SQL ID as the basis to set the time that Time Travel will use?

Charges at the Cloud Services layers are for compute that exceeds 10% of total computes costs for the account?

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

Snowflake has a grant that allows all 'Future' objects created in a schema to be granted privileges to a role Automatically?

Files uploaded to staging area using PUT are auto encrypted?