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

Questions 1–5

1. 1foundation · easy

   If a parameter is set at the account level and also at the user level, which value will be used for that user's session?

   • AThe account-level value
   • BThe default value
   • CThe user-level value
   • DThe session-level value
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

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

   • AALTER ACCOUNT SET
   • BSET SESSION
   • CALTER SESSION SET
   • DALTER USER SET
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which SQL command is used to create a new user in Snowflake?

   • ACREATE USER
   • BCREATE LOGIN
   • CNEW USER
   • DADD USER
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which command is used to view the current values of parameters in Snowflake?

   • ASELECT PARAMETERS
   • BDESCRIBE PARAMETERS
   • CLIST PARAMETERS
   • DSHOW PARAMETERS
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A user, Alex, has a user-level setting for the parameter QUERY_TAG that was set to 'batch'. The administrator wants Alex's sessions to use the account-level default, which is NULL. Which command should the administrator run?

   • AALTER SESSION UNSET QUERY_TAG;
   • BALTER USER alex SET QUERY_TAG = NULL;
   • CALTER ACCOUNT UNSET QUERY_TAG;
   • DALTER USER alex UNSET QUERY_TAG;
   Reveal Solution Discussion Select an answer first