Snowflake Knowledge check Quiz

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

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

True

False

2 / 20

It is for the customer to manage the Snowflake Object Storage used for the database tables by working with the Cloud provider such as AWS?

False

True

3 / 20

Which of the below options of the COPY INTO command can be used with ON_ERROR?

ABORT_STATEMENT

CONTINUE

SKIP_FILE

SKIP_FILE_%

4 / 20

Which of the below COPY INTO options are related to data length?

TRUNCATECOLUMNS

MAXCOLSIZE

MAX_COL_SIZE

ENFORCE_LENGTH

5 / 20

Every active user session has a current role?

True

False

6 / 20

Which of these is not a database object in Snowflake?

Type

Table

Secure View

Sequence

7 / 20

Every new database created contains 2 schemas what are these called?

PRIVATE

METADATA_SCHEMA

PUBLIC

INFORMATION_SCHEMA

8 / 20

Which of the below describes Data Sharing in Snowflake?

Data Sharing will duplicate data and increase the storage needed

Data Sharing will not duplicate data , so no impact on the storage needed

A large database shared will have a no impact on Storage costs

A large database shared could have a huge impact on Storage costs

9 / 20

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

AWS

Programmatic Interfaces

Database Engines

Advanced Analytics

10 / 20

Only Enterprise Edition and above can create a Data Share?

True

False

11 / 20

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

True

False

12 / 20

When a task is created it is initially suspended?

False

True

13 / 20

Which Port is used for General SnowFlake traffic?

22

1521

8080

443

14 / 20

How Long does a Snowpipe retain load history?

31 days

14 days

1 day

7 days

15 / 20

Which best describes the securityadmin Role?

Role privileges to create warehouses and databases

Role that can manage any object grant globally

Top level role in the system

Pseudo role that is automatically granted to every user

16 / 20

Which best describes the public Role?

Role dedicated to user and role management only

Pseudo role that is automatically granted to every user

Top-level role in the system

Role privileges to create warehouses and databases

17 / 20

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

False

True

18 / 20

What icon will a secure view have by it side in the WebUI?

padlock

none its shown the same as a standard view

shield

cage

19 / 20

A Encryption Key can be in a state of Retired?

True

False

20 / 20

A Resource Monitor consists of which of the following properties?

Actions

Monitor Level

Credit Quota

A SQL query or Stored Proc to run to monitor the resource usage

Your score is

0%

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.