SQL Account & Session DDK

Question 1

ALTER ACCOUNT

Answer 1

Modifies an account.

Question 2

ALTER CONNECTION

Answer 2

Modifies the properties for an existing connection.

Question 3

ALTER FAILOVER GROUP

Answer 3

Modifies the properties for an existingfailover group.

Question 4

ALTER REPLICATION GROUP

Answer 4

Modifies the properties for an existingreplication group.

Question 5

ALTER SESSION

Answer 5

Sets parameters that change the behavior for the current session.

Question 6

CREATE ACCOUNT

Answer 6

Creates a new account in your organization.

Question 7

CREATE CONNECTION

Answer 7

Creates a new connection in the account.

Question 8

CREATE FAILOVER GROUP

Answer 8

Creates a new failover group of specified objects in the system.

Question 9

CREATE MANAGED ACCOUNT

Answer 9

Creates a new managed account.

Question 10

CREATE REPLICATION GROUP

Answer 10

Creates a new replication group of specified objects in the system.

Question 11

DESCRIBE RESULT

Answer 11

Describes the columns in the result of a query.

Question 12

DESCRIBE TRANSACTION

Answer 12

Describes thetransaction, including the start time and the state (running, committed, rolled back).

Question 13

DROP CONNECTION

Answer 13

Removes a connection from the account.

Question 14

DROP FAILOVER GROUP

Answer 14

Removes a failover group from the account.

Question 15

DROP MANAGED ACCOUNT

Answer 15

Removes a managed account, including all objects created in the account, and immediately restricts access to the account.

Question 16

DROP REPLICATION GROUP

Answer 16

Removes areplication groupfrom the account.

Question 17

SET

Answer 17

Initializes the value of asession variableto the result of a SQL expression.

Question 18

SHOW CONNECTIONS

Answer 18

Lists the connections for which you have access privileges.

Question 19

SHOW DATABASES IN FAILOVER GROUP

Answer 19

Lists databases in a failover group.

Question 20

SHOW DATABASES IN REPLICATION GROUP

Answer 20

Lists databases in a replication group.

Question 21

SHOW FAILOVER GROUPS

Answer 21

Lists each primary or secondary failover group in this account.

Question 22

SHOW FUNCTIONS

Answer 22

Lists all the native (i.e. system-defined/built-in) scalar functions provided by Snowflake, as well as any user-defined functions (UDFs) or external functions that have been created for your account.

Question 23

SHOW GLOBAL ACCOUNTS

Answer 23

Lists all the accounts in your organization that are enabled for replication and indicates the Snowflake Region in which each account is located.

Question 24

SHOW MANAGED ACCOUNTS

Answer 24

Lists the managed accounts created for your account.

Question 25

SHOW ORGANIZATION ACCOUNTS

Answer 25

Lists all the accounts in your organization, excluding managed accounts.

Question 26

SHOW PARAMETERS

Answer 26

Lists all the account, session, and object parameters that can be set, as well as the current and default values for each parameter.

Question 27

SHOW REGIONS

Answer 27

Lists all the regions in which accounts can be created.

Question 28

SHOW REPLICATION ACCOUNTS

Answer 28

Lists all the accounts in your organization that are enabled for replication and indicates the region in which each account is located.

Question 29

SHOW REPLICATION DATABASES

Answer 29

Lists all the primary and secondary databases (i.e. all databases for which replication has been enabled) in your organization and indicates the region in which each account is located.

Question 30

SHOW REPLICATION GROUPS

Answer 30

Lists each primary or secondary replication or failover group in this account.

Question 31

SHOW SHARES IN FAILOVER GROUP

Answer 31

Lists shares in a failover group.

Question 32

SHOW SHARES IN REPLICATION GROUP

Answer 32

Lists shares in a replication group.

Question 33

SHOW VARIABLES

Answer 33

Lists all variables defined in the current session.

Question 34

UNSET

Answer 34

Drops a session variable.