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 regular expression can be used with the COPY INTO command to filter the file files to target for load?

2 / 20

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

3 / 20

Most trial accounts start with 3 letters followed by 10  numbers?

4 / 20

Which best describes the accountadmin Role?

5 / 20

Using Snowpipe we can scale compute for different workloads manually whereas COPY INTO uses a serverless compute model which we have no control?

6 / 20

Which file formats are supported for a data unload?

7 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

8 / 20

A Stored Procedure 'may' return a value but a UDF 'must' return a value?

9 / 20

Resource Monitors can only be created by account administrators?

10 / 20

Which cloud provider Supports the most Regions in Snowflake?

11 / 20

What must we specify when loading a file directly from External Cloud Storage into Snowflake without the use of a stage?

12 / 20

Tasks can't be triggered manually, only on a schedule?

13 / 20

Which best describes the sysadmin Role?

14 / 20

A larger type Warehouse size may be needed for?

15 / 20

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

16 / 20

During data Unload we cannot use a SQL query to target the data to extract?

17 / 20

In Snowflake all communication is encrypted using TLS1.2?

18 / 20

Only Standard Views can be created as secure?

19 / 20

How many days Time Travel does Standard Edition Provide?

20 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

Your score is

0%