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

Which of the below are valid COPY INTO options?

2 / 20

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

3 / 20

How Long does a COPY INTO bulk load retain load history?

4 / 20

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

5 / 20

Which of the below are Scaling Policies for a Warehouse?

6 / 20

Which pipes are cloned with Zero Copy Cloning?

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

Time Travel Syntax can include which of the below?

9 / 20

Natural table Clustering can not be overridden?

10 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

11 / 20

Trial accounts can be converted to paid accounts?

12 / 20

Which of the below Roles has the privilege to define Network Policies?

13 / 20

Tasks can not call a Stored Procedure?

14 / 20

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

15 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

16 / 20

Only a table has a encryption key not a micro partition?

17 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

18 / 20

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

19 / 20

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

20 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

Your score is

0%