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 SNOWFLAKE database contains information about account usage?

2 / 20

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

3 / 20

Each increase in Warehouse size i.e. from Small to Medium or Medium to larges uses a Snowflake internal logarithmic algorithm to determine the number of clusters to add?

4 / 20

By default Snowflake blacklists all IP Addresses?

5 / 20

Who are two of the founding members of Snowflake?

6 / 20

Using Snowpipe we can scale compute for different workloads manually whereas COPY INTO uses a serverless compute model which we have no control?

7 / 20

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?

8 / 20

When we Unload data which of below are valid Parquet file format options?

9 / 20

In a  'managed access' schema, what would allow the granting of a object privilege within that schema?

10 / 20

Which of the below are examples of a call to a UDTF?

11 / 20

Which best describes the useradmin Role?

12 / 20

What are the 2 types of Stage in Snowflake?

13 / 20

File Encryption in Snowflake can use which of the below algorithms?

14 / 20

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

15 / 20

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

16 / 20

What are the 2 default INBOUND shares of every account?

17 / 20

Columnar data storage benefits from more efficient compression ratio's

18 / 20

We use the 'COPY INTO' clause to ingest files into a table?

19 / 20

It is better to share an entire table rather than a Secure View?

20 / 20

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

Your score is

0%