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

A Resource Monitor consists of which of the following properties?

2 / 20

Which Port is used for General SnowFlake traffic?

3 / 20

What command is used to place files on a Stage from a local filesystem?

4 / 20

What format does Snowflake store its data?

5 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

6 / 20

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

7 / 20

Network Policies can only be assigned at the Account level?

8 / 20

Which of the below Cloud Storage offering are supported by Snowflake?

9 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

10 / 20

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

11 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

12 / 20

Which of the below best describe a File Format ?

13 / 20

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

14 / 20

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

15 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

16 / 20

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

17 / 20

External tables provide a flexible way to write and unload data from snowflake?

18 / 20

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

19 / 20

Tasks can not call a Stored Procedure?

20 / 20

Which of below are valid Authentication methods in Snowflake?

Your score is

0%