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

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

2 / 20

If we define a Clustering Key Snowflakes keeps the clustering order updated in background and the user is charged for this service?

3 / 20

Snowpipe partially loaded files (based on ON_ERROR) can be combined/split into more transactions?

4 / 20

How many minute will the Economy Scaling policy keep queries queued before starting a new Warehouse?

5 / 20

Which of these is NOT a recognised data workload genre?

6 / 20

Which of below describes workloads Snowflake can handle best?

7 / 20

Which best describes the accountadmin Role?

8 / 20

When transferring a file from local storage using PUT to a Stage, where is the compression performed?

9 / 20

Which role does a standard view execute as ?

10 / 20

What is Snowsight?

11 / 20

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

12 / 20

Database Replication to Accounts on Lower Editions is possible but only if we use 'IGNORE EDITION CHECK clause' ?

13 / 20

How many days Time Travel does Standard Edition Provide?

14 / 20

Snowflake data is automatically replicated across how many Availability Zones (Data Centres)?

15 / 20

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

16 / 20

Which of the below are valid services managed by the Service Layer?

 

17 / 20

The Cloud Services layer can actually consume billable compute credits?

18 / 20

Files uploaded to staging area using PUT are auto encrypted?

19 / 20

Only a table has a encryption key not a micro partition?

20 / 20

Using COPY INTO, the FILE FORMAT must be specified unless we have a FILE FORMAT attached to the table or stage?

Your score is

0%