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

Trial accounts can be converted to paid accounts?

2 / 20

Which of the below are examples of offerings Technical Partners provide?

3 / 20

Running a virtual warehouse consumes which of the below?

4 / 20

When loading files from a local filesystem using PUT the local host must have which of the below?

5 / 20

Database shares can be read write?

6 / 20

Using VALIDATION_MODE option of the COPY INTO command which of the below are valid?

7 / 20

The Time Travel feature is only available in Enterprise Edition or above?

8 / 20

A Materialised View will actually store the result set on disk separate from the underlying table data it queries?

9 / 20

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

 

10 / 20

Snowpipe requires keypair authentication using JWT?

11 / 20

Which of the below options can be used to Improve Query Performance?

12 / 20

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

13 / 20

Which options do we see on the Classic WebUI Ribbon?

14 / 20

Table Stages are created automatically by the system?

15 / 20

Streams are a form of Change Data Capture (CDC)?

16 / 20

You can use SQL ID as the basis to set the time that Time Travel will use?

17 / 20

Which information below can we view about a query that has run in the past?

18 / 20

Time Travel can only be defined and used at the Database level?

19 / 20

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

20 / 20

Micro Partitions are immutable, what does this mean?

Your score is

0%