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

Data can be loaded as a Join from 2 files into Snowflake?

2 / 20

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

3 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

4 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

5 / 20

Streams are a form of Change Data Capture (CDC)?

6 / 20

Which Data type is great for storing semi-structured data?

7 / 20

Customers can request a “Vanity” Account Logon URL?

8 / 20

Which of the below are requirements or restrictions for a User Password in Snowflake?

9 / 20

The Cloud Services layer can actually consume billable compute credits?

10 / 20

Which of the below are types of Stage in Snowflake?

11 / 20

In Snowflake all communication is encrypted using TLS1.2?

12 / 20

It is better to share an entire table rather than a Secure View?

13 / 20

Snowflake Multi Factor Authentication makes use of DUO?

14 / 20

Resource Monitors can only be created by account administrators?

15 / 20

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

16 / 20

Dynamic partition pruning is based on the JOIN columns of a query?

17 / 20

When a task is created it is initially suspended?

18 / 20

Which of the below describes Data Sharing in Snowflake?

19 / 20

Which options do we see on the Classic WebUI Ribbon?

20 / 20

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

Your score is

0%