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

Questions 6–10

1. 6foundation · easy

   At which level can the UNSET command be used to reset a parameter?

   • ASession level only
   • BUser level only
   • CAccount level only
   • DAccount, user, and session levels
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A data engineer is troubleshooting a query performance issue. They suspect that the session-level parameter USE_CACHED_RESULT is set to FALSE, which is causing the query to re-execute instead of using cached results. Which command should they run to confirm this?

   • ASHOW PARAMETERS LIKE 'USE_CACHED_RESULT' IN SESSION;
   • BSELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.PARAMETERS WHERE PARAMETER_NAME = 'USE_CACHED_RESULT';
   • CALTER SESSION SET USE_CACHED_RESULT = TRUE;
   • DDESCRIBE SESSION;
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   In Snowflake's parameter hierarchy, which level takes precedence over the others?

   • ASession level
   • BObject level
   • CUser level
   • DAccount level
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   An administrator sets the account-level parameter LOCK_TIMEOUT to 60. Then they set the user-level parameter LOCK_TIMEOUT to 120 for user Alice. Alice runs ALTER SESSION SET LOCK_TIMEOUT = 30; in her current session. What is the effective LOCK_TIMEOUT for Alice's current session?

   • A120 seconds
   • B60 seconds
   • C30 seconds
   • DThe average of the three values.
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   Which command is used to set a user-level parameter in Snowflake?

   • AALTER SESSION SET
   • BSET USER
   • CALTER ACCOUNT SET
   • DALTER USER SET
   Reveal Solution Discussion Select an answer first