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

Why would we CAST data from a Variant?

2 / 20

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

3 / 20

Encryption Key Rotation will cause downtime so must be done during the users Maintenance Window?

4 / 20

Which best describes the securityadmin Role?

5 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

6 / 20

It is generally a good sign if we see data  'Spilling' to local disk?

7 / 20

It is better to share an entire table rather than a Secure View?

8 / 20

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

9 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

10 / 20

Enabling replication designates the source database as a standby database?

11 / 20

Snowflake Data protection features include which of the below?

12 / 20

What is the purpose of a Network Policy?

13 / 20

Which of the below are examples of Structured data?

14 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

15 / 20

Which of the below is the smallest Size Warehouse that can be configured?

16 / 20

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

17 / 20

Tasks can't be triggered manually, only on a schedule?

18 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

19 / 20

Pipes do not support semi structured data?

20 / 20

What are the types of Caching available in Snowflake?

Your score is

0%