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

Which of the below are default System defined roles in Snowflake?

2 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

3 / 20

How many days extra protection does FailSafe provide?

4 / 20

Which of the below are examples of context functions?

5 / 20

Which best describes the sysadmin Role?

6 / 20

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

7 / 20

A larger type Warehouse size may be needed for?

8 / 20

Which of theses are managed by the Security component of Services Layer?

9 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

10 / 20

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

11 / 20

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

12 / 20

Resource Monitors can only be created by account administrators?

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

Pipes do not support semi structured data?

15 / 20

Which of the below are examples of Semi-Structured data?

16 / 20

What are the 2 methods for checking a PIPE and getting records into a table?

17 / 20

A Stored Procedure can only run as the owner and not the caller?

18 / 20

Every new database created contains 2 schemas what are these called?

19 / 20

Only Snowflake Support using failsafe can restore an External Table?

20 / 20

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

Your score is

0%