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

A warehouse using Auto suspend and Resume can be expensive in credit consumption and should be avoided to save costs?

2 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

3 / 20

Data Consumers would create an Outbound Share?

4 / 20

How many days Time Travel does Standard Edition Provide?

5 / 20

Stored Procedures can only be written in Python?

6 / 20

Which of the below are examples of Structured data?

7 / 20

Data Encryption uses a Hierarchical key model?

8 / 20

Tasks can not call a Stored Procedure?

9 / 20

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

10 / 20

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

11 / 20

Which of the below are true of the Optimise Service?

12 / 20

UDF's does not support the use of DDL but do support the use of DML?

13 / 20

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

14 / 20

Static partition pruning is based on columns in the WHERE clause?

15 / 20

Warehouses assigned to Resource Monitor are suspended and cannot be resumed until which of following?

16 / 20

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

17 / 20

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

18 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

19 / 20

Using Snowpipe does not require a customer started virtual warehouse?

20 / 20

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

Your score is

0%