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

Multi Factor Authentication can be used with which of the below?

2 / 20

Running a virtual warehouse consumes which of the below?

3 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

4 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

5 / 20

Using Resource Monitoring can help with Which of the below?

6 / 20

Snowflake warehouse credits have a minimum charge of 31 days unless its a leap year then the minimum charge is 28 days, after which daily billing is implemented?

7 / 20

Which Port is used for General SnowFlake traffic?

8 / 20

Storage is billed as uncompressed data?

9 / 20

Use of the LIMIT clause can have a large positive impact on performance?

10 / 20

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

11 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

12 / 20

What are the 3 layers in the Snowflake architecture?

13 / 20

Natural table Clustering can not be overridden?

14 / 20

Small tables are good candidates for a Clustering Key to be defined on?

15 / 20

Within a stored procedure argument names are case-insensitive in SQL portion of stored procedure?

16 / 20

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

17 / 20

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

18 / 20

An example of Partners that facilitate the loading of data into snowflake are?

19 / 20

A consumer will use their own Warehouse's compute when accessing a Data Share

20 / 20

Automatic table Clustering can be Suspended and Resumed?

Your score is

0%