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 COPY INTO options are related to data length?

2 / 20

Which Port is used for General SnowFlake traffic?

3 / 20

Trial accounts can be converted to paid accounts?

4 / 20

Which of the below are examples of unstructured data?

5 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

6 / 20

Time Travel can only be defined and used at the Database level?

7 / 20

Which of the below describes Data Sharing in Snowflake?

8 / 20

How Long does a COPY INTO bulk load retain load history?

9 / 20

Who are two of the founding members of Snowflake?

10 / 20

Tasks can not call a Stored Procedure?

11 / 20

Time Travel is NOT available in Standard Edition?

12 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

13 / 20

Which of the below describes the Search Optimisation Service?

14 / 20

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

15 / 20

Which of these describes a role?

16 / 20

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

17 / 20

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

18 / 20

What is Snowsight?

19 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

20 / 20

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

Your score is

0%