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

We use the 'COPY INTO' clause to ingest files into a table?

3 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

4 / 20

A UDF can return a singular scalar value OR if defined a UDTF can return a set of rows?

5 / 20

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

6 / 20

Internal Stages can be in different regions and use a different Cloud Provider to that which the Snowflake Account resides in?

7 / 20

The phase 'Scale Up' with regard to Snowflakes means to increase the cluster size i.e. from Small to Medium

8 / 20

Which best describes the public Role?

9 / 20

The SNOWFLAKE database contains information about account usage?

10 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

11 / 20

Pipes load data into tables continuously from an ingestion queue?

12 / 20

Which of the below are true of the Optimise Service?

13 / 20

Snowflake warehouse credits have a minimum charge of 31 days unless its a leap year then the minimum charge is 28 days, after which daily billing is implemented?

14 / 20

Stored Procedures can only be written in Python?

15 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

16 / 20

Storage is billed as uncompressed data?

17 / 20

Small tables are good candidates for a Clustering Key to be defined on?

18 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

19 / 20

Which Port is used for General SnowFlake traffic?

20 / 20

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

Your score is

0%