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

Which of the below are table types in Snowflake?

2 / 20

Which file formats are supported for a data unload?

3 / 20

Snowflake processes queries using the Storage Layer?

4 / 20

A transient table will be dropped when the user session that created it ends?

5 / 20

What are the types of View available in Snowflake?

6 / 20

The Time Travel feature is only available in Enterprise Edition or above?

7 / 20

Only Enterprise Edition and above can create a Data Share?

8 / 20

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

9 / 20

Which cloud provider Supports the most Regions in Snowflake?

10 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

11 / 20

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

12 / 20

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

13 / 20

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

14 / 20

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

15 / 20

We should always use ORDER BY clause in a subquery for the implicit performance gains?

16 / 20

During a Data Unload which option can we specify so data is not split into separate files?

17 / 20

Shared Data is always upto date?

18 / 20

Which of theses are managed by the Security component of Services Layer?

19 / 20

How many extra days does Failsafe provide the ability to restore data from?

20 / 20

How many Accounts can a customer own?

Your score is

0%