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

When a task is created it is initially suspended?

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

3 / 20

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

4 / 20

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

5 / 20

'WAREHOUSE_METERING_HISTORY' view shows how much cloud service compute an account has used?

6 / 20

What commands are used to allow or deny access on an objects to a roles?

7 / 20

Which of the below are requirements or restrictions for a User Password in Snowflake?

8 / 20

Which of the below are examples of unstructured data?

9 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

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

11 / 20

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

12 / 20

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

13 / 20

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

14 / 20

Which of the below is the smallest Size Warehouse that can be configured?

15 / 20

Which pipes are cloned with Zero Copy Cloning?

16 / 20

Which of the below is an example of a Solution Partners services?

17 / 20

Storage is billed as uncompressed data?

18 / 20

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

19 / 20

Table Stages are created automatically by the system?

20 / 20

Snowflake has a grant that allows all 'Future' objects created in a schema to be granted privileges to a role Automatically?

Your score is

0%