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

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?

2 / 20

The COPY INTO command can specify a maximum list of 1000 files to load at a time?

3 / 20

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

4 / 20

There is no limit on the number of Data Shares a Provider can provision?

5 / 20

What are the 2 default INBOUND shares of every account?

6 / 20

Scaling Out a Multi Cluster Warehouse support which options?

7 / 20

Which pipes are cloned with Zero Copy Cloning?

8 / 20

It is generally a good sign if we see data  'Spilling' to local disk?

9 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

10 / 20

Which of the following Semi Structured formats does Snowflake support?

11 / 20

Which of the below are examples of Quasi-Structured data?

12 / 20

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

13 / 20

How many days 'maximum' does Time Travel Enterprise Edition and above provide as a limit?

14 / 20

Which of the below are true about a TASK in Snowflake?

15 / 20

What are the 2 types of Stage in Snowflake?

16 / 20

Where can we upload data from in Snowflake?

17 / 20

Which of the below system Roles by default can create a Data Share?

18 / 20

Which Port is used for General SnowFlake traffic?

19 / 20

Uncorrelated Scalar Subqueries generally run faster than Correlated Scalar Subqueries?

20 / 20

Which of the below are components of ELT?

Your score is

0%