Parameters

Question 1

What are the different types of parameters

Answer 1

Account, Session, object

Question 2

Where can account params be set

Answer 2

Account level only

Question 3

Who can set account level params

Answer 3

Users with the appropriate admin role

Question 4

What command sets account level params

Answer 4

Alter Account

Question 5

Most params are what

Answer 5

Session params

Question 6

How does an account admin set session permissions at the account level

Answer 6

Alter Account SET ….

Question 7

What does it mean to set session permissions at the account level

Answer 7

set default for individual users and their sessions

Question 8

What level overrides session permissions at the account level

Answer 8

User

Question 9

What command sets session permissions at the user level

Answer 9

Alter User – done by admin with appropriate permissions, typically SECURITYADMIN

Question 10

What does it mean to set session permissions at the user level

Answer 10

sets default for any session started by the user

Question 11

Can users override their session permissions set at the user level

Answer 11

yes, by using Alter User

Question 12

What level overrides permissions at the user level

Answer 12

Session

Question 13

What command is used to set session permissions at the session level

Answer 13

Alter Session

Question 14

What does it mean to set session permission at the session level

Answer 14

sets session params with the user’s session

Question 15

What command sets object permissions on the account level

Answer 15

Alter Account

Question 16

What does it mean to set object permissions at the account level

Answer 16

Default to individual users and their sessions

Question 17

What level overrides the object permissions at the account level

Answer 17

User

Question 18

What are the objects at the object level

Answer 18

Warehouse, database, schema, Table/pipe, etc

Question 19

What is the hierarchy of objects at the object level

Answer 19

Table/pipe > Schema > Database

Question 20

What are the commands to override params for an individual object

Answer 20

Create “object-name”
Alter “object-name”

Question 21

What does the SHOW PARAMETERS command do

Answer 21

displays a list of parameters, along with the current and default values

Question 22

What type of parameters are shown by SHOW PARAMETERS by default

Answer 22

Session only

Question 23

What is the command to show parameters for a specific object

Answer 23

show parameters in database “database-name”
show parameters in warehouse “warehouse-name”

Question 24

What command shows all parameters including account and object parameters

Answer 24

show parameters in account

Question 25

How do you filter parameters by name

Answer 25

show parameters like ‘%time%’
show parameters like ‘%time%’ in account