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 Stored Procedure can only run as the owner and not the caller?

2 / 20

If the same query is re-run with no change in underlying data by a different user then the cached results from the previous query run are sent to that user so no Compute is used?

3 / 20

The Service Layer stores which of the below about each Micro Partition?

4 / 20

Which of the below are types of Stage in Snowflake?

5 / 20

When using a 'Group by' clause try to group on something that has many distinct values?

6 / 20

Internal Stages are managed by the Customer?

7 / 20

Standard Edition provides support for HIPAA, PCI, FedRAMP?

8 / 20

How many extra days does Failsafe provide the ability to restore data from?

9 / 20

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

10 / 20

What type of Cloud Platform is Snowflake?

11 / 20

Which role will add the 'Account' icon on the Classic WebUI ribbon?

12 / 20

How often does Snowflake rotate Encryption keys?

13 / 20

Which of below are valid Authentication methods in Snowflake?

14 / 20

Joining on non unique keys should be encouraged so data output can be as verbose as possible?

15 / 20

Resource Monitor notifications are sent to all Account Administrators?

16 / 20

We can use CIDR notation to specify a subnet range for a whitelisted network policy?

17 / 20

Using the context CURRENT_ACCOUNT() could be used to restrict data in a secure view?

18 / 20

Which of the below are default System defined roles in Snowflake?

19 / 20

Multi Factor Authentication should be enabled on users with which role?

20 / 20

Which role does a standard view execute as ?

Your score is

0%