Exam SOL-C01 Topic 1 Question 312 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 312
Topic #: 1

Which of the following statements about creating databases and schemas in Snowflake are TRUE? (Select TWO)

A. A database must be created before any schemas can be created within it. B. A schema can be created without specifying a database if the current session's context is set to a specific database. C. The 'CREATE OR REPLACE DATABASE command allows you to change the edition of Snowflake being used. D. Schemas are optional and not required to organize objects within a database. E. A database can contain multiple schemas, each serving as a logical grouping of database objects.

Suggested Answer: A,E Vote an answer

Option A is correct because a database serves as the top-level container for all other objects, including schemas. Option E is correct because schemas are used to logically organize database objects. Option B is incorrect, though schemas can be created without specifying a database when the database is specified in context. Option C is incorrect because 'CREATE OR REPLACE DATABASE is for replacing existing databases, not changing the Snowflake edition. Option D is incorrect because schemas are required to organize objects.

by Marcus at Nov 24, 2025, 08:34 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business