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

Databases created from shares are prime candidates to be Replicated?

2 / 20

Which of the below are Valid Snowflake Editions?

3 / 20

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

4 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

5 / 20

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

6 / 20

Once data changes are made to a Zero Copy Clone database, new micro partitions will track that change?

7 / 20

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

8 / 20

Storage is billed as uncompressed data?

9 / 20

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

10 / 20

A consumer will use their own Warehouse's compute when accessing a Data Share

11 / 20

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

12 / 20

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

13 / 20

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

14 / 20

Which of the below best describes Snowflake Architecture?

15 / 20

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

16 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

17 / 20

What must we specify when loading a file directly from External Cloud Storage into Snowflake without the use of a stage?

18 / 20

Database shares can be read write?

19 / 20

Static partition pruning is based on columns in the WHERE clause?

20 / 20

Multi Factor Authentication can be used with which of the below?

Your score is

0%