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 UDF function code will contain $$ only at the end to signify end of code?

2 / 20

External Stages are managed by the Customer?

3 / 20

COPY INTO Loads are performed as single transaction?

4 / 20

Which of the below are types of Warehouse?

5 / 20

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

6 / 20

Snowflake has a grant that allows all 'Future' objects created in a schema to be granted privileges to a role Automatically?

7 / 20

Which of below could describe Machine Learning & Data Science?

8 / 20

When a task is created it is initially suspended?

9 / 20

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

10 / 20

Defining a Clustering Key can override natural clustering on a table?

11 / 20

Which of the below is an example of a Solution Partners services?

12 / 20

Which of these is NOT a recognised data workload genre?

13 / 20

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

14 / 20

What are the 2 default INBOUND shares of every account?

15 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

16 / 20

Which languages can UDF's be written in?

17 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

18 / 20

It is possible to Validate data to be loaded with out actually loading the data with the COPY INTO command

19 / 20

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

20 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

Your score is

0%