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

When loading files from a local filesystem using PUT the local host must have which of the below?

2 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

3 / 20

Stored Procedures can only be written in Javascript?

4 / 20

A Virtual Warehouse can be assigned to many Resource Monitors?

5 / 20

A Resource Monitor consists of which of the following properties?

6 / 20

What are the 2 types of Stage in Snowflake?

7 / 20

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

8 / 20

Table Stages are created automatically by the system?

9 / 20

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

10 / 20

Which file formats are supported for a data unload?

11 / 20

We should Organise data being loaded into logical paths like by date, to better aid co-locating that data in the same micro partition?

12 / 20

Time Travel can only be defined and used at the Database level?

13 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

14 / 20

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

15 / 20

Use of the LIMIT clause can have a large positive impact on performance?

16 / 20

The Cloud Services layer can actually consume billable compute credits?

17 / 20

In Snowflake all communication is encrypted using TLS1.2?

18 / 20

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

19 / 20

For each securable object, there is a set of privileges that can be granted on it?

20 / 20

A larger type Warehouse size may be needed for?

Your score is

0%