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

Customers must define a maintenance window for which Snowflake can use to allow downtime needed to apply patch updates?

2 / 20

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

3 / 20

Which of the below are valid COPY INTO options?

4 / 20

A Virtual Warehouse can be assigned to many Resource Monitors?

5 / 20

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

6 / 20

Resource Monitors can only be created by account administrators?

7 / 20

Which best describes the sysadmin Role?

8 / 20

We should look to process one large file rather than splitting a large files into smaller ones before loading into Snowflake so each warehouse can parallel process the file?

9 / 20

Snowflake warehouse credits have a minimum charge of 31 days unless its a leap year then the minimum charge is 28 days, after which daily billing is implemented?

10 / 20

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

11 / 20

Having a high Time Travel setting can help reduce Storage Costs?

12 / 20

Time Travel Syntax can include which of the below?

13 / 20

How many extra days does Failsafe provide the ability to restore data from?

14 / 20

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

15 / 20

What are the types of Caching available in Snowflake?

16 / 20

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

17 / 20

Network Policies can only be assigned at the Account level?

18 / 20

Stored Procedures can only be written in Javascript?

19 / 20

How many days of Query History can be viewed from ribbon item 'History' in the WebUI?

20 / 20

Which of the below are Valid Snowflake Editions?

Your score is

0%