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

Resource Monitors can only be created by account administrators?

2 / 20

During data Unload we cannot use a SQL query to target the data to extract?

3 / 20

Data Shares can only be dropped once approved by a Consumer?

4 / 20

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

5 / 20

Which of the below are examples of offerings Technical Partners provide?

6 / 20

Its possible to kill a running query from the WebUI using 'Abort'

7 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

8 / 20

The Service Layer stores which of the below about each Micro Partition?

9 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

10 / 20

Which of these is not a database object in Snowflake?

11 / 20

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

12 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

13 / 20

Pipes do not support semi structured data?

14 / 20

Which of the below COPY INTO options are related to data length?

15 / 20

What is the maximum size of each micro partition (compressed data)?

16 / 20

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

17 / 20

What type of Cloud Platform is Snowflake?

18 / 20

For each securable object, there is a set of privileges that can be granted on it?

19 / 20

What best defines a Securable Object?

20 / 20

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

Your score is

0%