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

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

2 / 20

Only a table can be created as transient?

3 / 20

Snowflake Data protection features include which of the below?

4 / 20

Data Consumers would create an Outbound Share?

5 / 20

Which of the below are true of the Optimise Service?

6 / 20

Snowflake Streams hold no data?

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

8 / 20

Which of the following Semi Structured formats does Snowflake support?

9 / 20

Stored procedures allow the execution of both DDL and DML?

10 / 20

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

11 / 20

Which of the below entities are not part of a Snowflake database?

12 / 20

Snowflake customers can save money if they purchase a fixed amount of storage upfront rather than pay on demand?

13 / 20

Which role does a standard view execute as ?

14 / 20

External Stages are managed by the Customer?

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

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

17 / 20

Which of the below options can be used to Improve Query Performance?

18 / 20

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

19 / 20

Network Policies can only be assigned at the Account level?

20 / 20

Pipes load data into tables continuously from an ingestion queue?

Your score is

0%