Snowpro Associate Platform · Free Practice Question Easy
Question 16
- A To modify the schema structure in a session
- B To set the current schema for a session
- C To create a new schema in a database
- D To take ownership of an existing schema
Reveal correct answer
Correct answer: B
Explanation
✅ To set the current schema for a session
Explanation:
The USE SCHEMA command in Snowflake is used to set the active schema for the current session. Once set, any unqualified object names (like SELECT * FROM my_table) will be resolved within that schema, simplifying queries and operations. It’s a way to define the default context for database interactions during a session.
❌ Why the other options are incorrect?
To create a new schema in a database → Incorrect, as that requires the
CREATE SCHEMAcommand.To take ownership of an existing schema → Incorrect, since ownership changes are handled via
GRANT OWNERSHIP.To modify the schema structure in a session → Incorrect, because schema structure changes involve DDL commands like
ALTER SCHEMA, notUSE SCHEMA.
You can explore examples and syntax in Snowflake’s official documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
