Data classification and tagging in Snowflake - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is data classification in Snowflake?

Data classification in Snowflake is the process of organizing data into categories based on its sensitivity, importance, or compliance requirements to help manage and protect it effectively.

beginner

What is the purpose of tagging data in Snowflake?

Tagging data in Snowflake means attaching labels or metadata to database objects to identify their characteristics, such as sensitivity or ownership, which helps in governance and access control.

intermediate

How does Snowflake enforce policies based on data classification tags?

Snowflake uses tags to apply masking policies or access controls automatically, ensuring that users see only the data they are authorized to access based on the classification labels.

intermediate

Which Snowflake feature allows you to create and manage tags?

Snowflake provides the CREATE TAG command to define tags and the ALTER TAG and DROP TAG commands to manage them. Tags can then be assigned to tables, columns, or other objects.

beginner

Give an example of a tag you might assign to a column in Snowflake.

An example tag could be 'PII' with values like 'Yes' or 'No' to indicate if a column contains Personally Identifiable Information, helping to enforce stricter access controls.

What is the main benefit of tagging data in Snowflake?

A To delete old data

B To speed up query performance

C To backup data automatically

D To organize data for better governance and security

Tagging helps organize data by adding metadata, which improves governance and security.

Which Snowflake command is used to create a new tag?

A CREATE METADATA

B CREATE LABEL

C CREATE TAG

D CREATE CLASSIFICATION

The correct command to create a tag in Snowflake is CREATE TAG.

What type of data might be tagged as 'Sensitive' in Snowflake?

A Public marketing data

B Customer credit card numbers

C System logs

D Archived data

Customer credit card numbers are sensitive data and should be tagged accordingly.

How can Snowflake use tags to protect data?

A By applying masking policies based on tags

B By compressing tagged data

C By moving tagged data to cold storage

D By deleting tagged data automatically

Snowflake can apply masking policies to data based on tags to protect sensitive information.

Which object types in Snowflake can have tags assigned?

A Tables and columns

B Only tables

C Only databases

D Only users

Tags can be assigned to tables, columns, and other database objects in Snowflake.

Explain how data classification and tagging help improve data security in Snowflake.

Think about how labels guide who can see or use data.

Describe the steps to create and assign a tag to a column in Snowflake.

Start with creating the tag, then attach it to the data.