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

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

2 / 20

Table Stages are created automatically by the system?

3 / 20

Files uploaded to staging area using PUT are auto encrypted?

4 / 20

Internal Stages can be in different regions and use a different Cloud Provider to that which the Snowflake Account resides in?

5 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

6 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

7 / 20

Every active user session has a current role?

8 / 20

How many days of Query History can be viewed from ribbon item 'History' in the WebUI?

9 / 20

Network Policies can only be assigned at the Account level?

10 / 20

Tasks can execute multiple DML statements?

11 / 20

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

12 / 20

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

13 / 20

Which cloud provider Supports the most Regions in Snowflake?

14 / 20

Snowflakes uses table row format to store data in micro partitions?

15 / 20

When Loading files 'from' Cloud Storage we must use the PUT Command

16 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

17 / 20

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

18 / 20

Which of the below describes the Search Optimisation Service?

19 / 20

The Snowflake account URL to logon is composed of which of the below?

20 / 20

Which of the below best describe a File Format ?

Your score is

0%