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

The acronym BI stands for?

2 / 20

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

3 / 20

SNOWFLAKE_SAMPLE_DATA is a database share provided for performance testing and learning?

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

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

6 / 20

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

7 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

8 / 20

During a Data Unload which option can we specify so data is not split into separate files?

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

10 / 20

Snowflakes uses table row format to store data in micro partitions?

11 / 20

How often does Snowflake rotate Encryption keys?

12 / 20

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

13 / 20

How many days extra protection does FailSafe provide?

14 / 20

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

15 / 20

The COPY INTO command supports transaction control whereas Snowpipe does not?

16 / 20

Secure Views and UDFs, bypass optimisations to protect data?

17 / 20

Enabling replication designates the source database as a standby database?

18 / 20

Which of the below are examples of context functions?

19 / 20

Which of below Function can operate on Semi-Structured data?

20 / 20

Snowflake Multi Factor Authentication makes use of DUO?

Your score is

0%