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

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

2 / 20

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

3 / 20

What are the 3 layers in the Snowflake architecture?

4 / 20

A consumer will use their own Warehouse's compute when accessing a Data Share

5 / 20

Charges at the Cloud Services layers are for compute that exceeds 10% of total computes costs for the account?

6 / 20

Which of below are NOT valid Snowflake Editions?

7 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

8 / 20

Encryption Keys are automatically rotated every 30 days?

9 / 20

A Stored Procedure can only run as the owner and not the caller?

10 / 20

What are the 2 types of Stage in Snowflake?

11 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

12 / 20

Running a virtual warehouse consumes which of the below?

13 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

14 / 20

Time Travel Syntax can include which of the below?

15 / 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?

16 / 20

What must we specify when loading a file directly from External Cloud Storage into Snowflake without the use of a stage?

17 / 20

Which of the below are requirements or restrictions for a User Password in Snowflake?

18 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

19 / 20

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

20 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

Your score is

0%