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 minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

2 / 20

The Snowflake account URL to logon is composed of which of the below?

3 / 20

Which of below describes workloads Snowflake can handle best?

4 / 20

A permanent table can have Time travel of upto 1 year?

5 / 20

Stored Procedures can only be written in Javascript?

6 / 20

Snowflake warehouse credits have a minimum charge of 31 days unless its a leap year then the minimum charge is 28 days, after which daily billing is implemented?

7 / 20

Which pipes are cloned with Zero Copy Cloning?

8 / 20

A Encryption Key can be in a state of Retired?

9 / 20

Resource Monitor notifications are sent to all Account Administrators?

10 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

11 / 20

What icon will a secure view have by it side in the WebUI?

12 / 20

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

13 / 20

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

14 / 20

All data in Snowflake is always protected either at rest or in transit?

15 / 20

What is the purpose of a Network Policy?

16 / 20

Search Optimisation Services can help improve the performance of highly selective lookup queries?

17 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

18 / 20

The best way to choose the right Warehouse size is to?

19 / 20

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

20 / 20

Only a table can be created as transient?

Your score is

0%