Snowflake Knowledge check Quiz

Created by user

SnowPro Core

SNOWDBA Knowledge Checker Test 1.0

20 Questions chosen at Random to test your knowledge.


You have 5 seconds per question so think fast.

1 / 20

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

2 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

3 / 20

Shared Data is always upto date?

4 / 20

Enabling replication designates the source database as a standby database?

5 / 20

Databases created from shares are prime candidates to be Replicated?

6 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

7 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

8 / 20

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

9 / 20

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

10 / 20

A permanent table can have Time travel of upto 1 year?

11 / 20

In Snowflake all communication is encrypted using TLS1.2?

12 / 20

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

13 / 20

Snowflake Data protection features include which of the below?

14 / 20

Which role will add the 'Account' icon on the Classic WebUI ribbon?

15 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

16 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

17 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

18 / 20

Which options do we see on the Classic WebUI Ribbon?

19 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

20 / 20

Which best describes the sysadmin Role?

Your score is