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

Search Optimisation Services can help improve the performance of highly selective lookup queries?

2 / 20

Which of the below can we perform on data when we LOAD into a table in Snowflake?

3 / 20

Trial accounts can be converted to paid accounts?

4 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

5 / 20

What are the 3 layers in the Snowflake architecture?

6 / 20

Which of the below are examples of Quasi-Structured data?

7 / 20

When we Unload JSON data which of below are valid File Format Options?

8 / 20

Only Standard Views can be created as secure?

9 / 20

Data Encryption uses a Hierarchical key model?

10 / 20

Which of the below are true of the Optimise Service?

11 / 20

Scaling Out a Multi Cluster Warehouse support which options?

12 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

13 / 20

Business intelligence (BI) can be described by which of the below?

14 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

15 / 20

Micro Partitions are immutable, what does this mean?

16 / 20

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

17 / 20

Which of the below are valid services managed by the Service Layer?

 

18 / 20

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

19 / 20

Columnar data storage benefits from more efficient compression ratio's

20 / 20

Encryption Key Rotation will cause downtime so must be done during the users Maintenance Window?

Your score is

0%