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

Snowpipe charges for compute while loading files only?

2 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

3 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

4 / 20

Stored procedures allow the execution of both DDL and DML?

5 / 20

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

6 / 20

Only Snowflake Support using failsafe can restore an External Table?

7 / 20

A Encryption Key can be in a state of Retired?

8 / 20

Which of the below are examples of Structured data?

9 / 20

Which of below are NOT valid Snowflake Editions?

10 / 20

During data Unload we cannot use a SQL query to target the data to extract?

11 / 20

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

12 / 20

Resource Monitors can only be created by account administrators?

13 / 20

Which Cloud providers provide a 'Private Link' to Snowflake from their Cloud platform?

14 / 20

Which role does a standard view execute as ?

15 / 20

Which of below Function can operate on Semi-Structured data?

16 / 20

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

17 / 20

Each increase in Warehouse size i.e. from Small to Medium or Medium to larges uses a Snowflake internal logarithmic algorithm to determine the number of clusters to add?

18 / 20

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

19 / 20

Multi Factor Authentication can be used with which of the below?

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

Your score is

0%