Reader accounts for non-Snowflake users - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a reader account for a non-Snowflake user.

Snowflake

CREATE READER ACCOUNT [1] FOR SHARE my_share;

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

Amy_schema

Bmy_database

Cmy_reader_account

Dmy_user

Attempts:

3 left

💡 Hint

Common Mistakes

Using database or schema names instead of the reader account name.

Omitting the reader account name.

The reader account name must be specified after CREATE READER ACCOUNT to create it properly.

2fill in blank

medium

Complete the code to grant usage on the share to the reader account.

Snowflake

GRANT USAGE ON SHARE my_share TO READER ACCOUNT [1];

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

Amy_database

Bmy_user

Cmy_schema

Dmy_reader_account

Attempts:

3 left

💡 Hint

Common Mistakes

Granting usage to database or schema names instead of the reader account.

Using a user name instead of the reader account.

You must grant usage on the share to the reader account name to allow access.

3fill in blank

hard

Fix the error in the code to create a reader account with the correct syntax.

Snowflake

CREATE READER ACCOUNT [1] SHARE my_share;

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

AFOR

BON

CWITH

DTO

Attempts:

3 left

💡 Hint

Common Mistakes

Using ON or TO instead of FOR in the CREATE READER ACCOUNT statement.

Omitting the keyword before the share name.

The correct syntax uses FOR before the share name when creating a reader account.

4fill in blank

hard

Fill both blanks to set the reader account's region and cloud provider.

Snowflake

CREATE READER ACCOUNT my_reader_account WITH REGION = '[1]' CLOUD_PROVIDER = '[2]' FOR SHARE my_share;

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

Aus-west-2

Bus-east-1

CAWS

DGCP

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing cloud providers and regions incorrectly.

Using invalid region names.

The region is set to 'us-east-1' and the cloud provider to 'AWS' in this example.

5fill in blank

hard

Fill all three blanks to create a reader account with a comment and enable replication.

Snowflake

CREATE READER ACCOUNT [1] WITH COMMENT = '[2]' REPLICATION = [3] FOR SHARE my_share;

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

Amy_reader_account

BReader account for partner

CTRUE

DFALSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using FALSE instead of TRUE for replication when it should be enabled.

Omitting the comment or using invalid syntax.

The reader account name, comment, and replication enabled (TRUE) are set correctly.