D- SNOWFLAKE LEVEL UP STEP 5 QUESTIONS AND ANSWERS

D- SNOWFLAKE LEVEL UP STEP 5
QUESTIONS AND ANSWERS


Which four types of Snowflake tables are there? - ANSWER External
Temporary Permanent

Temporary

Which of these describes a snowflake view?
Safe
Materialized Permanent External Standard
ANSWER Secure Standard Materialized Transient

Which three sorts of Snowflake Stages are there?
ANSWER User Table Named - Secure Permanent User Materialized Table
Named

There are two types of named stages. Which are they? Internal and External
Responses

What kind of view most closely resembles a table? The Answer Achieved

Which kind of view offers an additional security feature to prevent unauthorized
people from seeing the SQL code? ANSWER Secure

You must specify a user's default namespace in a Snowflake account with the
name MX43210 to a database called MYDB and the PUBLIC schema. Which
command would you use from the list below? Setting default_namespace =
mydb.public is the answer.

Choose every claim on the Snowflake container hierarchy that is accurate:
1. Schemas are contained in databases that are part of accounts.
2. Databases, which include tables, are contained in schemas.
3. Schemas include both views and tables.
4. Users in databases are composed of roles.