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

File Encryption in Snowflake can use which of the below algorithms?

2 / 20

What are the 2 methods for checking a PIPE and getting records into a table?

3 / 20

A Database can hold many Schema's?

4 / 20

Which of the below are attributes of a secure view?

5 / 20

Which of below could describe Machine Learning & Data Science?

6 / 20

Table Stages are created automatically by the system?

7 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

8 / 20

Federated Authentication is not possible in Snowflake?

9 / 20

Dynamic partition pruning is based on the JOIN columns of a query?

10 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

11 / 20

Using Resource Monitoring can help with Which of the below?

12 / 20

Users must manually refresh a Materialised View to keep it's data upto date?

13 / 20

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

14 / 20

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

15 / 20

How many days extra protection does FailSafe provide?

16 / 20

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

17 / 20

Use of the LIMIT clause can have a large positive impact on performance?

18 / 20

Which of the below are examples of a call to a UDTF?

19 / 20

Every active user session has a current role?

20 / 20

Each virtual warehouse is an independent compute cluster but it shares resources with 'other' virtual warehouses?

Your score is

0%