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

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

2 / 20

What are the types of View available in Snowflake?

3 / 20

Streams identify and act on changed table records?

4 / 20

We should always use ORDER BY clause in a subquery for the implicit performance gains?

5 / 20

When a database is replicated to another account Snowflake encrypts its database files?

6 / 20

User Stages do support file formats?

7 / 20

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

8 / 20

Which of the below are valid COPY INTO options?

9 / 20

In a Network policy if we Whitelist something then everything else is automatically blacklisted?

10 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

11 / 20

How many days Time Travel does Standard Edition Provide?

12 / 20

Which of these describes a role?

13 / 20

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

14 / 20

Trial accounts can be converted to paid accounts?

15 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

16 / 20

The Service Layer stores which of the below about each Micro Partition?

17 / 20

What are the 2 default INBOUND shares of every account?

18 / 20

A Stored Procedure can only run as the owner and not the caller?

19 / 20

Enabling replication designates the source database as a standby database?

20 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

Your score is

0%