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 system Roles by default can create a Data Share?

2 / 20

Which of the below are valid COPY INTO options?

3 / 20

Running a virtual warehouse consumes which of the below?

4 / 20

Databases created from shares are prime candidates to be Replicated?

5 / 20

Which file formats are supported for a data unload?

6 / 20

Which of the below describes the Search Optimisation Service?

7 / 20

Which of the below are Valid Snowflake Editions?

8 / 20

Which of the below are Scaling Policies for a Warehouse?

9 / 20

Columnar data storage benefits from more efficient compression ratio's

10 / 20

Resource Monitors can only be created by account administrators?

11 / 20

File Encryption in Snowflake can use which of the below algorithms?

12 / 20

Using Snowpipe does not require a customer started virtual warehouse?

13 / 20

Where can we upload data from in Snowflake?

14 / 20

When a database is replicated to another account Snowflake encrypts its database files?

15 / 20

User Stages do support file formats?

16 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

17 / 20

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

18 / 20

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

19 / 20

Which of the below are valid services managed by the Service Layer?

 

20 / 20

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

Your score is

0%