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 information below can we view about a query that has run in the past?

2 / 20

User Stages do support file formats?

3 / 20

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

4 / 20

A UDF can return a set of rows (UDFT), but a stored procedure can't?

5 / 20

Stored Procedures can only be written in Python?

6 / 20

Customers can request a “Vanity” Account Logon URL?

7 / 20

Which of the below are components of ELT?

8 / 20

Which Port is used for General SnowFlake traffic?

9 / 20

By default Snowflake blacklists all IP Addresses?

10 / 20

Which of the following does Search Optimisation NOT support?

11 / 20

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

12 / 20

Snowpipe charges for compute while loading files only?

13 / 20

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

14 / 20

Pipes load data into tables continuously from an ingestion queue?

15 / 20

It is better to share an entire table rather than a Secure View?

16 / 20

Which file formats are supported for a data unload?

17 / 20

Stored procedures allow the execution of both DDL and DML?

18 / 20

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

19 / 20

A temporary table can be restored by contacting Snowflake support who will use failsafe?

20 / 20

What best defines a Securable Object?

Your score is

0%