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

Who are two of the founding members of Snowflake?

2 / 20

Which of the below best describes Snowflake Architecture?

3 / 20

How Long does a Snowpipe retain load history?

4 / 20

Which of the below are true of the Optimise Service?

5 / 20

Only Standard Views can be created as secure?

6 / 20

When Resource Monitoring limits are approached an action can be triggered?

7 / 20

A regular expression can be used with the COPY INTO command to filter the file files to target for load?

8 / 20

Stored procedures allow the execution of both DDL and DML?

9 / 20

Why would we CAST data from a Variant?

10 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

11 / 20

Snowpipe charges for compute while loading files only?

12 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

13 / 20

Using Resource Monitoring can help with Which of the below?

14 / 20

Every new database created contains 2 schemas what are these called?

15 / 20

What commands are used to allow or deny access on an objects to a roles?

16 / 20

When we Unload data which of below are valid Parquet file format options?

17 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

18 / 20

When a database is replicated to another account Snowflake encrypts its database files?

19 / 20

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

20 / 20

Which of below are NOT valid Snowflake Editions?

Your score is

0%