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

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

2 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

3 / 20

Which of the below are types of Stage in Snowflake?

4 / 20

Which of the below are Valid Snowflake Editions?

5 / 20

Which Data type is great for storing semi-structured data?

6 / 20

What are the types of View available in Snowflake?

7 / 20

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

8 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

9 / 20

Time Travel is NOT available in Standard Edition?

10 / 20

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

11 / 20

Which of the below can we perform on data when we LOAD into a table in Snowflake?

12 / 20

How often does Snowflake rotate Encryption keys?

13 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

14 / 20

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

15 / 20

What format does Snowflake store its data?

16 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

17 / 20

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

18 / 20

Snowflake Streams hold no data?

19 / 20

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

20 / 20

Having a high Time Travel setting can help reduce Storage Costs?

Your score is

0%