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

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

2 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

3 / 20

Which of the below is an example of a Solution Partners services?

4 / 20

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

5 / 20

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

6 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

7 / 20

How Long does a Snowpipe retain load history?

8 / 20

It is better to share an entire table rather than a Secure View?

9 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

10 / 20

Which of the below are examples of context functions?

11 / 20

Zero Copy Cloning allows which of below?

12 / 20

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

13 / 20

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

14 / 20

A Stored Procedure 'may' return a value but a UDF 'must' return a value?

15 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

16 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

17 / 20

Running a virtual warehouse consumes which of the below?

18 / 20

Which of below are valid Authentication methods in Snowflake?

19 / 20

If a Virtual Warehouse is stopped, we can preserve its cache with the WRITE_CACHE_TO_DISK clause?

20 / 20

The Snowflake account URL to logon is composed of which of the below?

Your score is

0%