Snowflake Knowledge check Quiz

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

Columnar data storage benefits from more efficient compression ratio's

Which of the below are examples of context functions?

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

Only Enterprise Edition and above can create a Data Share?

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

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

Storage is billed as uncompressed data?

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

External Stages are managed by the Customer?

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

We should always use ORDER BY clause in a subquery for the implicit performance gains?

Search Optimisation Services can help improve the performance of highly selective lookup queries?

The is a limit of 10 on the number of data shares a consumer can utilise?

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

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

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

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

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?