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

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

2 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

3 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

4 / 20

Which of the below describes the Search Optimisation Service?

5 / 20

Encryption Keys are automatically rotated every 30 days?

6 / 20

Which of the below are Scaling Policies for a Warehouse?

7 / 20

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

8 / 20

What commands are used to allow or deny access on an objects to a roles?

9 / 20

When loading data from files into SnowFlake what 2 main factors may impact performance of that load?

10 / 20

What is the a name of the account type created by the provider and used by a consumer to access a Share using the providers compute?

11 / 20

Pipes contains a 'COPY INTO' statement?

12 / 20

Running a virtual warehouse consumes which of the below?

13 / 20

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

14 / 20

Automatic table Clustering can be Suspended and Resumed?

15 / 20

A transient table will be dropped when the user session that created it ends?

16 / 20

Snowflake has a grant that allows all 'Future' objects created in a schema to be granted privileges to a role Automatically?

17 / 20

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

18 / 20

Stored Procedures can only be written in Javascript?

19 / 20

What command is used to place files on a Stage from a local filesystem?

20 / 20

Which of the below are types of Warehouse?

Your score is

0%