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

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

2 / 20

Which information below can we view about a query that has run in the past?

3 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

4 / 20

Data Consumers would create an Outbound Share?

5 / 20

What are the 2 types of Stage in Snowflake?

6 / 20

Only a table has a encryption key not a micro partition?

7 / 20

Which Data type is great for storing semi-structured data?

8 / 20

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

9 / 20

During a Data Unload which option can we specify so data is not split into separate files?

10 / 20

Internal Stages are managed by the Customer?

11 / 20

By default Snowflake blacklists all IP Addresses?

12 / 20

Which of the below are valid COPY INTO options?

13 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

14 / 20

Which of the below are Valid Snowflake Editions?

15 / 20

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

16 / 20

Encryption Keys are automatically rotated every 30 days?

17 / 20

For each securable object, there is a set of privileges that can be granted on it?

18 / 20

Why would we CAST data from a Variant?

19 / 20

Which of the below are examples of Technical Partners offerings?

20 / 20

Which Editions of Snowflake cover SOC2 Type 2, SOC1 TypeII compliance?

Your score is

0%