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

A UDF function code will contain $$ only at the end to signify end of code?

2 / 20

Which of below could describe Machine Learning & Data Science?

3 / 20

Time Travel Syntax can include which of the below?

4 / 20

Network Policies can only be assigned at the Account level?

5 / 20

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

6 / 20

What icon will a secure view have by it side in the WebUI?

7 / 20

What are the types of View available in Snowflake?

8 / 20

Which best describes the public Role?

9 / 20

Which of the below can we perform on data when we LOAD into a table in Snowflake?

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

11 / 20

Trial accounts can be converted to paid accounts?

12 / 20

A Stored Procedure can only run as the owner and not the caller?

13 / 20

Stored procedures allow the execution of both DDL and DML?

14 / 20

The Metadata Cache could contain data upto 60 minutes Stale?

15 / 20

Which of the below are Scaling Policies for a Warehouse?

16 / 20

Which of the below is an example of a Solution Partners services?

17 / 20

Enabling replication designates the source database as a standby database?

18 / 20

Files hosted on external Cloud Storage can be loaded directly into Snowflake without the use of a Stage?

19 / 20

Which of the following Semi Structured formats does Snowflake support?

20 / 20

When a database is replicated to another account Snowflake encrypts its database files?

Your score is

0%