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

You can use SQL ID as the basis to set the time that Time Travel will use?

2 / 20

Its possible to kill a running query from the WebUI using 'Abort'

3 / 20

Which of these is NOT a recognised data workload genre?

4 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

5 / 20

We can have a maximum of 10 network policies 'active' at one time?

6 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

7 / 20

All tables are natural Clustered based on data ingestion order?

8 / 20

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

9 / 20

Which of below describes workloads Snowflake can handle best?

10 / 20

Enabling replication designates the source database as a standby database?

11 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

12 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

13 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

14 / 20

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?

15 / 20

An example of Partners that facilitate the loading of data into snowflake are?

16 / 20

Snowpipe requires keypair authentication using JWT?

17 / 20

Semi-Structured data has support for all SQL operations?

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

19 / 20

Which of the below Cloud Storage offering are supported by Snowflake?

20 / 20

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

Your score is

0%