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

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

2 / 20

Snowpipe partially loaded files (based on ON_ERROR) can be combined/split into more transactions?

3 / 20

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

4 / 20

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

5 / 20

Scaling Out a Multi Cluster Warehouse support which options?

6 / 20

Which best describes the useradmin Role?

7 / 20

A Warehouse can only be resized if it is idle and suspended?

8 / 20

Database Replication can be enabled for any existing permanent or transient database?

9 / 20

Partner Connect lets you easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake?

10 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

11 / 20

A transient table will be dropped when the user session that created it ends?

12 / 20

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

13 / 20

Which of the below is the smallest Size Warehouse that can be configured?

14 / 20

The bigger a Warehouse the larger the cache that Warehouse has to use?

15 / 20

Which pipes are cloned with Zero Copy Cloning?

16 / 20

If the same query is re-run with no change in underlying data by a different user then the cached results from the previous query run are sent to that user so no Compute is used?

17 / 20

When Loading files 'from' Cloud Storage we must use the PUT Command

18 / 20

A Resource Monitor consists of which of the following properties?

19 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

20 / 20

We should always use ORDER BY clause in a subquery for the implicit performance gains?

Your score is

0%