Snowflake SnowPro Associate Platform SOL-C01 - SnowPro Associate Platform SOL-C01 Exam
Page: 1 / 13
Total 65 questions
Question #1 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
What are characteristics of schemas in Snowflake? (Choose two.)
A. A schema is contained in a database.
B. A schema is an immutable object.
C. Each schema is available to a single role.
D. Schemas are used to organize database objects.
E. Schemas contain virtual warehouses.
Answer: AD
Question #2 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
Which data type is recommended to store a true or false value in Snowflake?
A. BLOB
B. INTEGER
C. BOOLEAN
D. NUMBER
Answer: C
Question #3 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
Which parts of the Snowflake environment are separated so that resources can be scaled as needed?
A. Compute and virtual warehouse
B. Storage and compute
C. Database and schema
D. Database and storage
Answer: B
Question #4 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
Which column is returned when the FLATTEN table function is executed?
A. LEVEL
B. VALUE
C. ROWNUM
D. OUTPUT
Answer: B
Question #5 (Topic: Topic 1, Interacting with Snowflake and the Architecture
)
What data type is recommended for storing a large text string in Snowflake?
A. OBJECT
B. ARRAY
C. VARCHAR
D. BOOLEAN
Answer: C
