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 pipes are cloned with Zero Copy Cloning?

2 / 20

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

3 / 20

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

4 / 20

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

5 / 20

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

6 / 20

Multi Factor Authentication should be enabled on users with which role?

7 / 20

UDF code contains $$ to signify this could double the compute power costs to run the code?

8 / 20

Pipes contains a 'COPY INTO' statement?

9 / 20

The Cloud Services layer can actually consume billable compute credits?

10 / 20

What are the 2 types of Stage in Snowflake?

11 / 20

Discretionary Control is where each Securable Object has many Owners who can't grant others access?

12 / 20

Which of these Cloud Providers does Snowflake support?

13 / 20

The best way to choose the right Warehouse size is to?

14 / 20

The phase 'Scale Out' with regard to Snowflakes means to add more clusters?

15 / 20

Which of the below COPY INTO options are related to data length?

16 / 20

Which of below are valid Authentication methods in Snowflake?

17 / 20

We use the 'COPY INTO' clause to ingest files into a table?

18 / 20

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

19 / 20

COPY INTO Loads are performed as single transaction?

20 / 20

Files uploaded to staging area using PUT are auto encrypted?

Your score is

0%