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 Encryption Key can be in a state of Retired?

2 / 20

Scaling Out a Multi Cluster Warehouse support which options?

3 / 20

The Time Travel feature allows customers to restore there data back to ANY time in the past since the database was created?

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

5 / 20

How often does Snowflake rotate Encryption keys?

6 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

7 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

8 / 20

User Stages do support file formats?

9 / 20

Which of these is NOT a recognised data workload genre?

10 / 20

Which best describes the accountadmin Role?

11 / 20

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

12 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

13 / 20

Time Travel Syntax can include which of the below?

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

15 / 20

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

16 / 20

Resource Monitor notifications are sent to all Account Administrators?

17 / 20

Which of the below are components of ELT?

18 / 20

Snowflake Data protection features include which of the below?

19 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

20 / 20

Time Travel is NOT available in Standard Edition?

Your score is

0%