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

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

2 / 20

Which of the below are Valid Snowflake Editions?

3 / 20

A Data Providers is someone who is sharing data?

4 / 20

Which of the below COPY INTO options are related to data length?

5 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

6 / 20

Data Shares can only be dropped once approved by a Consumer?

7 / 20

How many days Time Travel does Standard Edition Provide?

8 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

9 / 20

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

10 / 20

Which best describes the accountadmin Role?

11 / 20

Snowflake Multi Factor Authentication makes use of DUO?

12 / 20

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

13 / 20

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

14 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

15 / 20

Which of the below is the smallest Size Warehouse that can be configured?

16 / 20

Snowflake processes queries using the Storage Layer?

17 / 20

Snowflake has a default file format if none is explicitly set?

18 / 20

Which role does a standard view execute as ?

19 / 20

Secure Views and UDFs, bypass optimisations to protect data?

20 / 20

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

Your score is

0%