Level 5: Container Hierarchy

Question 1

Which of these are Snowflake table types?

Answer 1

Permanent
External
Temporary
Transient

Question 2

Which of the following are Snowflake view types?

Answer 2

Secure
Standard
Materialized

Question 3

What are the three Snowflake Stage types?

Answer 3

User
Table
Named

Question 4

Named stages come in two varieties, what are they?

Answer 4

Internal
External

Question 5

Which type of view is most like a table?

Answer 5

Materialized

Question 6

Which type of view has an extra layer of protection to hide the SQL code from unauthorized viewing?

Answer 6

Secure

Question 7

In a Snowflake account named MX43210, you need to set a user’s default namespace to a database called MYDB and the PUBLIC schema. Which of the following commands would you use?

Answer 7

set default_namespace = mydb.public

Question 8

Which statements are true about the Snowflake container hierarchy? Select all that apply

Answer 8

Accounts contain databases which contain schemas.
Schemas contain tables as well as views

Question 9

In the Snowflake container hierarchy, what container is represented as a URL (for example: https://HJ54364.snowflakecomputing.com)?

Answer 9

Account

Question 10

Fail-Safe is a seven-day history of data and is automatically available on which table types?

Answer 10

Permanent

Question 11

Each Snowflake account comes with two shared databases. One is a set of sample data and the other contains Account Usage information. Check all true statements about these shared databases.

Answer 11

SNOWFLAKE contains a schema called ACCOUNT_USAGE
SNOWFLAKE_SAMPLE_DATA contains several schemas from TPC (tpc.org)
ACCOUNT USAGE is a schema filled with secure views

Question 12

Which of the following statements are true about Fail-safe?

Answer 12

Only a Snowflake employee can recover data from Fail-safe storage.
The data stored as part of Fail-safe is part of storage costs charged to customers

Question 13

Time travel is available for which table types?

Answer 13

Permanent
Temporary
Transient

Question 14

Which types of stages are automatically available in Snowflake and do not need to be created or configured?

Answer 14

User
Table

Question 15

Which table type disappears after the close of the session and therefore has no Fail-safe, and no Time Travel options after the close of the session?

Answer 15

Temporary

Question 16

You set up a Snowflake account, choosing AWS as your cloud platform provider. What stages can you use to load data files?

Answer 16

USER
TABLE
NAMED INTERNAL
NAMED EXTERNAL - using S3 Buckets
NAMED EXTERNAL - using Azure BLOB storage
NAMED EXTERNAL - using GCS/GCP Buckets

Question 17

Which of the following object types are stored within schemas?

Answer 17

Stages
File Formats
Sequences
Stored Procedures
User Defined Functions