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

You can use SQL ID as the basis to set the time that Time Travel will use?

2 / 20

There is no limit on the number of Data Shares a Provider can provision?

3 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

4 / 20

Which of the below are attributes of a secure view?

5 / 20

DATA_RETENTION_TIME_IN_SECONDS is used to define the Time Travel duration?

6 / 20

How many extra days does Failsafe provide the ability to restore data from?

7 / 20

Which of the following does Search Optimisation NOT support?

8 / 20

What is Snowsight?

9 / 20

Every active user session has a current role?

10 / 20

Which best describes the securityadmin Role?

11 / 20

Which file formats are supported for a data unload?

12 / 20

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

13 / 20

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

14 / 20

Trial accounts can be converted to paid accounts?

15 / 20

Natural table Clustering can not be overridden?

16 / 20

By default Snowflake blacklists all IP Addresses?

17 / 20

Database Replication is only supported across the Same Cloud provider i.e. AWS to AWS as the source but to a different or the same region?

18 / 20

For each securable object, there is a set of privileges that can be granted on it?

19 / 20

Micro Partitions are immutable, what does this mean?

20 / 20

Zero Copy Cloning allows which of below?

Your score is

0%