Question 1
What are characteristics of schemas in Snowflake? (Choose two.)
- A schema is contained in a database.
- A schema is an immutable object.
- Each schema is available to a single role.
- Schemas are used to organize database objects.
- Schemas contain virtual warehouses.
Question 2
Which data type is recommended to store a true or false value in Snowflake?
- BLOB
- INTEGER
- BOOLEAN
- NUMBER
Question 3
Which parts of the Snowflake environment are separated so that resources can be scaled as needed?
- Compute and virtual warehouse
- Storage and compute
- Database and schema
- Database and storage
Question 4
Which column is returned when the FLATTEN table function is executed?
- LEVEL
- VALUE
- ROWNUM
- OUTPUT
Question 5
What data type is recommended for storing a large text string in Snowflake?
- OBJECT
- ARRAY
- VARCHAR
- BOOLEAN