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

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

2 / 20

Tasks can execute multiple DML statements?

3 / 20

Snowflake has a default file format if none is explicitly set?

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

5 / 20

Which of theses are managed by the Security component of Services Layer?

6 / 20

The Time Travel feature is only available in Enterprise Edition or above?

7 / 20

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

8 / 20

Business intelligence (BI) can be described by which of the below?

9 / 20

A Stage is used to load or unload data in Snowflake?

10 / 20

What are the 2 default INBOUND shares of every account?

11 / 20

Secure Views and UDFs, bypass optimisations to protect data?

12 / 20

Charges at the Cloud Services layers are for compute that exceeds 10% of total computes costs for the account?

13 / 20

The SNOWFLAKE database contains information about account usage?

14 / 20

When we Unload JSON data which of below are valid File Format Options?

15 / 20

The transform part of ETL can be best described as 'modifying source data using conversion methods' ?

16 / 20

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

17 / 20

Only Enterprise Edition and above can create a Data Share?

18 / 20

Every new database created contains 2 schemas what are these called?

19 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

20 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

Your score is

0%