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

When Resource Monitoring limits are approached an action can be triggered?

2 / 20

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

3 / 20

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

4 / 20

Only a table has a encryption key not a micro partition?

5 / 20

Resource Monitor notifications are sent to all Account Administrators?

6 / 20

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

7 / 20

A warehouse using Auto suspend and Resume can be expensive in credit consumption and should be avoided to save costs?

8 / 20

Stored procedures allow the execution of both DDL and DML?

9 / 20

A Encryption Key can be in a state of Retired?

10 / 20

Internal Stages can be in different regions and use a different Cloud Provider to that which the Snowflake Account resides in?

11 / 20

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

12 / 20

Which of the below are types of Warehouse?

13 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

14 / 20

Enabling replication designates the source database as a standby database?

15 / 20

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

16 / 20

Which of the below system Roles by default can create a Data Share?

17 / 20

A UDF can return a singular scalar value OR if defined a UDTF can return a set of rows?

18 / 20

Which of the below could we use to describe a Stream?

19 / 20

By default Snowflake blacklists all IP Addresses?

20 / 20

Database shares can be read write?

Your score is

0%