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

Secure Views and UDFs, bypass optimisations to protect data?

2 / 20

What format does Snowflake store its data?

3 / 20

Which of below could describe Machine Learning & Data Science?

4 / 20

Only a table can be created as transient?

5 / 20

Which of the below are types of Warehouse?

6 / 20

Which of the options for the COPY INTO command below are related to reloading a file that may have already been loaded?

7 / 20

Network Policies can only be assigned at the Account level?

8 / 20

Time Travel is NOT available in Standard Edition?

9 / 20

If the same query is re-run with no change in underlying data by a different user then the cached results from the previous query run are sent to that user so no Compute is used?

10 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

11 / 20

Which of these is not a database object in Snowflake?

12 / 20

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

13 / 20

Which options below will create a new database called PSAMMY?

14 / 20

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

15 / 20

Which role will add the 'Account' icon on the Classic WebUI ribbon?

16 / 20

Which of the below are examples of Semi-Structured data?

17 / 20

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

18 / 20

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

19 / 20

A permanent table can have Time travel of upto 1 year?

20 / 20

The Cloud Services layer can actually consume billable compute credits?

Your score is

0%