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

Storage is billed as uncompressed data?

2 / 20

Which Data type is great for storing semi-structured data?

3 / 20

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

4 / 20

Files uploaded to staging area using PUT are auto encrypted?

5 / 20

'WAREHOUSE_METERING_HISTORY' view shows how much cloud service compute an account has used?

6 / 20

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

7 / 20

Snowpipe loads are combined or split into multiple transactions based on number/size of rows per datafile?

8 / 20

Enabling replication designates the source database as a standby database?

9 / 20

Snowflakes uses table row format to store data in micro partitions?

10 / 20

In a  'managed access' schema, what would allow the granting of a object privilege within that schema?

11 / 20

How many Accounts can a customer own?

12 / 20

Which pipes are cloned with Zero Copy Cloning?

13 / 20

Which of the below are types of Warehouse?

14 / 20

In Snowflake all communication is encrypted using TLS1.2?

15 / 20

Shared Data is always upto date?

16 / 20

Charges at the Cloud Services layers are for compute that exceeds 10% of total computes costs for the account?

17 / 20

A Stage is used to load or unload data in Snowflake?

18 / 20

Which of the below Roles has the privilege to define Network Policies?

19 / 20

Secure Views and UDFs, bypass optimisations to protect data?

20 / 20

A transient table will be dropped when the user session that created it ends?

Your score is

0%