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

Only the Snowflake Support can perform data restores using  FailSafe?

2 / 20

Network Policies can only be assigned at the Account level?

3 / 20

Which Port is used for General SnowFlake traffic?

4 / 20

Snowpipe charges for compute while loading files only?

5 / 20

What type of Cloud Platform is Snowflake?

6 / 20

A Database can hold many Schema's?

7 / 20

Using Resource Monitoring can help with Which of the below?

8 / 20

What best defines a Securable Object?

9 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

10 / 20

User Stages do support file formats?

11 / 20

Within a stored procedure argument names are case-insensitive in SQL portion of stored procedure?

12 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

13 / 20

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

14 / 20

What are the 2 default INBOUND shares of every account?

15 / 20

Snowflake Data protection features include which of the below?

16 / 20

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

17 / 20

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

18 / 20

Which information below can we view about a query that has run in the past?

19 / 20

What are the 2 types of Stage in Snowflake?

20 / 20

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

Your score is

0%