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

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

2 / 20

Which of below describes workloads Snowflake can handle best?

3 / 20

Resource Monitor notifications are sent to all Account Administrators?

4 / 20

A Resource Monitor consists of which of the following properties?

5 / 20

What are the types of View available in Snowflake?

6 / 20

Columnar data storage benefits from more efficient compression ratio's

7 / 20

During a Data Unload which option can we specify so data is not split into separate files?

8 / 20

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

9 / 20

Which of the below could we use to describe a Stream?

10 / 20

When we Unload data which of below are valid Parquet file format options?

11 / 20

Which of the below Roles has the privilege to define Network Policies?

12 / 20

What determines the maximum file size for data unloads out of Snowflake?

13 / 20

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

14 / 20

Only a table has a encryption key not a micro partition?

15 / 20

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

16 / 20

What 2 settings control when a query will be killed if queued or running to long?

17 / 20

Which of the below are types of Warehouse?

18 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

19 / 20

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

20 / 20

Which best describes the useradmin Role?

Your score is

0%