What are the three types of parameters in Snowflake?

• A. Account Parameters; Session Parameters; Object Parameters
• B. Account Parameters; Object Parameters; User Parameters
• C. System Parameters; Session Parameters; Object Parameters
• D. Account Parameters; Session Parameters; System Parameters

Answer: (A)

Snowflake configurations are organized by three scopes: account, session, and object. The account scope sets defaults that apply across the entire account and is managed by admins. The session scope affects only your current login session and overrides account defaults for that session, resetting when the session ends. The object scope attaches settings to a specific database, schema, warehouse, or other object, allowing you to tailor behavior for that particular object without changing others.

This combination—Account Parameters, Session Parameters, and Object Parameters—is why the correct choice lists those three. Choices that introduce User Parameters or System Parameters don’t align with Snowflake’s established parameter scopes, so they aren’t the standard categories you configure. In practice, you might use a session parameter to set your time zone for a session, or apply an object parameter on a database to control retention or behavior for that database, or set account parameters to enforce a policy across the whole account.