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

A Data Providers is someone who is sharing data?

2 / 20

Stored Procedures can only be written in Python?

3 / 20

Which of the below best describe a File Format ?

4 / 20

Time Travel can only be defined and used at the Database level?

5 / 20

For each securable object, there is a set of privileges that can be granted on it?

6 / 20

External tables provide a flexible way to write and unload data from snowflake?

7 / 20

Customers can request a “Vanity” Account Logon URL?

8 / 20

Static partition pruning is based on columns in the WHERE clause?

9 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

10 / 20

When Loading files 'from' Cloud Storage we must use the PUT Command

11 / 20

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

12 / 20

Which of below describes workloads Snowflake can handle best?

13 / 20

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

14 / 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?

15 / 20

Which of the below Roles has the privilege to define Network Policies?

16 / 20

Only Snowflake Support using failsafe can restore an External Table?

17 / 20

A Stage is used to load or unload data in Snowflake?

18 / 20

The SNOWFLAKE database contains information about account usage?

19 / 20

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

20 / 20

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

Your score is

0%