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

Questions 16–20

1. 16expert · medium

   An administrator sets the account-level parameter TIMEZONE to 'UTC'. Then they set the user-level parameter TIMEZONE to 'America/New_York' for user Alice. Alice runs ALTER SESSION SET TIMEZONE = 'Europe/London'; in her current session. What is the effective timezone for Alice's current session?

   • A'America/New_York'
   • B'UTC'
   • C'Europe/London'
   • DThe timezone with the earliest offset.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which command is used to reset a parameter to its default value in Snowflake?

   • AUNSET
   • BRESET
   • CCLEAR
   • DDROP
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   An administrator needs to create a new user for a contractor who will only use Snowflake for a short period. The contractor should have a default role of 'CONTRACTOR' and a default warehouse of 'CONTRACTOR_WH'. The account-level default role is 'PUBLIC'. Which command should the administrator run?

   • ACREATE USER contractor DEFAULT_ROLE = CONTRACTOR DEFAULT_WAREHOUSE = CONTRACTOR_WH;
   • BALTER USER contractor SET DEFAULT_ROLE = CONTRACTOR, DEFAULT_WAREHOUSE = CONTRACTOR_WH;
   • CCREATE USER contractor WITH DEFAULT_ROLE = CONTRACTOR;
   • DCREATE USER contractor WITH DEFAULT_WAREHOUSE = CONTRACTOR_WH;
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which command is used to change an account-level parameter in Snowflake?

   • AALTER ACCOUNT SET
   • BALTER SESSION SET
   • CALTER SYSTEM SET
   • DALTER USER SET
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   An administrator sets the account-level parameter STATEMENT_TIMEOUT to 3600. Later, they set the user-level parameter STATEMENT_TIMEOUT to 1800 for user Bob. Bob then runs ALTER SESSION SET STATEMENT_TIMEOUT = 7200; in his current session. What is the effective timeout for Bob's current session?

   • A7200 seconds
   • B1800 seconds
   • C3600 seconds
   • DThe highest value among the three settings.
   Reveal Solution Discussion Select an answer first