Snowflake Knowledge check Quiz

Only a table has a encryption key not a micro partition?

Database Replication can be enabled for any existing permanent or transient database?

Defining a Clustering Key can override natural clustering on a table?

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

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

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

If the same query is re-run with no change in underlying data by a different user then the cached results from the previous query run are sent to that user so no Compute is used?

Which of below describes workloads Snowflake can handle best?

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

Which of the below describes the Search Optimisation Service?

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

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

Which of the below are examples of a call to a UDTF?

Tasks can't be triggered manually, only on a schedule?

File Encryption in Snowflake can use which of the below algorithms?

Storage is billed as uncompressed data?

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

Which function can assist with reading data from a Variant datatype with nested elements?

When loading files from a local filesystem using PUT the local host must have which of the below?

Time Travel can only be defined and used at the Database level?