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

Data Consumers would create an Outbound Share?

2 / 20

What best defines a Securable Object?

3 / 20

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

4 / 20

A warehouse can be set to 'autosuspend' if idle for a specified amount of time?

5 / 20

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

6 / 20

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

7 / 20

Federated Authentication is not possible in Snowflake?

8 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

9 / 20

In Snowflake all communication is encrypted using TLS1.2?

10 / 20

Table Stages are created automatically by the system?

11 / 20

'WAREHOUSE_METERING_HISTORY' view shows how much cloud service compute an account has used?

12 / 20

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

13 / 20

Which of the below are examples of Security and governance tools?

14 / 20

All tables are natural Clustered based on data ingestion order?

15 / 20

An example of a Resource Manager action could be  suspending a Virtual Warehouse?

16 / 20

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

17 / 20

Which edition of Snowflake is HIPPA Support and PCI Compliance introduced?

18 / 20

Which of the below Roles has the privilege to define Network Policies?

19 / 20

Which Data type is great for storing semi-structured data?

20 / 20

Files uploaded to staging area using PUT are auto encrypted?

Your score is

0%


Leave a Reply 0

Your email address will not be published. Required fields are marked *