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

What command is used to place files on a Stage from a local filesystem?

2 / 20

How many extra days does Failsafe provide the ability to restore data from?

3 / 20

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

4 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

5 / 20

Only Snowflake Support using failsafe can restore an External Table?

6 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

7 / 20

Which of the below are valid services managed by the Service Layer?

 

8 / 20

The Cloud Services layer can actually consume billable compute credits?

9 / 20

A transient table will be dropped when the user session that created it ends?

10 / 20

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

11 / 20

Time Travel Syntax can include which of the below?

12 / 20

Only Enterprise Edition and above can create a Data Share?

13 / 20

Streams identify and act on changed table records?

14 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

15 / 20

Which of below are valid Authentication methods in Snowflake?

16 / 20

We use the 'COPY INTO' clause to ingest files into a table?

17 / 20

Database shares can be read write?

18 / 20

Resource Monitor notifications are sent to all Account Administrators?

19 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

20 / 20

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

Your score is

0%