SOL-C01 Question #57: Real Exam Question with Answer & Explanation

Question

You have been tasked with configuring a session parameter for all users connecting to a specific Snowflake database named REPORTING DB'. You want to set the 'TIMEZONE parameter to 'America/Los_Angeles' for all sessions within this database. Which of the following SQL statements would BEST accomplish this?

Options

• AALTER SESSION SET TIMEZONE = 'America/Los_Angeles';
• BALTER ACCOUNT SET TIMEZONE = 'America/Los_Angeles';
• CALTER USER SET TIMEZONE = 'America/Los_Angeles';
• DALTER DATABASE REPORTING_DB SET TIMEZONE = 'America/Los_Angeles';
• EALTER WAREHOUSE SET TIMEZONE = 'America/Los_Angeles';

Explanation

The 'ALTER DATABASE command allows you to set parameters at the database level, which will affect all sessions connected to that database. 'ALTER SESSION' only affects the current session. `ALTER ACCOUNT affects the entire Snowflake account. 'ALTER USER affects only a specific user and 'ALTER WAREHOUSE affects only a specific warehouse.

No community discussion yet for this question.