Data classification and tagging in Snowflake - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Data Classification Tags in Snowflake

Which of the following best describes the purpose of data classification tags in Snowflake?

A To label data with metadata that helps control access and manage compliance

B To increase the storage size of tables for better performance

C To automatically encrypt all data in a database without user input

D To create backups of data at regular intervals

💡 Hint

Think about why you would want to add labels to data in a cloud environment.

Data classification tags in Snowflake are used to add metadata labels to data objects. These labels help with access control, auditing, and compliance management by identifying sensitive or regulated data.

❓ Configuration

intermediate

Applying a Tag to a Table Column in Snowflake

Given the tag PII already created, which SQL command correctly applies this tag to the email column of the users table?

A ALTER TABLE users ALTER COLUMN email SET TAG PII = true;

B ALTER TABLE users MODIFY COLUMN email SET TAG PII = 'true';

C ALTER TABLE users ALTER COLUMN email SET TAGS ('PII' = 'true');

D ALTER TABLE users ALTER COLUMN email SET TAG PII = 'true';

💡 Hint

Remember the exact syntax for setting a tag on a column in Snowflake.

The correct syntax to apply a tag to a column is ALTER TABLE <table> ALTER COLUMN <column> SET TAG <tag_name> = '<value>';. Option D matches this syntax exactly.

❓ Architecture

advanced

Designing a Tagging Strategy for Sensitive Data

You need to design a tagging strategy in Snowflake to identify and protect sensitive data across multiple schemas and databases. Which approach is best to ensure consistent classification and ease of management?

A Create a centralized set of tags at the account level and apply them consistently across all schemas and databases

B Apply tags only to tables, ignoring columns, to reduce tagging overhead

C Create unique tags for each schema to allow schema owners full control over classification

D Use tags only on views to avoid modifying base tables

💡 Hint

Think about how to maintain consistency and simplify management across many data objects.

Creating a centralized set of tags at the account level ensures consistent classification across all data objects and simplifies management and auditing. This approach avoids fragmentation and confusion.

❓ security

advanced

Impact of Data Classification Tags on Access Control

How can data classification tags in Snowflake be used to enhance security and access control?

A By automatically encrypting tagged data without additional configuration

B By integrating tags with masking policies to restrict sensitive data visibility based on user roles

C By preventing any user from querying tagged tables unless they have admin rights

D By duplicating tagged data into a separate secure database

💡 Hint

Consider how tags can work with other Snowflake features to protect data.

Tags can be used in combination with masking policies to dynamically control data visibility based on classification and user roles, enhancing security without blocking all access.

❓ service_behavior

expert

Behavior of Tag Inheritance in Snowflake

Consider a tag Confidential applied to a database in Snowflake. Which statement best describes how this tag behaves with respect to objects within that database?

A The tag is inherited only by tables but not by schemas within the database

B The tag is automatically inherited by all schemas and tables within the database unless explicitly overridden

C The tag applies only to the database object and does not propagate to schemas or tables

D The tag is inherited by all objects in the account regardless of their location

💡 Hint

Think about how tagging works at different object levels in Snowflake.

In Snowflake, tags are applied explicitly to individual objects. Applying a tag to a database does not automatically propagate it to schemas or tables inside it. Each object must be tagged separately.