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

Customers can request a “Vanity” Account Logon URL?

2 / 20

What type of Cloud Platform is Snowflake?

3 / 20

Which function can assist with reading data from a Variant datatype with nested elements?

4 / 20

We use the 'COPY INTO' clause to ingest files into a table?

5 / 20

Columnar data storage benefits from more efficient compression ratio's

6 / 20

Which of the below best describes Snowflake Architecture?

7 / 20

Which best describes the securityadmin Role?

8 / 20

A multi Cluster warehouse setup may be beneficial for lots of concurrent users and queries?

9 / 20

What does Tri Secret Secure mean?

10 / 20

Pipes load data into tables continuously from an ingestion queue?

11 / 20

Stored procedures allow the execution of both DDL and DML?

12 / 20

Snowflake Data protection features include which of the below?

13 / 20

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

14 / 20

Which of below are valid Authentication methods in Snowflake?

15 / 20

We should Organise data being loaded into logical paths like by date, to better aid co-locating that data in the same micro partition?

16 / 20

Which file formats are supported for a data unload?

17 / 20

Only the Snowflake Support can perform data restores using  FailSafe?

18 / 20

Use of the ORDER BY clause on large datasets can consume vast amounts of Memory and Compute?

19 / 20

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

20 / 20

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

Your score is

0%