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

What are the 3 layers in the Snowflake architecture?

2 / 20

What 2 settings control when a query will be killed if queued or running to long?

3 / 20

Which best describes the sysadmin Role?

4 / 20

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

5 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

6 / 20

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

7 / 20

Which of the below are valid COPY INTO options?

8 / 20

Snowflake Data protection features include which of the below?

9 / 20

How Long does a COPY INTO bulk load retain load history?

10 / 20

Snowflake Streams hold no data?

11 / 20

A warehouse using Auto suspend and Resume can be expensive in credit consumption and should be avoided to save costs?

12 / 20

Using Resource Monitoring can help with Which of the below?

13 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

14 / 20

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

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

16 / 20

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

17 / 20

What format does Snowflake store its data?

18 / 20

The Results Cache holds 24 hours of results unless data is updated which then invalidates the Cache?

19 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

20 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

Your score is

0%