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 of Query History can be viewed from ribbon item 'History' in the WebUI?

2 / 20

Only Snowflake Support using failsafe can restore an External Table?

3 / 20

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

4 / 20

When a database is replicated to another account Snowflake encrypts its database files?

5 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

6 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

7 / 20

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

8 / 20

What determines the maximum file size for data unloads out of Snowflake?

9 / 20

Which of the below Cloud Storage offering are supported by Snowflake?

10 / 20

We can have a maximum of 10 network policies 'active' at one time?

11 / 20

Every active user session has a current role?

12 / 20

Which Port is used for General SnowFlake traffic?

13 / 20

Which of below are valid Authentication methods in Snowflake?

14 / 20

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

15 / 20

Database shares can be read write?

16 / 20

A secure view allows access to tables which are owned by the accountadmin role?

17 / 20

A UDF function code will contain $$ only at the end to signify end of code?

18 / 20

The Cloud Services layer can actually consume billable compute credits?

19 / 20

Which of the below are examples of Technical Partners offerings?

20 / 20

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

Your score is

0%