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

Natural table Clustering can not be overridden?

2 / 20

Micro Partitions are created based on ingestion order of data within files to be loaded?

3 / 20

Data Encryption uses a Hierarchical key model?

4 / 20

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

5 / 20

Every new database created contains 2 schemas what are these called?

6 / 20

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

7 / 20

Pipes do not support semi structured data?

8 / 20

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

9 / 20

Which of the below are examples of unstructured data?

10 / 20

Zero Copy Cloning allows which of below?

11 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

12 / 20

When loading data from files into SnowFlake what 2 main factors may impact performance of that load?

13 / 20

How many Accounts can a customer own?

14 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

15 / 20

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

16 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

17 / 20

What are the 2 methods for checking a PIPE and getting records into a table?

18 / 20

Which of the below are default System defined roles in Snowflake?

19 / 20

During data Unload we cannot use a SQL query to target the data to extract?

20 / 20

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

Your score is

0%