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

In Snowflake all communication is encrypted using TLS1.2?

2 / 20

What are the types of View available in Snowflake?

3 / 20

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

4 / 20

If the Time Travel setting is reduced from 45 to 35 days, all versioned historic time travel data older than 35 days will be deleted

5 / 20

A consumer will use their own Warehouse's compute when accessing a Data Share

6 / 20

Why would we CAST data from a Variant?

7 / 20

Only Standard Views can be created as secure?

8 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

9 / 20

What type of Cloud Platform is Snowflake?

10 / 20

Which of these Cloud Providers does Snowflake support?

11 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

12 / 20

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

13 / 20

Each increase in Warehouse size i.e. from Small to Medium or Medium to larges uses a Snowflake internal logarithmic algorithm to determine the number of clusters to add?

14 / 20

Which of the below are examples of Technical Partners offerings?

15 / 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?

16 / 20

Time Travel can only be defined and used at the Database level?

17 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

18 / 20

In the WebUI if we select the Account icon on the main ribbon which options do we then see?

19 / 20

Only Snowflake Support using failsafe can restore an External Table?

20 / 20

All data in Snowflake is always protected either at rest or in transit?

Your score is

0%