Snowflake Knowledge check Quiz

/20
Created by Paul Sammy

Snowflake Quiz basic

SNOWDBA Knowledge Checker Test 1.0

20 Questions chosen at Random to test your knowledge.

 

You have 3 minutes so think fast.

1 / 20

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

2 / 20

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

3 / 20

Which of these describes a role?

4 / 20

Encryption Keys are automatically rotated every 30 days?

5 / 20

Secure Views and UDFs, bypass optimisations to protect data?

6 / 20

Which of below are a valid way to see details on views created?

7 / 20

Federated Authentication is not possible in Snowflake?

8 / 20

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

9 / 20

Semi-Structured data has support for all SQL operations?

10 / 20

Columnar data storage benefits from more efficient compression ratio's

11 / 20

Only Enterprise Edition and above can create a Data Share?

12 / 20

It is better to share an entire table rather than a Secure View?

13 / 20

Pipes load data into tables continuously from an ingestion queue?

14 / 20

Snowpipe charges for compute while loading files only?

15 / 20

What best defines a Securable Object?

16 / 20

Streams identify and act on changed table records?

17 / 20

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

18 / 20

When a task is created it is initially suspended?

19 / 20

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

20 / 20

Micro Partitions are created based on ingestion order of data within files to be loaded?

Your score is

0%