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 format does Snowflake store its data?

2 / 20

The Time Travel feature is only available in Enterprise Edition or above?

3 / 20

Which of the below is the smallest Size Warehouse that can be configured?

4 / 20

Which Cloud providers provide a 'Private Link' to Snowflake from their Cloud platform?

5 / 20

Every active user session has a current role?

6 / 20

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

7 / 20

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

8 / 20

Natural table Clustering can not be overridden?

9 / 20

Which of the below best describe a File Format ?

10 / 20

Which of the below are attributes of a Named Stage?

11 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

12 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

13 / 20

What are the 2 types of Stage in Snowflake?

14 / 20

Automatic table Clustering can be Suspended and Resumed?

15 / 20

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

16 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

17 / 20

When a task is created it is initially suspended?

18 / 20

A Encryption Key can be in a state of Retired?

19 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

20 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

Your score is

0%