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

Pipes load data into tables continuously from an ingestion queue?

2 / 20

Every new database created contains 2 schemas what are these called?

3 / 20

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

4 / 20

User Stages do support file formats?

5 / 20

Which of the following does Search Optimisation NOT support?

6 / 20

Which of these is NOT a recognised data workload genre?

7 / 20

Which options do we see on the Classic WebUI Ribbon?

8 / 20

Data Consumers would create an Outbound Share?

9 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

10 / 20

Snowpipe charges for compute while loading files only?

11 / 20

Which of the below best describe a File Format ?

12 / 20

Which of below are NOT valid Snowflake Editions?

13 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

14 / 20

If the Time Travel setting is reduced from 45 to 35 days, all versioned historic time travel data older than 35 days will be deleted

15 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

16 / 20

There is a limit of 100 databases that can be replicated per account?

17 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

18 / 20

Encryption Keys are automatically rotated every 30 days?

19 / 20

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

20 / 20

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

Your score is

0%

Leave a Reply 0

Your email address will not be published. Required fields are marked *