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 the below are examples of unstructured data?

2 / 20

Which of the below options can be used to Improve Query Performance?

3 / 20

When Loading files 'from' Cloud Storage we must use the PUT Command

4 / 20

Data Encryption uses a Hierarchical key model?

5 / 20

Using Resource Monitoring can help with Which of the below?

6 / 20

The Service Layer stores which of the below about each Micro Partition?

7 / 20

Multi Factor Authentication should be enabled on users with which role?

8 / 20

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

9 / 20

Failsafe supports all table types as long as the customer is running on Enterprise Edition or above?

10 / 20

There is no limit on the number of Data Shares a Provider can provision?

11 / 20

Which of the below system Roles by default can create a Data Share?

12 / 20

Which best describes the useradmin Role?

13 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

14 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

15 / 20

Zero Copy Cloning allows which of below?

16 / 20

Which of the below are valid COPY INTO options?

17 / 20

Which of the below are types of Stage in Snowflake?

18 / 20

A larger type Warehouse size may be needed for?

19 / 20

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

20 / 20

Static partition pruning is based on columns in the WHERE clause?

Your score is

0%