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

The COPY INTO command supports transaction control whereas Snowpipe does not?

2 / 20

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

3 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

4 / 20

Which of the below are components of ELT?

5 / 20

Multi Factor Authentication should be enabled on users with which role?

6 / 20

Resource Monitors can only be created by account administrators?

7 / 20

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

8 / 20

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

9 / 20

What is the maximum size of each micro partition (compressed data)?

10 / 20

External Stages are managed by the Customer?

11 / 20

How many Accounts can a customer own?

12 / 20

We can have a maximum of 10 network policies 'active' at one time?

13 / 20

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

14 / 20

For each securable object, there is a set of privileges that can be granted on it?

15 / 20

Which of the below are examples of offerings Technical Partners provide?

16 / 20

Pipes do not support semi structured data?

17 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

18 / 20

Customers can request a “Vanity” Account Logon URL?

19 / 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?

20 / 20

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

Your score is

0%