Data classification and tagging in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a tag named 'Confidentiality'.

Snowflake

CREATE TAG [1];

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

AConfidentiality

BDataClassification

CSecurityLevel

DAccessControl

Attempts:

3 left

💡 Hint

Common Mistakes

Using spaces or special characters in the tag name.

Forgetting to use CREATE TAG command.

The tag name 'Confidentiality' is created using the CREATE TAG command.

2fill in blank

medium

Complete the code to assign the tag 'Confidentiality' with value 'High' to the table 'CustomerData'.

Snowflake

ALTER TABLE CustomerData SET TAG [1] = 'High';

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

ASecurityLevel

BConfidentiality

CDataSensitivity

DAccessLevel

Attempts:

3 left

💡 Hint

Common Mistakes

Using a tag name that was not created.

Incorrect syntax for setting a tag.

The tag 'Confidentiality' is assigned to the table using SET TAG syntax.

3fill in blank

hard

Fix the error in the code to correctly assign the tag 'Confidentiality' with value 'Medium' to the column 'email' in table 'Users'.

Snowflake

ALTER TABLE Users ALTER COLUMN email SET TAG [1] = 'Medium';

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

ASecurityTag

BDataClassification

CPrivacyLevel

DConfidentiality

Attempts:

3 left

💡 Hint

Common Mistakes

Using a tag name that does not exist.

Incorrect ALTER COLUMN syntax.

The correct tag name 'Confidentiality' must be used to assign the tag to the column.

4fill in blank

hard

Fill both blanks to create a tag named 'RetentionPeriod' and assign it the value '7 years' on the table 'Orders'.

Snowflake

CREATE TAG [1];
ALTER TABLE Orders SET TAG [2] = '7 years';

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

ARetentionPeriod

BDataRetention

DOrderRetention

Attempts:

3 left

💡 Hint

Common Mistakes

Using different tag names in creation and assignment.

Misspelling the tag name.

The tag 'RetentionPeriod' is created and then assigned to the table 'Orders'. Both blanks require the same tag name.

5fill in blank

hard

Fill all three blanks to assign tags 'Confidentiality' with value 'Low', 'RetentionPeriod' with value '3 years', and 'Owner' with value 'FinanceTeam' to the table 'Invoices'.

Snowflake

ALTER TABLE Invoices SET TAG [1] = 'Low';
ALTER TABLE Invoices SET TAG [2] = '3 years';
ALTER TABLE Invoices SET TAG [3] = 'FinanceTeam';

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

AConfidentiality

BRetentionPeriod

COwner

DAccessLevel

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up tag names and values.

Using tag names that were not created.

Each tag is assigned with its correct value to the table 'Invoices'. The blanks correspond to the tag names in order.