SOL-C01 · Question #12
SOL-C01 Question #12: Real Exam Question with Answer & Explanation
The correct answer is B: Schemas are logical groupings of database objects within a database.. Schemas are logical groupings of database objects within a database, allowing for logical separation. A database can indeed contain multiple schemas. Option A is incorrect as schemas can contain stages, file formats, sequences, user-defined functions, and other objects besides ta
Question
Which of the following statements are true regarding schemas in Snowflake? (Select TWO)
Options
- AA schema can only contain tables and views.
- BSchemas are logical groupings of database objects within a database.
- CSchemas must be explicitly created using the `CREATE SCHEMA' command; Snowflake does not
- DA database can contain multiple schemas, allowing for logical separation of data and objects.
- ESchemas do not provide any security benefits; role-based access control must be configured on
Explanation
Schemas are logical groupings of database objects within a database, allowing for logical separation. A database can indeed contain multiple schemas. Option A is incorrect as schemas can contain stages, file formats, sequences, user-defined functions, and other objects besides tables and views. Option C is false since the 'PUBLIC' schema is created by default. Option E is false since schemas are also used in access control, although individual object privileges provide more granular control.
Topics
Community Discussion
No community discussion yet for this question.