Multi-account and organization management in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new Snowflake organization.

Snowflake

CREATE ORGANIZATION [1];

Drag options to blanks, or click blank then click option'

ADATABASE

BCREATE

CACCOUNT

Dmy_org

Attempts:

3 left

💡 Hint

Common Mistakes

Using keywords like CREATE or ACCOUNT instead of the organization name.

Leaving the blank empty.

The CREATE ORGANIZATION command requires the name of the organization to create.

2fill in blank

medium

Complete the code to add an account to an existing organization.

Snowflake

ALTER ORGANIZATION my_org ADD ACCOUNT [1];

Drag options to blanks, or click blank then click option'

ADROP

BCREATE

Caccount_123

DDATABASE

Attempts:

3 left

💡 Hint

Common Mistakes

Using keywords like CREATE or DROP instead of an account name.

Using database names instead of account names.

The ADD ACCOUNT command requires the account identifier to add to the organization.

3fill in blank

hard

Fix the error in the code to remove an account from an organization.

Snowflake

ALTER ORGANIZATION my_org [1] ACCOUNT account_123;

Drag options to blanks, or click blank then click option'

AADD

BDROP

CREMOVE

DCREATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using ADD or REMOVE which are invalid in this context.

Using CREATE which is for creating new objects.

To remove an account from an organization, use the DROP ACCOUNT command.

4fill in blank

hard

Fill both blanks to list all accounts in an organization with their status.

Snowflake

SHOW [1] IN ORGANIZATION my_org WHERE status [2] 'ACTIVE';

Drag options to blanks, or click blank then click option'

AACCOUNTS

BDATABASES

C=

D!=

Attempts:

3 left

💡 Hint

Common Mistakes

Using DATABASES instead of ACCOUNTS.

Using != instead of = for filtering active accounts.

The SHOW ACCOUNTS command lists accounts, and the filter uses = to match active status.

5fill in blank

hard

Fill all three blanks to create a new account in an organization with a specific edition and region.

Snowflake

CREATE ACCOUNT [1] IN ORGANIZATION my_org SET EDITION = '[2]', REGION = '[3]';

Drag options to blanks, or click blank then click option'

Anew_account

BENTERPRISE

CUS_WEST

DSTANDARD

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up edition and region values.

Using ENTERPRISE edition when STANDARD is expected.

Using invalid region names.

The account name goes first, then the edition (STANDARD), and the region (US_WEST) specifies where the account is created.