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 below are a valid way to see details on views created?

2 / 20

Which Port is used for General SnowFlake traffic?

3 / 20

Which of theses are managed by the Security component of Services Layer?

4 / 20

Running a virtual warehouse consumes which of the below?

5 / 20

What are the 2 types of Stage in Snowflake?

6 / 20

A larger type Warehouse size may be needed for?

7 / 20

What are the 2 default INBOUND shares of every account?

8 / 20

Tasks can not call a Stored Procedure?

9 / 20

Which of the below are examples of Security and governance tools?

10 / 20

Discretionary Control is where each Securable Object has many Owners who can't grant others access?

11 / 20

Database shares can be read write?

12 / 20

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

13 / 20

Which of the below are components of ELT?

14 / 20

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

15 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

16 / 20

Which of the below are table types in Snowflake?

17 / 20

All data in Snowflake is always protected either at rest or in transit?

18 / 20

Business intelligence (BI) can be described by which of the below?

19 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

20 / 20

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

Your score is

0%