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

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

2 / 20

Which of the below are table types in Snowflake?

3 / 20

The Snowflake account URL to logon is composed of which of the below?

4 / 20

Which of the below are examples of Structured data?

5 / 20

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

6 / 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

7 / 20

A secure view allows access to tables which are owned by the accountadmin role?

8 / 20

Which of below describes workloads Snowflake can handle best?

9 / 20

What are the 2 default INBOUND shares of every account?

10 / 20

Use of the LIMIT clause can have a large positive impact on performance?

11 / 20

Having a high Time Travel setting can help reduce Storage Costs?

12 / 20

Data Consumers would create an Outbound Share?

13 / 20

What is the purpose of a Network Policy?

14 / 20

Multi Factor Authentication can be used with which of the below?

15 / 20

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

16 / 20

A Data Providers is someone who is sharing data?

17 / 20

What is the name of feature that allows Snowflake support to restore some types of table after they have been dropped and are outside the TimeTravel retention?

18 / 20

Why would we CAST data from a Variant?

19 / 20

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

20 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

Your score is

0%