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

Customers can request a “Vanity” Account Logon URL?

2 / 20

Database Replication can be enabled for any existing permanent or transient database?

3 / 20

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

4 / 20

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

5 / 20

Columnar data storage benefits from more efficient compression ratio's

6 / 20

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

7 / 20

We can have a maximum of 10 network policies 'active' at one time?

8 / 20

COPY INTO Loads are performed as single transaction?

9 / 20

In Snowflake all communication is encrypted using TLS1.2?

10 / 20

Which best describes the accountadmin Role?

11 / 20

Which of the below are examples of Technical Partners offerings?

12 / 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?

13 / 20

Streams identify and act on changed table records?

14 / 20

Multi Factor Authentication should be enabled on users with which role?

15 / 20

Which of the below are types of Warehouse?

16 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

17 / 20

What is the maximum size of each micro partition (compressed data)?

18 / 20

Encryption Key Rotation will cause downtime so must be done during the users Maintenance Window?

19 / 20

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

20 / 20

How many days Time Travel does Standard Edition Provide?

Your score is

0%