Why governance ensures data trust at scale in Snowflake - Quick Recap

Recall & Review

beginner

What is data governance in the context of cloud data platforms like Snowflake?

Data governance is the set of rules, policies, and processes that ensure data is accurate, secure, and used properly across an organization.

beginner

How does governance help build trust in data at scale?

Governance ensures consistent data quality, security, and compliance, so users can rely on data for decision-making even as data volume grows.

intermediate

Name one key governance feature in Snowflake that supports data trust.

Role-based access control (RBAC) lets administrators control who can see or change data, protecting sensitive information.

intermediate

Why is auditing important in data governance?

Auditing tracks who accessed or changed data, helping detect misuse and ensuring accountability.

intermediate

What role does metadata management play in data governance?

Metadata management organizes information about data, making it easier to find, understand, and trust data assets.

What does data governance primarily ensure in a cloud platform?

A Data is only stored locally

B Data is deleted regularly

C Data is accurate, secure, and compliant

D Data is encrypted with no access

Data governance focuses on accuracy, security, and compliance to build trust.

Which Snowflake feature helps control who can access data?

A Virtual warehouses

B Data replication

C Data clustering

D Role-based access control (RBAC)

RBAC manages user permissions to protect data.

Why is auditing important in data governance?

A To speed up queries

B To track data access and changes

C To compress data

D To backup data automatically

Auditing provides accountability by tracking data usage.

What does metadata help with in data governance?

A Organizing and understanding data

B Encrypting data

C Deleting old data

D Increasing storage size

Metadata describes data to make it easier to find and trust.

How does governance support data trust at scale?

A By ensuring consistent quality and security as data grows

B By limiting data to small teams only

C By deleting data after use

D By ignoring compliance rules

Governance maintains trust even when data volume increases.

Explain how data governance helps maintain trust in data when an organization’s data grows large.

Think about rules and controls that keep data reliable and safe as more data is added.

Describe key governance features in Snowflake that support data trust.

Focus on how Snowflake controls access and tracks data usage.

Practice

1. What is the main purpose of data governance in Snowflake?

easy

A. To set rules that keep data safe and reliable

B. To speed up data loading processes

C. To create more storage space automatically

D. To delete old data without backup

Solution

1. Step 1: Understand the role of governance

   Governance is about setting rules and policies to protect and manage data.

2. Step 2: Identify the main goal

   The main goal is to keep data safe and reliable for users.

3. Final Answer:

   To set rules that keep data safe and reliable -> Option A

4. Quick Check:

   Governance = Data safety and reliability [OK]

Hint: Governance means setting rules for safe, trusted data [OK]

Common Mistakes:

• Confusing governance with performance tuning
• Thinking governance deletes data automatically
• Assuming governance creates storage space

2. Which Snowflake feature helps control who can see sensitive data?

easy

A. Data unloading

B. Warehouse scaling

C. Automatic clustering

D. Data masking policies

Solution

1. Step 1: Identify features related to data access

   Data masking policies hide sensitive data from unauthorized users.

2. Step 2: Exclude unrelated features

   Warehouse scaling, clustering, and unloading do not control data visibility.

3. Final Answer:

   Data masking policies -> Option D

4. Quick Check:

   Masking = Control data visibility [OK]

Hint: Masking policies hide sensitive data from unauthorized users [OK]

Common Mistakes:

• Confusing warehouse scaling with data access control
• Thinking clustering affects data visibility
• Assuming unloading controls data masking

3. Given this Snowflake SQL snippet:

CREATE MASKING POLICY ssn_mask AS (val STRING) RETURNS STRING ->
CASE WHEN CURRENT_ROLE() IN ('HR_ROLE') THEN val ELSE 'XXX-XX-XXXX' END;

What will a user with role 'SALES_ROLE' see when querying the SSN column?

medium

A. 'XXX-XX-XXXX' as masked value

B. The actual SSN value

C. An error message

D. NULL value

Solution

1. Step 1: Understand the masking policy logic

   The policy shows the real value only if the role is 'HR_ROLE'. Otherwise, it shows 'XXX-XX-XXXX'.

2. Step 2: Apply the policy for 'SALES_ROLE'

   Since 'SALES_ROLE' is not 'HR_ROLE', the user sees the masked value 'XXX-XX-XXXX'.

3. Final Answer:

   'XXX-XX-XXXX' as masked value -> Option A

4. Quick Check:

   Role not HR_ROLE = masked value [OK]

Hint: Masking shows real data only for allowed roles [OK]

Common Mistakes:

• Assuming all roles see real data
• Expecting an error instead of masked value
• Thinking masked value is NULL

4. You created a masking policy but users still see sensitive data. What is the likely cause?

medium

A. The warehouse size is too small

B. The masking policy syntax is incorrect

C. Users have roles that bypass the masking policy

D. Data is stored in an external stage

Solution

1. Step 1: Check role permissions

   Users with roles allowed by the masking policy see real data, bypassing masking.

2. Step 2: Exclude unrelated causes

   Incorrect syntax causes errors, not visible data; warehouse size and external stage do not affect masking.

3. Final Answer:

   Users have roles that bypass the masking policy -> Option C

4. Quick Check:

   Allowed roles see real data [OK]

Hint: Check user roles that bypass masking policies [OK]

Common Mistakes:

• Blaming warehouse size for masking issues
• Ignoring role permissions in masking
• Assuming external stage affects masking

5. How does combining role-based access control (RBAC) with masking policies help maintain data trust at scale in Snowflake?

hard

A. It speeds up query performance by caching data

B. It ensures only authorized users see sensitive data, while others see masked data

C. It automatically deletes data after a set time

D. It allows all users to see all data for transparency

Solution

1. Step 1: Understand RBAC and masking roles

   RBAC assigns roles to users controlling data access; masking policies hide sensitive data based on roles.

2. Step 2: Combine effects for trust

   Only authorized roles see real data; others see masked data, ensuring trust and security at scale.

3. Final Answer:

   It ensures only authorized users see sensitive data, while others see masked data -> Option B

4. Quick Check:

   RBAC + masking = trusted data access [OK]

Hint: RBAC plus masking controls who sees real vs masked data [OK]

Common Mistakes:

• Thinking governance deletes data automatically
• Confusing masking with performance features
• Assuming all users see all data