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

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

2 / 20

Files uploaded to staging area using PUT are auto encrypted?

3 / 20

Pipes contains a 'COPY INTO' statement?

4 / 20

How many days Time Travel does Standard Edition Provide?

5 / 20

Which role will add the 'Account' icon on the Classic WebUI ribbon?

6 / 20

Encryption Keys are automatically rotated every 30 days?

7 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

8 / 20

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

9 / 20

Using Snowpipe we can scale compute for different workloads manually whereas COPY INTO uses a serverless compute model which we have no control?

10 / 20

A permanent table can have Time travel of upto 1 year?

11 / 20

It is possible to Validate data to be loaded with out actually loading the data with the COPY INTO command

12 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

13 / 20

Defining a Clustering Key can override natural clustering on a table?

14 / 20

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

15 / 20

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

16 / 20

Stored Procedures can only be written in Python?

17 / 20

Which of the below best describes Snowflake Architecture?

18 / 20

Dynamic partition pruning is based on the JOIN columns of a query?

19 / 20

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

20 / 20

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

Your score is

0%