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

Charges at the Cloud Services layers are for compute that exceeds 10% of total computes costs for the account?

2 / 20

We can use CIDR notation to specify a subnet range for a whitelisted network policy?

3 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

4 / 20

Pipes load data into tables continuously from an ingestion queue?

5 / 20

Tasks can execute multiple DML statements?

6 / 20

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

7 / 20

Search Optimisation Services can help improve the performance of highly selective lookup queries?

8 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

9 / 20

Which function can assist with reading data from a Variant datatype with nested elements?

10 / 20

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

11 / 20

What best defines a Securable Object?

12 / 20

Which of the below is the smallest Size Warehouse that can be configured?

13 / 20

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

14 / 20

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

15 / 20

Which pipes are cloned with Zero Copy Cloning?

16 / 20

Which of the below could we use to describe a Stream?

17 / 20

Which of these Cloud Providers does Snowflake support?

18 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

19 / 20

The SNOWFLAKE Account Usage Share contains information about a users account like query history?

20 / 20

Storage is billed as uncompressed data?

Your score is

0%