An administrator wants to reset the account-level parameter STATEMENT_TIMEOUT to its default value. The parameter was previously set to 3600. Which command should they run?

ALTER SESSION UNSET STATEMENT_TIMEOUT;

ALTER ACCOUNT UNSET STATEMENT_TIMEOUT;

ALTER ACCOUNT SET STATEMENT_TIMEOUT = 0;

A company wants to ensure that all new sessions across the account have a default statement timeout of 5 minutes. The administrator runs: ALTER ACCOUNT SET STATEMENT_TIMEOUT = 300; However, a user reports that their session still shows a timeout of 600 seconds. What is the most likely reason?

The user's role has a higher precedence than the account-level setting.

The account-level change only applies to new sessions, and the user's session was started before the change.

The user has a user-level STATEMENT_TIMEOUT set to 600, which overrides the account-level setting.

The STATEMENT_TIMEOUT parameter cannot be set at the account level.

What is the purpose of user-level parameters in Snowflake?

To define the default warehouse for the account

To set parameters for all users in the account

To override account-level defaults for a specific user

To control the current session only

SnowPro® Core Certification

Domain 3Objective 4

Manage Users and Account Parameters COF-C03 Practice Questions (Page 3)

Part of the Account Management and Data Governance domain, which accounts for 20% of the COF-C03 exam.

21questions here

5free pages

7concepts

20%of the exam

Questions 11–15

11application · medium
An administrator wants to reset the account-level parameter STATEMENT_TIMEOUT to its default value. The parameter was previously set to 3600. Which command should they run?
Select an answer first
12foundation · easy
Which clause can be used with SHOW PARAMETERS to view parameters for a specific user?
Select an answer first
13application · medium
A company wants to ensure that all new sessions across the account have a default statement timeout of 5 minutes. The administrator runs: ALTER ACCOUNT SET STATEMENT_TIMEOUT = 300; However, a user reports that their session still shows a timeout of 600 seconds. What is the most likely reason?
Select an answer first
14foundation · easy
What is the purpose of user-level parameters in Snowflake?
Select an answer first
15foundation · easy
Which of the following is a valid property that can be set when creating a user in Snowflake?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “COF-C03” is a trademark of its owner, used for identification only.

Manage Users and Account Parameters COF-C03 Practice Questions (Page 3)

Questions 11–15

An administrator wants to reset the account-level parameter STATEMENT_TIMEOUT to its default value. The parameter was previously set to 3600. Which command should they run?

Which clause can be used with SHOW PARAMETERS to view parameters for a specific user?

A company wants to ensure that all new sessions across the account have a default statement timeout of 5 minutes. The administrator runs: ALTER ACCOUNT SET STATEMENT_TIMEOUT = 300; However, a user reports that their session still shows a timeout of 600 seconds. What is the most likely reason?

What is the purpose of user-level parameters in Snowflake?

Which of the following is a valid property that can be set when creating a user in Snowflake?

Keep studying — Account Management and Data Governance