SOL-C01 · Question #279
SOL-C01 Question #279: Real Exam Question with Answer & Explanation
The correct answer is A: A database must be created before any schemas can be created within it.. 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 databa
Question
Which of the following statements about creating databases and schemas in Snowflake are TRUE? (Select TWO)
Options
- AA database must be created before any schemas can be created within it.
- BA schema can be created without specifying a database if the current session's context is set to a
- CThe 'CREATE OR REPLACE DATABASE command allows you to change the edition of
- DSchemas are optional and not required to organize objects within a database.
- EA database can contain multiple schemas, each serving as a logical grouping of database objects.
Explanation
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.
Topics
Community Discussion
No community discussion yet for this question.