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

Which best describes the securityadmin Role?

2 / 20

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

3 / 20

Natural table Clustering can not be overridden?

4 / 20

Time Travel is only used to restore a table you can't use it to query a table at a point in the past?

5 / 20

During data Unload we cannot use a SQL query to target the data to extract?

6 / 20

Which of these Cloud Providers does Snowflake support?

7 / 20

What are the 2 types of Stage in Snowflake?

8 / 20

Snowflake Multi Factor Authentication makes use of DUO?

9 / 20

Micro Partitions are created based on ingestion order of data within files to be loaded?

10 / 20

Which of the below are Scaling Policies for a Warehouse?

11 / 20

Running a virtual warehouse consumes which of the below?

12 / 20

User Stages do support file formats?

13 / 20

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

14 / 20

What format does Snowflake store its data?

15 / 20

The Service Layer stores which of the below about each Micro Partition?

16 / 20

Which of below are NOT valid Snowflake Editions?

17 / 20

Its possible to kill a running query from the WebUI using 'Abort'

18 / 20

Database Replication can be enabled for any existing permanent or transient database?

19 / 20

Which of the below are table types in Snowflake?

20 / 20

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

Your score is

0%