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

Shared Data is always upto date?

2 / 20

Once a database is created, we can not transfer ownership of that database to another Role without recreating it?

3 / 20

Within a stored procedure argument names are case-insensitive in the JavaScript portion of the stored procedure?

4 / 20

Partner Connect can be described as technology partners that have joined with Snowflake to create an in-account Snowflake wizard?

5 / 20

Snowflake has a grant that allows all 'Future' objects created in a schema to be granted privileges to a role Automatically?

6 / 20

What is Snowsight?

7 / 20

What are the types of Caching available in Snowflake?

8 / 20

What does Tri Secret Secure mean?

9 / 20

Which of these describes a role?

10 / 20

For a warehouse if MAX Clusters = 1 then we have a scale out Multi-Cluster setup?

11 / 20

Wild card predicate using

LIKE '%string%'

will encourage partition pruning?

12 / 20

Snowflake Multi Factor Authentication makes use of DUO?

13 / 20

Which of the below describes the Search Optimisation Service?

14 / 20

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

15 / 20

Which of the following Semi Structured formats does Snowflake support?

16 / 20

Snowflake uses natural clustering to co-locate similar column value data ranges?

17 / 20

The is a limit of 10 on the number of data shares a consumer can utilise?

18 / 20

Storage is billed as uncompressed data?

19 / 20

Zero Copy Cloning allows which of below?

20 / 20

Data can be loaded as a Join from 2 files into Snowflake?

Your score is

0%